On Tuesday, July 13, 2010 02:25:33 pm Prabhat Kumar wrote: > GRANT ALL PRIVILEGES ON **.** TO username@'tuna.iamghost.com' IDENTIFIED BY > PASSWORD 'password'; > > **.** ie for all databases , if want on particular DB > > GRANT ALL PRIVILEGES ON *MyDATABASE.** TO username@'tuna.iamghost.com' > IDENTIFIED BY PASSWORD 'password';; >
You also need to verify that you don't have network connections turned off in /etc/my.cnf if you have skip-networking, comment it out also make sure that the bind-address is set to 192.168.0.100 and not to the localhost ip addrerss. One caution: the ip address you indicate appears to be one of the dynamically assigned ones by a router. If so, it's possible that it will change. You might want to switch to a static ip address for a server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org