Guys - I am no expert but I don't think this is a DNS or rDNS issue.
All resolution appears to be working fine. When my PC (tuna) attempts
to connect to the MySQL server via MySQL Workbench, it says Failed to
Connect to MySQL at mysql.iamghost.com:3306 with user root
Host 'tuna.iamghost.com' is
Hi Carlos,
From your trailing mail I noticed the below GRANT. This will just give
'cmennens'@'ideweb1.iamorlando.com' access to mysql but not any databases.
*Access to mysql:*
| GRANT USAGE ON *.* TO 'cmennens'@'ideweb1.iamorlando.com' IDENTIFIED
BY PASSWORD '' |
In addition
On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar aim.prab...@gmail.com 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'
I am trying to connect to MySQL server [192.168.0.100] from my PC
[10.1.10.222] using MySQL Workbench and when I test the connection, I
get the following error:
Host 'tuna.iamghost.com' is not allowed to connect to this MySQL server.
Can someone please tell me what I need to do so I can allow
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';;
On Wed, Jul 14, 2010 at 12:44 AM,
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'
...@weblore.com]
Sent: Tuesday, July 13, 2010 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: Allowing Connections From Remote Clients
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