mysql – how to overcome ERROR 1045 (28000): Access denied for user [email protected] (using password: NO) permanently

mysql – how to overcome ERROR 1045 (28000): Access denied for user [email protected] (using password: NO) permanently

for some reason, the ODBC user is the default username under windows even if you didnt create that user at setup time. simply typing

mysql

without specifying a username will attempt to connect with the non-existent ODBC username, and give:

Error 1045 (28000): Access denied for user [email protected] (using password: NO)

Instead, try specifying a username that you know, for example:

mysql -u root -p

where -u root specified the username root and -p will make the command prompt for a password.

You need to create an user ODBC for MySql with no password. Do that in PHPMyAdmin. That will solve your problem.

But remember, if its only your local development environment, no problem. Itll create a serious security hole in your production environment.

User

Problem

mysql – how to overcome ERROR 1045 (28000): Access denied for user [email protected] (using password: NO) permanently

I tried this and it worked:

C:cd MySQL installed pathMySQL -uyourusername -pyourpassword

Leave a Reply

Your email address will not be published.