[BlueOnyx:20079] GUI replacing localhost with 127.0.0.1

Dogsbody dan at dogsbody.org
Wed Sep 7 06:25:54 -05 2016


Hi Michael,

I *think* it's the GUI that is replacing localhost with 127.0.0.1.

Not a huge issue except for MySQL.  Customers are complaining that they
can't setup sites with the MySQL details for new sites.
Sure enough, trying this on the command line

$ mysql -u vsite_kvqYhnl -p
Enter password:
ERROR 1045 (28000): Access denied for user 'vsite_kvqYhnl'@'localhost'
(using password: YES)

$ mysql -u vsite_kvqYhnl -p -h localhost
Enter password:
ERROR 1045 (28000): Access denied for user 'vsite_kvqYhnl'@'localhost'
(using password: YES)

$ mysql -u vsite_kvqYhnl -p -h 127.0.0.1
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1373072
Server version: 5.1.73 Source distribution
mysql>

Checking the MySQL user table show that "127.0.0.1" is being stored as
the host instead of "localhost" as we entered.

For clarity, when you use "127.0.0.1" then you can only login using
"127.0.0.1" however when you use "localhost" you can login with either
"localhost" or "127.0.0.1".

I hope this can be fixed and/or helps anyone else having this problem.

Dan



More information about the Blueonyx mailing list