On Wed, Mar 31, 2010 at 3:52 PM, Carlos Mennens 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 t
On Wed, Mar 31, 2010 at 3:07 AM, Johan De Meersman wrote:
> On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens
> wrote:
>>
>> 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?
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 wrote:
> Today I installed MySQL 5.1.45-1 on my production server and it
> recommended that I run the follo
On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens wrote:
> 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?
>
Totally false. It's convenient, and probably all of their scripts
