List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:March 31 2010 2:24pm
Subject:Re: Secure Install Removed Root Accounts
View as plain text  
On Wed, Mar 31, 2010 at 3:52 PM, Carlos Mennens <carloswill@stripped>wrote:

> mysql> CREATE USER 'carlos'@'localhost' IDENTIFIED BY 'holla';
> mysql> GRANT ALL PRIVILEGES ON *.* TO 'carlos'@'localhost' WITH GRANT
> OPTION;
>

Pretty much. It's also a good idea to give that user SUPER privileges, as
that'll allow you to use the one spare connection that can't be used by
regular users when your connection pool fills up. It should be given with
"all privileges", but better safe than sorry :-p

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

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