HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   mysqltuner results. (http://www.howtoforge.com/forums/showthread.php?t=58401)

ezat 27th August 2012 02:34

mysqltuner results.
 
Hello All,


Followed the perfect server ubuntu installation a while back. i thought i'd run mysqltuner.pl on it and somewhat found this..



-------- Security Recommendations -------------------------------------------
[!!] User '@localhost' has no password set.
[!!] User '@xxxxx.com' has no password set.

Has anyone come across this and if i do set passwords, will it break ispconfig3?

Many thanks,
Ezat

till 27th August 2012 09:45

These records are not from ispconfig. If you set them, it might affect other software.

Ovidiu 10th February 2013 08:46

I have found exactly the same problem:


Quote:

------- Security Recommendations -------------------------------------------
[!!] User '@h2118175.stratoserver.net' has no password set.
[!!] User '@localhost' has no password set.
How would i go about removing the cause of those warnings?

Parsec 10th February 2013 14:42

I'm guessing debian here..judging by your results.

If you look at those 2 users with phpmyadmin (users table in the mysql database), you will see that they have absolutely no privileges at all - so they can't do much.

I believe thay are designed for base mysql setup and often also install a "test" database - designed for people to mess with so you get used to mysql.

Just delete the test db's if you see them, the users really aren't a problem as they can't do anything except read - and no normal db's allow them as access.


All times are GMT +2. The time now is 01:21.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.