[Ilugc] MySQL - unable to connect to MySQL db from another host on same LAN
- From: knura9@xxxxxxxxx (Arun Khan)
- Date: Wed, 6 Aug 2014 12:26:20 +0530
On Wed, Aug 6, 2014 at 12:16 PM, Balasubramaniam Natarajan
<bala150985 at gmail.com> wrote:
On Wed, Aug 6, 2014 at 12:09 PM, Arun Khan <knura9 at gmail.com> wrote:
1. Could you try logging in locally by adding an appropriate grant
statement ?
2. Try using the FQDN for the grant statement on mysql
server.
GRANT ALL ON YourDB.* TO 'root'@
'mysql_root_password';
FLUSH PRIVILEGES;
I have already done the following before trying to connect
GRANT ALL PRIVILEGES ON *.* TO 'root'@'A' WITH GRANT OPTION;
where A is the IP address and
GRANT ALL PRIVILEGES ON *.* TO 'root'@'aws-appsrv' WITH GRANT OPTION;
where aws-appsrv is resolved by /etc/hosts with the line.
A aws-appsrv
-- Arun Khan
Other related posts: