Tuesday, August 2, 2011

mysql newbie problem: Error 1045 (28000)

Tried to install mysql Community Edition on my PC just now and encountered the error message as shown in the screenshot below:

Error 1045 (28000): Access denied for user 'root@'localhost' (using password: NO)

Fortunately, the problem is very easy to solve and needs you to specify to the SQL command-line interpreter that you want to specify a different password to log into the root account.  You just need to type "mysql -u root -p" and press Enter.

The command-line tool will prompt you for your root password and once you supply the matching password, you will see the log-in screen as below:

Pin It

No comments:

Post a Comment