On Wed, Mar 31, 2010 at 3:52 PM, Carlos Mennens <carlosw...@gmail.com>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

Reply via email to