You should definitely consider getting rid of them, otherwise people can log in to MySQL from any host with no credentials.
They are created during installation by the mysql_install_db script. This tells you how to remove them: http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html -Dan On 3/4/08 7:23 AM, "Hiep Nguyen" <[EMAIL PROTECTED]> wrote: > On Mon, 3 Mar 2008, Daniel Brown wrote: > >> On Mon, Mar 3, 2008 at 2:46 PM, Hiep Nguyen <[EMAIL PROTECTED]> wrote: >>> >>> mysql> select user,host,password from mysql.user; >>> +------+----------------------+------------------+ >>> | user | host | password | >>> +------+----------------------+------------------+ >>> | root | localhost | **************** | >>> | root | dev.jss.com | | >>> | | dev.jss.com | | >>> | | localhost | | >>> +------+----------------------+------------------+ >>> 4 rows in set (0.00 sec) >> >> Okay, I wasn't aware that it's all on the same server. Try this: >> >> USE mysql; >> UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE >> User='root' AND host='dev.jss.com' LIMIT 1; >> FLUSH PRIVILEGES; >> > do i have to worry about those don't have user name? what are they use > for? should i delete them??? > > t. hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
