I am getting this error: ERROR 1045 (28000): Access denied for user 'ipcuser'@'' (using password: YES)

The database is Percona MySQL 5.6 and is on the IP

We have servers in the 10.0.0.x range. Testing from different servers we get different results using the exact same command: mysql -u ipcuser -pPASSHERE -h -D ipc --protocol=tcp
The issue came up over night when nothing has changed and no one was working. No code changes at all. No database changes. The database was last restarted 4 days ago before attempting today.

The results of trying to connect from: Connects Connects Access Denied Access Denied Access Denied  

Output from: SELECT user, host FROM mysql.user;

ipcuser     10.0.0.%  
ipcuser     localhost  
root        ::1  
root        localhost  

Already tested:
- Restarting MySQL
- Adding in the specific IP of the server (that would be the address in the above output, removing it has no change)
- Restarting the network on both the DB and failed connections
- Checking the error log. Nothing.
- Disabling firewalls. None of the connecting servers nor the DB had iptables running.
- Changing the bind

Also for some extra weirdness, I was able to connect once from the IP, but after issuing a query it disconnected me and on attempting to reconnect gave access denied.

After more testing, I shut the MySQL server down and the servers failed to connect were still getting a specific access denied error. The ones that had successful connections got could not connect.

1 Answer 1


The problem has been fixed. It was not due to anything MySQL.

We have multiple DB servers, another one was assigned the same IP ( and neither server picked up on it when doing an ifup. This would explain why some worked and others didn't, as well as when we got MySQL responses when it was supposedly down.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.