I am not new to Linux, but am "retooling" and getting back into the LAMP model and working to get everything configured and setup for my environment.
I am currently in the process of completing the installation and configuration of Ubuntu 16.04 (and MySQL 5.7)
I have installed MySQL Workbench v 6.3 on a local windows 10 box while Linux running on a remote box and MySQL on the same box as the remote. This is all taking place within the same firewall so I am not sending traffic outside of the firewall.
The problem is when I try to connect to the MySQL server from Workbench, I get the error message “Failed to Coinnect to MySQL at 127.0.0.1:3306 with root user.
Things that have been checked
- I can connect to MySQL while in an SSH session using Putty from the Windows 10 box and look at the tables that were setup during the MySQL install.
- I was able to create user accounts while in MySQL. So, I know MySQL is running.
I can ping 127.0.0.1 in the SSH session and I get confirmation the ping arrived at the address provided.
I have checked the mysqld.cnf in the /etc/mysql/mysql.conf.d/ directory for the bind-address which is = 127.0.0.1.
So, any help anyone can provide for resolution would be appreciated.