I already set the root password for the MySQL root user. That is why
in my 1st email you see the encrypted password listed for root in
localhost, mail, & 127.0.0.1.
Thanks for all your info. I followed Neil's steps and it worked
perfect...after I realised that those were two 's and not a single
qu
> delete from user where Password='';
> Be careful doing this on a fresh install, if you don't set
> passwords for root first you will delete all the initial root
> accounts too!
That is a good point. I always set the root password first.
I just assumed that he would do that firt, but it is
-Original Message-
From: Neil Aggarwal
Sent: 10 December 2009 01:19
To: mysql@lists.mysql.com
Subject: RE: Missing Entries
Carlos:
> I was checking my fresh install of MySQL and noticed I had empt spaces
> or missing entries in some sections when I did a search for users on
Carlos:
> I was checking my fresh install of MySQL and noticed I had empt spaces
> or missing entries in some sections when I did a search for users on
> the 'mysql' database.
According to this page:
http://dev.mysql.com/doc/mysql-security-excerpt/5.4/en/default-privileges.ht
ml
If you want to
I'm on my mobile so can't give you a link but you should read the reference
manual section on
'post-installation setup and testing'.
Regards
John Daisley.
-Original Message-
From: Carlos Williams
Sent: 09 December 2009 21:16
To: mysql@lists.mysql.com
Subject: Missing Entries
I was che
