RE: ALTER TABLE Denied

------=_NextPart_000_009B_01D1BD8E.4E9AD270
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Please forgive any ignorance or misunderstandings on my part=E2=80=A6

=20

The credentials are set correctly as far as I know and the fact that I =
make a connection would bear out this belief.    We were a bit puzzled =
by the address after the username at first but that appears to be the =
address where the connection originates???    I assume this is not =
something that one sets?    I can only assume that the cPanel is setting =
things correctly in the GRANT although that appears to be the problem.   =
We don=E2=80=99t have access to the root login or I would do a grant =
directly.   What puzzles me is why it works in workbench but not in =
ODBC.  Is there some setting in the ODBC that needs to be submitted?

=20

Thanks.

=20

Jim

=20

From: Simon Walter [mailto:[email protected]]=20
Sent: Friday, June 03, 2016 6:38 AM
To: Jim Taylor
Subject: RE: ALTER TABLE Denied

=20

I see. MySQL has a user@host format for the user. Is that set correctly? =




On June 3, 2016 8:27:34 PM GMT+09:00, Jim Taylor <[email protected]> =
wrote:

I do have some users who make use of the app on a separate machine =
("server" gets a bit ambiguous) but always within their local network.  =
This is the first time trying it on a truly "remote" machine/server.  As =
I mentioned, this is not a new process.  I have been running the process =
for years and never had an issue. =20

Jim

-----Original Message-----
From: Simon Walter [mailto:[email protected]]=20
Sent: Thursday, June 02, 2016 6:39 PM
To: [email protected]
Subject: Re: ALTER TABLE Denied

On 06/03/2016 06:57 AM, Jim Taylor wrote:
 I have an app that uses a local database but am moving it to a remote=20
 database.  I believe I have everything setup correctly regarding the=20
 connection as I can connect using Workbench and alter tables =
successfully.
 The problem is that when I
try altering tables via the ODBC  connection,
 using the same credentials, I get the Alter Table Denied message.   The
 process is tried and true so am reasonably certain I am going wrong in =
some
 other fashion.   I have granted permissions via CPanel and assume I =
couldn't
 make the changes via Workbench if the GRANT wasn't done properly.
 Suggestions?

Hi Jim,

I have noticed that some operations are not supported with the ODBC =
adapter. So that might be your limitation there. I have only ever used =
the ODBC adapter for SELECT, INSERT, and UPDATE.

Simon

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc





--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc


--=20
Sent from my Android device with K-9 Mail. Please excuse my brevity.


------=_NextPart_000_009B_01D1BD8E.4E9AD270--