I'm using a program that need access to my ClearOS 6.3 Mysql. My client IP is 192.168.111.75 and MySQL server at 192.168.111.200
1. I'm trying to edit /etc/my.cnf and add line bind-address=192.168.111.75 .
Failed! Mysql Daemon won't start.
2. I'm trying to add command to mysql :
but still :huh:
Any solution how to access to mysql remotely from my client?
1. I'm trying to edit /etc/my.cnf and add line bind-address=192.168.111.75 .
Failed! Mysql Daemon won't start.
2. I'm trying to add command to mysql :
$ mysql -u root -p
Enter password:
mysql> use mysql
mysql> GRANT ALL ON *.* to root@'192.168.111.75' IDENTIFIED BY 'your-root-password';
mysql> FLUSH PRIVILEGES;
but still :huh:
"Access denied for user 'root'@'192.168.111.75' ( using password : YES )
Any solution how to access to mysql remotely from my client?
In Database
Share this post:
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »