Re: user and hostname connection priveleges

James wrote: I had set up the following I have a MYSQL server running on let's say 123.xx.xx.xx User: user1 Host: 111.xx.xx.xx and gave that user the appropriate priveleges. How exactly? Did you use GRANT? Something like GRANT ALL ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY

Re: user and hostname connection priveleges

Hello. If you want to have a complete understanding of how MySQL access privilege system works, read this chapter of the manual: http://dev.mysql.com/doc/mysql/en/privilege-system.html James [EMAIL PROTECTED] wrote: I had set up the following I have a MYSQL server running on

user and hostname connection priveleges

I had set up the following I have a MYSQL server running on let's say 123.xx.xx.xx User: user1 Host: 111.xx.xx.xx and gave that user the appropriate priveleges. So. I tried to connect to the MYSQL server from 111.xx.xx.xx using user1, but it won't allow my to. I then had to add this