MySQL: Access denied using 127.0.0.1 but OK using localhost.

[zhongshan]

Hello,

I've recently replaced an older server and after migrating all the accounts I'm having many customers not being able to connect to MySQL using the address '127.0.0.1' but they're being able to connect using 'localhost'. I know I could just allow '%' or even '127.0.0.1' but I would like to find the solution because I'm getting more and more tickets about this and I find it very annoying as localhost and 127.0.0.1 are the same thing.

I'm using:

Server version: 10.3.23-MariaDB-cll-lve MariaDB Server

Thank you

 

[cPanelLauren]

This mariadb article goes over this: Configuring MariaDB for Remote Client Access

 

[zhongshan]

This mariadb article goes over this: Configuring MariaDB for Remote Client Access

Hi, thank you for your reply.

I don't see any relation other than the mention of "Granting User Connections From Remote Hosts" but that's what I don't want to do, I don't want to have to alllow 'everyaccount'@'%'. None of all my servers have that problem, and there are no grants to users with the host '127.0.0.1'.

 

[cPanelLauren]

The connection I believe is in the bind-address configuration which they discuss there right at the beginning of the article. It does not require grants but is a known issue users experience with MariaDB when attempting to connect over TCP whether using 127.0.0.1 or a different IP. MySQL tries to connect using a socket when you use localhost, but it uses TCP when you connect to 127.0.0.1, and the permissions can even be set differently for localhost and 127.0.0.1, which is why I linked you that specific article.

A quick google search also shows you a number of others with the same questions:

MySQL: Able to connect to localhost but not to 127.0.0.1

I am guessing I am forgetting something obvious, but I can't seem to connect to 127.0.0.1 using MySQL. Connecting via localhost works. MySQL / Linux version: Server version: 10.0.31-MariaDB-0ubunt...

stackoverflow.com

MySQL cannot connect via "localhost", only 127.0.0.1

this is somewhat of a mystery to me. The only way I can connect to MySQL is if I call it via "127.0.0.1" ... for example, my PHP connect script will NOT work with localhost I'm running Mac OS X Li...

serverfault.com

mysql connects to localhost but not 127.0.0.1

Im in Ubuntu 16.04.5 LTS if I do mysql -h localhost -u root I can connect with no issues. But if I do, mysql -h 127.0.0.1 -u root I get: ERROR 1698 (28000): Access denied for user 'root'@'local...

serverfault.com

What I linked you looks to be the most relevant information but the articles listed may provide other advice.