Problem logging in over MyODBC and SSH

When I define the connection details in the ODBC-Administrator and "Test"
the connection it says "Success; connection was made".

When I open MS-Access and try to connect it says "Access denied for user
'myuser'@'%' to database 'mydatabase' (#1044)"

Can anyone help?

Emile

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: Problem logging in over MyODBC and SSH

I assume you are using the ODBC DSN you set up to link to tables from MS
Access? It looks like you are getting to the server OK but are being
denied access. The thing to check I think would be the GRANT tables on
the server.

The user name reported in that error message looks odd to me too
'myuser'@'%'. You would think it should say something like myuser @
192.168.0.1 or similar. The syntax shown looks like something from a
GRANT command. I have never seen a message like that even though I do
use MySQL with Access.

John B.

-----Original Message-----
From: Emile Schenk [mailto:es@austroweb.at]=20
Sent: Sunday, 4 December 2005 6:37 AM
To: myodbc@lists.mysql.com
Subject: Problem logging in over MyODBC and SSH

When I define the connection details in the ODBC-Administrator and
"Test"=20
the connection it says "Success; connection was made".

When I open MS-Access and try to connect it says "Access denied for user

'myuser'@'%' to database 'mydatabase' (#1044)"

Can anyone help?

Emile


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

RE: Problem logging in over MyODBC and SSH

Hi guys,

The user 'myuser'@'%' isn't really all that suspicious. From personal
experience I would suggest that you have set up that user will all the
necessary privileges, but you have not yet flushed the privileges. In this
case the driver itself can establish a connection to the engine, but the
engine won't allow the user to access any tables as there are no privileges
yet granted to him. Open the query browser or the console and to issue a
"flush privileges" command. After that it should work (given that you have
given the right set of privileges to that user).

Best regards,

Wolfgang Schulze-Zachau


-----Original Message-----
From: jbonnett@sola.com.au [mailto:jbonnett@sola.com.au]
Sent: 06 December 2005 23:34
To: es@austroweb.at; myodbc@lists.mysql.com
Subject: RE: Problem logging in over MyODBC and SSH

I assume you are using the ODBC DSN you set up to link to tables from MS
Access? It looks like you are getting to the server OK but are being
denied access. The thing to check I think would be the GRANT tables on
the server.

The user name reported in that error message looks odd to me too
'myuser'@'%'. You would think it should say something like myuser @
192.168.0.1 or similar. The syntax shown looks like something from a
GRANT command. I have never seen a message like that even though I do
use MySQL with Access.

John B.

-----Original Message-----
From: Emile Schenk [mailto:es@austroweb.at]
Sent: Sunday, 4 December 2005 6:37 AM
To: myodbc@lists.mysql.com
Subject: Problem logging in over MyODBC and SSH

When I define the connection details in the ODBC-Administrator and
"Test"
the connection it says "Success; connection was made".

When I open MS-Access and try to connect it says "Access denied for user

'myuser'@'%' to database 'mydatabase' (#1044)"

Can anyone help?

Emile


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:
http://lists.mysql.com/myodbc?unsub=wolfgangs@manticoreit.co m


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org