MySQL Workbench sends computer name with login not IP

Posted by Android Addict on Server Fault See other posts from Server Fault or by Android Addict
Published on 2013-11-04T18:16:15Z Indexed on 2013/11/04 21:57 UTC
Read the original article Hit count: 380

Filed under:
|
|

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

© Server Fault or respective owner

Related posts about remote-access

Related posts about mysql5