Re: How do I allow quering the db not from localhost ?

[Umesh Shastry]

Hi!!

On the mysql server login with user root (any use who has got GRANT privileges..)..

mysql> GRANT ALL PRIVILEGES ON dbname.*
-> TO 'maxim'@'192.168.2.0/255.255.255.0' IDENTIFIED BY 'maxim123';
mysql>FLUSH PRIVILGES;

or

mysql> GRANT ALL PRIVILEGES ON dbname.*
-> TO 'maxim'@'192.168.2.%' IDENTIFIED BY 'maxim123';
mysql>FLUSH PRIVILGES;

Now the user maxim can connect to this dbname from any where..(192.168.2.0/255.255.255.0)


Also you can do this by updating mysql.user's Host column for that user..

Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221