127.0.0.1 vs localhost

Hello

Reading on the net i found that localhost (FOR LINUX) it will be a bit faster as it uses sockets but in practice some times it seems 127.0.0.1 to perform better

What do you use on your config files to connect to the database?

---

Thank you

 

If I am not wrong I think the my admin cli took when I create a user it uses only localhost and not 127.0.0.1 and if i have to add that by changing the related permissions setting....

 

If I am not wrong I think the Centminmod myadmin cli tool when I create a user it uses only localhost and not 127.0.0.1 and if i have to add that by changing the related permissions setting....

 

I just wondering why many users are getting better results using the 127.0.0.1 .....

Ok thanks

 

When i create a new database and add a user using:

Code:

/usr/local/src/centminmod/addons/mysqladmin_shell.sh setuserdb

then when i use on the config the "localhost" it works but if i use "127.0.0.1" it doesn't with an error permission denied....

Does the tool create the user with localhost access and restrict access for 127.0.0.1 or something related?

I have on my dns also:

Code:

127.0.0.1   localhost   localhost.localdomain localhost4 localhost4.localdomain4
::1     localhost   localhost.localdomain localhost6 localhost6.localdomain6
123.456.789.000   server.mydomain.com   server

On my second server with the exact same setup both working....

It will be great to find out why it doesn't work when i use 127.0.0.1 without setting the permissions to % or 127.0.0.1 as it can be done with localhost for both....

Don't know if it is related but the on that works it uses a very new Centminmod setup and the other one that doesn't work uses a very old Centminmod installation....

 

For the user that doesn't work i am getting:

Code:

--------------
SHOW GRANTS FOR 'forum_db'@'localhost'
--------------

+-------------------------------------------------------------------------------------------------------------------+
| Grants for forum_db@localhost                                                                                   |
+-------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'forum_db'@'localhost' IDENTIFIED BY PASSWORD '*DDFB5C91B43' |
| GRANT ALL PRIVILEGES ON `forum\_db`.* TO 'forum_db'@'localhost' WITH GRANT OPTION                             |
+-------------------------------------------------------------------------------------------------------------------+

and the working one is:

Code:

--------------
SHOW GRANTS FOR 'forum_db'@'localhost'
--------------

+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for forum_db@localhost                                                                                                                                   |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'forum_db'@'localhost' IDENTIFIED BY PASSWORD '*990E1234A40EBB8C'                                                 |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON `forum_db`.* TO 'forum_db'@'localhost' |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Any ideas?

Thank you


Also both use same dns settings:

Code:

127.0.0.1   localhost   localhost.localdomain localhost4 localhost4.localdomain4
::1     localhost   localhost.localdomain localhost6 localhost6.localdomain6
123.456.789.000   server.mydomain.com   server

 

Problem found

config file should not have skip networking

Now it works !

But don't know really if localhost is faster as a user report this:

and a tcp connection seems faster.... ?