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
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