Question

Workbench Remote Connection to nging mysql

Hi folks, I am pretty new to this, whole server management I always user serverpilot. Now I wanted to set up It on my own. I followed this guide, https://www.digitalocean.com/community/tutorials/how-to-deploy-a-laravel-application-with-nginx-on-ubuntu-16-04 and got everything up and running with SSL. I disabled the ssh access with password and use a ssh_key

Now I just wanted a GUI to manage the mysql database. I tried that tut https://www.digitalocean.com/community/tutorials/how-to-connect-to-a-mysql-server-remotely-with-mysql-workbench But I always get errors either

Can't connect to MySQL server on '127.0.0.1' (61)

or

Lost connection to MySQL server at 'reading initial communication packet', system error: 0

I tried following things:

In /etc/mysql/mysql.conf.d/mysqld.cnf

  • Comment line bind-address changed address to server ip address
sudo ufw allow 3306/tcp
sudo service ufw restart
mysql> GRANT ALL ON db_name.* TO patrick@xxx.xxx.x.xxx IDENTIFIED BY ‘my_password/';

xx.xx.xx.xx my local IP address of laptop/desktop

Or

mysql> GRANT ALL ON *.* TO 'patrick'@'%’;
FLUSH PRIVILEGES; 

Always restart mysql-server after changing

service mysql restart

The mysql workbench parameters are: SSH Hostname: SERVER_IP_ADRESS:22 SSH Username: ssh username I use to connect via ssh username@serveripaddress SSH Key File: path to .ssh/id_rsa MySQL Hostname: Localhost or 127.0.0.1 or Empty MySQL Server Port: 3306 Username Patrick

If I click “Test Connection” it prompts me for a password, enter the password the described errors appear.

Stuck here since 3 days.

G patrick

Subscribe
Share

hey there, I am facing this problem too. Any solution?


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hello,

If you are using Workbench to connect to MySQL via SSH you don’t have to change the bind-address. It should work out of the box with the rest of the things that you’ve done.

Besides that, if you stick to the things that you’ve done, I would just suggest changing your bind-address to 0.0.0.0, restart MySQL and then it should work.

Regards, Bobby

This comment has been deleted