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