List:General Discussion« Previous MessageNext Message »
From:Michael Satterwhite Date:July 13 2010 7:54pm
Subject:Re: Allowing Connections From Remote Clients
View as plain text  
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.

Thread
Allowing Connections From Remote ClientsCarlos Mennens13 Jul
  • Re: Allowing Connections From Remote ClientsPrabhat Kumar13 Jul
    • Re: Allowing Connections From Remote ClientsMichael Satterwhite13 Jul
      • RE: Allowing Connections From Remote ClientsGavin Towey14 Jul
Re: Allowing Connections From Remote ClientsCarlos Mennens14 Jul
  • Re: Allowing Connections From Remote Clientsjayabharath27 Jul
Re: Allowing Connections From Remote ClientsCarlos Mennens26 Jul