Forums

Andi  Riza
Andi Riza
Offline
Resolved
-1 votes
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 :
$ 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?
Monday, January 07 2013, 03:31 AM
Share this post:
Responses (3)
  • Accepted Answer

    Tuesday, January 08 2013, 10:02 AM - #Permalink
    Resolved
    0 votes
    Hello Andi!

    Glad to hear that, but as I mentioned before, the '%' sign allows access from everywhere, so you should try to determine proper IP/hostname of your client and add it to mysql and disable access from whole world.
    The reply is currently minimized Show
  • Accepted Answer

    Andi  Riza
    Andi Riza
    Offline
    Tuesday, January 08 2013, 12:16 AM - #Permalink
    Resolved
    0 votes
    Hi Piotr

    Thanks for the tips. It work :)
    The reply is currently minimized Show
  • Accepted Answer

    Monday, January 07 2013, 10:05 AM - #Permalink
    Resolved
    0 votes
    Hello Andi!

    Did you try to temporary replace '192.168.111.75' with '%' sign ? This will allow you to remote access from any host, and could eliminate host/ip mismatch.
    The reply is currently minimized Show
Your Reply