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.
