Can you create an SSH tunnel to the target machine?.Can you reach the target machine your MySQL runs on?.Do you have a running network adaptor on the machine you run Workbench on? Does it allow TCP/IP connections?.The error message says clearly the MySQL server could not be reached, hence check everything that could block access to it. Help is much appreciated because I already tried everything I was able to research. ssh to the remote machine ( ssh login to mysql server ( mysql -u root -p).When I do, what Workbench is supposed to do Passwords are set, they are typed correctly when logging in.
#Cannot connect to database server mysql workbench password
There is no bind-address or skip-networking directive set.Ĥ Make sure you are both providing a password if needed and using theĬorrect password for 127.0.0.1 connecting from the host address you're # The files must end with '.cnf', otherwise they'll be ignored. # * IMPORTANT: Additional settings that can override those from this file! # -print-defaults to see which it would actually understand and use. # Run program with -help to get a list of available options and with
# One can use all long options that the program supports. # - "~/.my.cnf" to set user-specific options. # - "/etc/mysql/my.cnf" to set global options, # The MySQL database server configuration file. Nonetheless I tried setting the host to % as a wildcard but that didn't change anything either so I switched back to default localhost. I checked the er table and it says that root has the host: localhost and since MySql-Workbench does an ssh connect to the remote machine and then connects to the MySql-Server, localhost should be fine. Then it gives me a list with things to check.ġ Check that mysql is running on server 127.0.0.1Ģ Check that mysql is running on port 3306ģ Check the root has rights to connect to 127.0.0.1 from your address Server at 127.0.0.1:3306: Can't connect to MySQL server on
Your connection attempt failed for user 'root' from your host to The connection method is: Standard TCP/IP over SSH Remote Machine: Ubuntu 16.04, with MySql-Client 5.7 and MySql-Server 5.7 It also provides information on connections, traffic, load, and more.Local machine: Xubuntu 17.10, with MySql-Workbench 6.3 The Server Status screen tells you whether MySQL is running or not, as well as displaying information about server features, server directories, SSL, authentication, connection name, etc.
You will now see the Server Status screen, displaying server status and related information: The “Server Status” screen, displaying status information about the MySQL server. Click the Server Status LinkĬlick Server Status from the Management tab in the left navigation pane: The “Server Status” link under the Management tab on the left navigation pane. If you have many MySQL connections, they will be listed here, for you to choose one to connect to. Using MySQL Workbench, click the MySQL connection (as you would normally do when connecting): Opening MySQL Workbench brings you to the “MySQL Connections” screen. The Server Status window will appear, displaying the server’s status and related information:īelow are screenshots for the above steps. Click Server Status from the Management tab in the left navigation pane.Click the MySQL connection (as you would normally do when connecting via MySQL Workbench).To check the status of a MySQL server using the MySQL Workbench GUI:
0 kommentar(er)
