Old 27th August 2012, 03:34
ezat ezat is offline
Junior Member
Join Date: Aug 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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,
Reply With Quote
Sponsored Links
Old 27th August 2012, 10:45
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts

These records are not from ispconfig. If you set them, it might affect other software.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Old 10th February 2013, 09:46
Ovidiu Ovidiu is offline
Senior Member
Join Date: Sep 2005
Posts: 1,269
Thanks: 84
Thanked 25 Times in 21 Posts

I have found exactly the same problem:

------- 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?
Reply With Quote
Old 10th February 2013, 15:42
Parsec Parsec is offline
Join Date: Jan 2013
Posts: 66
Thanks: 1
Thanked 9 Times in 8 Posts

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.
Reply With Quote
The Following User Says Thank You to Parsec For This Useful Post:
Ovidiu (11th February 2013)



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL / Paging and search results edge Programming/Scripts 3 23rd February 2010 03:38
No results fornd! freshcalm is already running! cheesewizz Installation/Configuration 1 24th March 2009 11:18
Tuning MySQL Performance with MySQLTuner VMartins Server Operation 3 28th October 2008 16:18
best place to change the number of returned results? greeblesnort General 5 20th December 2007 00:41
Sorting Results in MySQL badben Programming/Scripts 1 5th July 2006 15:28

All times are GMT +2. The time now is 04:34.

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