connection problem

[rbsee]

I have two XP computers, with the same version of MySQL on each. I have the same database structure and data on each. Each computer has the same user name, and each MySQL database has the same user names. Locally on each, I can connect and work with the data. I can ping each computer from the other computer. My problem is that when I try to connect from one computer to the other I get the following error:

Host 'XXX.XXX.XX.XX' is not allowed to connect to this MySQL server.

This happens on both computers. I can not find the reason for the error.

 

[sleipnir214]

It's because MySQL user credentials are not just a 2-tuple of username and password. MySQL usercredentials are a 3-tuple of username, password, and IP address of connecting client.

Neither of your servers allows the user to connect from anything but localhost.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[rbsee]

What do I need to change to allow the user to connect from something other than localhost?

 

[sleipnir214]

Something like:

GRANT <permissions> on <database>.<tablespec> to <other machine's username>.'<other machines address>' identified by '<password>'


This will not affect your current localhost login if the usernames are the same -- a unique user is a username and IP address combo.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[rbsee]

I got the connection working. There is one part I don't understand.

My database is on Comoputer B.
I created the user with a password.

When logging in from Computer A, if I use a password, it fails. If I use an empty string for a password, it works.
I am missing another setting? Or is the security obtained because I have added the used to the database server?

 

[sleipnir214]

That means there's probably no password set.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!