problem connecting to linux mysql via MyODBC

Greetings.

I have a mysql database running on a Linux Debian box, and I need to
access the box from Excel on Windows. I've installed MyODBC 3.51 on the
Windows computer, and I've created a mysql user on the linux box with:

grant all on *.* to "odbcuser" identified by "shipping"

But when I try to use the ODBC Data Source Administrator to add a new
user DSN, I can't successfully make a connection.

What am I doing wrong? (I set this up a year or so ago, but for the
life of me, I can't remember what worked :-( )

Thanks in advance for any help.

Kenn


--
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 connecting to linux mysql via MyODBC

Hi Kenn,

There are several possibilities why this can go wrong.
1.) If this is a new user, you must flush the privileges after defining =
the
user. User privileges are cached in the server.
2.) If you have installed your mysql server from any of the normal linux
distros (mine is from Ubuntu 5.1) then by default the server is bound to =
the
loopback address (127.0.0.1) to prevent accidental access from other
machines. Find the my.cnf file (usually in /etc/mysql/my.cnf) and =
comment
out the line that says bind-address 127.0.0.1. Then restart your server
using "/etc/init.d/mysql restart". Please note that afterwards your =
server
is open to listen to connections from all IP addresses, so make sure =
your
firewall is properly configured and your user configuration is adequate.
Particularly the root user !!!
3.) Not all releases of the MyODBC connector 3.51 are working properly =
with
all versions of MySQL Server. I use version 3.51.12, which connects fine =
to
both my 5.0 Server (under Win XP) and my 4.0.24 server (under linux). I =
have
seen tons of blogs of other version of the ODBC driver causing trouble.

Hope this helps. If not let me know.

Best regards,
=20
Wolfgang Schulze-Zachau
=20

-----Original Message-----
From: kenn [mailto:kenn@printussery.com]=20
Sent: 24 March 2006 14:03
To: myodbc@lists.mysql.com
Subject: problem connecting to linux mysql via MyODBC

Greetings.

I have a mysql database running on a Linux Debian box, and I need to
access the box from Excel on Windows. I've installed MyODBC 3.51 on the
Windows computer, and I've created a mysql user on the linux box with:

grant all on *.* to "odbcuser" identified by "shipping"

But when I try to use the ODBC Data Source Administrator to add a new
user DSN, I can't successfully make a connection.

What am I doing wrong? (I set this up a year or so ago, but for the
life of me, I can't remember what worked :-( )

Thanks in advance for any help.

Kenn


--=20
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:
http://lists.mysql.com/myodbc?unsub=3Dwolfgangs@manticoreit. com


--
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 connecting to linux mysql via MyODBC

Try

grant all on *.* to 'odbcuser'@'%' identified by 'shipping'

It may be a host access problem.

John B.

-----Original Message-----
From: kenn [mailto:kenn@printussery.com]=20
Sent: Saturday, 25 March 2006 12:33 AM
To: myodbc@lists.mysql.com
Subject: problem connecting to linux mysql via MyODBC

Greetings.

I have a mysql database running on a Linux Debian box, and I need to
access the box from Excel on Windows. I've installed MyODBC 3.51 on the
Windows computer, and I've created a mysql user on the linux box with:

grant all on *.* to "odbcuser" identified by "shipping"

But when I try to use the ODBC Data Source Administrator to add a new
user DSN, I can't successfully make a connection.

What am I doing wrong? (I set this up a year or so ago, but for the
life of me, I can't remember what worked :-( )

Thanks in advance for any help.

Kenn



--
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