> [EMAIL PROTECTED] doesn't have a password yet. You need to > mysqladmin -u root password "newpwd" > where "newpwd" is the password you want for root. > After setting the password for [EMAIL PROTECTED], you can connect with > mysql -u root -p > I'd suggest that [EMAIL PROTECTED] is a bad idea, so I'd > > DELETE FROM mysql.user WHERE user='root' AND host='%'; > FLUSH PRIVILEGES; > > but if you want it, you should definitely set a password for it as well. > In that case,
Being new to MySQL admin stuff, it would seem to me that you would lose all sorts of valuable capabiltiies if you delete the root user from the MySQL table? -- Whil Moving to Linux: Freedom, Choice, Security, Opportunity http://www.hentzenwerke.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]