MySQL Forums
Forum List  »  MySQL Workbench

Re: Workbench on Ubuntu 20.04 Focal Fossa
Posted by: Kevin Jaspan
Date: April 29, 2020 11:52AM

I made further progress. Firstly I followed the instructions in
https://linuxconfig.org/error-2003-hy000-can-t-connect-to-mysql-server-on-111-solution
changing the bind-address in mysqld.conf and restarting mysql

then from

https://stackoverflow.com/questions/19101243/error-1130-hy000-host-is-not-allowed-to-connect-to-this-mysql-server at bookmark 276

I ran
CREATE USER 'root'@'ip_address' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip_address';
and
CREATE USER 'root'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;

At this stage I could successfully connect to the remote Mysql instance with the command
mysql -uroot -p -h<hostid>

but I still get the exact same tunnelling error when trying to connect via Mysql Workbench.

The SSH hostname is the ip address of the Mysql server host and the SSH username is root. The Mysql hostname I have as 127.0.0.1 and the port 3306 and the username is root.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Workbench on Ubuntu 20.04 Focal Fossa
580
April 29, 2020 11:52AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.