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:



Comments

Popular posts from this blog

How to create an organizational chart in your webpage using Google Organization Chart Tools

Embed JSX code with if condition in React app

How to remove “Git” from Windows 7 context menu