On the Ubuntu 18.04 server, run the following command to install MySQL server: apt-get install mysql-server -yĪfter installing the MySQL server, you will need to set the MySQL root password, as MySQL is configured to login without a password by default.įirst, access the MySQL shell with the following command: mysql MySQL Workbench supports MySQL server versions 5.6 and higher, so you will need to install a MySQL server version greater than 5.6 in your first server.
apt-get update -y Step 2 – Install and Configure MySQL Server Once you are logged in to your Ubuntu 18.04 server, run the following command to update your base system with the latest available packages. Connect to your Cloud Server via SSH and log in using the credentials highlighted at the top of the page. Create a new server, choosing Ubuntu 18.04 as the operating system with at least 1GB RAM. Step 1 – Create Atlantic.Net Cloud Serverįirst, log in to your Atlantic.Net Cloud Server. A root password configured on both systems.
A fresh Ubuntu 18.04 Desktop installed on your local system.A fresh Ubuntu 18.04 VPS on the Atlantic.Net Cloud Platform.In this tutorial, we will install MySQL server on one Ubuntu 18.04 server, install MySQL workbench on another Ubuntu 18.04 desktop and connect MySQL server with MySQL Workbench interface. It has an ability to create multiple models in the same environment and supports all objects including tables, views, triggers, and stored procedures. MySQL Workbench’s aim is to provide a simple and easy-to-use interface for working with databases. It is specially designed to enable database administrators, developers and database architects to visually design, generate, model and manage databases. Try to isolate the actual problem (is it network related or a config problem?).MySQL Workbench is a graphical and visual database designing tool for MySQL servers and databases. However, the general idea should be clear now. Point 6 can be a bit more complicated, if your MySQL server is not on the same machine as where the SSH endpoint is or if it has networking disabled or if it uses a different port than what you tried. If you can answer all that with yes there should be no problem connecting to the MySQL server from MySQL Workbench. Can you reach the MySQL server when you are logged in on the target machine (e.g.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. 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 Local machine: Xubuntu 17.10, with MySql-Workbench 6.3