List:General Discussion« Previous MessageNext Message »
From:John Daisley Date:March 31 2010 7:17am
Subject:Re: Secure Install Removed Root Accounts
View as plain text  
If you only want root to be able to log in locally then you only need
'root'@'localhost' unless you are using tcp connections.

regards
John

On Tue, Mar 30, 2010 at 11:25 PM, Carlos Mennens <carloswill@stripped>wrote:

> Today I installed MySQL 5.1.45-1 on my production server and it
> recommended that I run the following:
>
> /usr/bin/mysql_secure_installation
>
> When I ran this, it simply guided me to do the following:
>
> - set root password
> - disable remote login for root
> - remove 'anonymous' user accounts
> - delete 'test' database
> - reload privileges now
>
> After doing all the above, I checked my user table and noticed that it
> also removed 'root@stripped' & 'root@hostname' accounts. I recall
> hearing from many admins that MySQL expects and needs there to be
> three accounts for root. Them being 'localhost', 127.0.0.1, and
> hostname. Is this false information?
>
> mysql> select User, Password, Host from user;
> +------+-------------------------------------------+-----------+
> | User | Password                                  | Host      |
> +------+-------------------------------------------+-----------+
> | root | *951527F19014ABEFD0390B1409B4CCA97F86AE1F | localhost |
> +------+-------------------------------------------+-----------+
> 1 row in set (0.00 sec)
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>

Thread
Secure Install Removed Root AccountsCarlos Mennens31 Mar
  • Re: Secure Install Removed Root AccountsJohan De Meersman31 Mar
    • Re: Secure Install Removed Root AccountsCarlos Mennens31 Mar
      • Re: Secure Install Removed Root AccountsJohan De Meersman31 Mar
  • Re: Secure Install Removed Root AccountsJohn Daisley31 Mar