Search code examples
mysqlubuntusshterminalnavicat

can't connect to remote mysql database via navicat

I have a mysql database on an unmanaged rackspace cloud server. I can connect to phpmyadmin with no issues. I checked if port 3306 is listening and it is. /etc/mysql/my.conf shows bind-address = 127.0.0.1.

When I use navicat to connect via ssh, it says SSH tunnel: Invalid username or password! I've reset my passwords and restarted mysql and the server just to make sure but I still can't connect. What can I try next to get this working?

Solution

  • Please connect to MySQL and run

    SELECT USER(),CURRENT_USER();

    What does this output ???

    • USER() reports how you attempted to authenticate in MySQL
    • CURRENT_USER() reports how you were allowed to authenticate in MySQL

    If the output of these two functions do not match, you will need to create a user that matches the USER() or CURRENT_USER().

    If they are both root@localhost, please run

    SELECT user,host,password FROM mysql.user;

    Now, visible compare if all root users have the same password.

    Also, please check the contents of /etc/hosts on the server.

    This not fully an answer, but I hope this helps !!!