#1  
Old 27th August 2012, 02: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,
Ezat
Reply With Quote
Sponsored Links
  #2  
Old 27th August 2012, 09:45
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,421
Thanks: 834
Thanked 5,500 Times in 4,329 Posts
Default

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
  #3  
Old 10th February 2013, 08:46
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,266
Thanks: 82
Thanked 24 Times in 20 Posts
Default

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

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)
Reply

Bookmarks

Tags
mysqltuner

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 02:38
No results fornd! freshcalm is already running! cheesewizz Installation/Configuration 1 24th March 2009 10:18
Tuning MySQL Performance with MySQLTuner VMartins Server Operation 3 28th October 2008 15:18
best place to change the number of returned results? greeblesnort General 5 19th December 2007 23:41
Sorting Results in MySQL badben Programming/Scripts 1 5th July 2006 14:28


All times are GMT +2. The time now is 15:30.


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