MySQL Workbench sends computer name with login not IP
- by Android Addict
I am attempting to connect MySQLWorkbench to a remote MySQL Server.
The server has granted access to
user@IPAddress
However, when I try to connect MySQLWorkbench, it sends
user@computername
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.
EDIT
What I have tried so far:
from the server:
mysql -u user@IPAddress -p --host=(ServerIPAddress)
Returns:
mysql>
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
