I am attempting to connect MySQLWorkbench to a remote MySQL Server.
The server has granted access to
However, when I try to connect MySQLWorkbench, it sends
instead. How do I configure the connection to use the IP address instead in MySQLWorkbench?
Reference: The remote server is on the local network, so I need to use the local IP address assigned to my client.
What I have tried so far:
sudo service mysql start --skip-name-resolve
from the server:
mysql -u user@IPAddress -p --host=(ServerIPAddress)
So that tells me the user account is operational. Furthermore, I confirmed it exists using:
select user from mysql.user;
returning a table of all users, of which the user I am using is present.
I have also opened the port 3306:
sbin/iptables -A INPUT -i eth0 -s clientIPAddress -p tcp --destination-port3306 -j ACCEPT
Still I encounter
Access Denied for user user@ComputerName (using password: YES)
Answer: I deleted the original user account
DROP USER 'user@IPAdress'
and added it back:
GRANT ALL on foo.* To 'user'@'IPAdress' IDENTIFIED BY 'password';
The tick locations are significant as the user name was actually:
MySQLWorkbench is now able to connect!