mySQL on Linux; 1130 error

[lee@geistlinger.com]

I'm just trying out this tool for the first time.

I'm trying to connect to my linux box via the “connection” wizard, and I get the following error message:

Error No. 1130

Host “myWin2000box” is not allowed to connect to this MySQL Server

Do I need to create an ODBC connection to the Linux box? If so, install the driver on the Windows box (and where to find it??).

Thanks in advance; this is a rockin' tool from the looks of it. I'm aching to try it out.

[lee@geistlinger.com]

Took a little googling, but I I've answered my own question.

Have to add the remote host (the Windoze2000 box) to the list of user's in mySQL on the Linux box (by default, mySQL is only available to the box on which it is installed).

Update the “user” table of the “mysql” database to have a host and username (note — this username is good only coming from that host…).

Does the trick.

[Ritesh]

Hello

That is exactly the solution I was going to tell you

[walkerk]

You CAN access from more than a single host. There is a nice description of the “host” field possibilities at:

http://www.mysql.com/doc/en/Connection_access.html

[Author]

Posts