MySQL startup problem (ERROR 1045 (28000): Access denied for user’ODBC’@’localhost’ (using password: NO))

2011-03-18 wcdj
The solution is as follows:
(1) open mysql service because I installed the selected manual boot at that time.
(2) add the bin directory of mysql installation to the system PATH environment variable, using; (semicolon) partition.
(3) then open CMD and type the command: mysql-u username -p password. Enter mysql-u root-p my root password on my machine, and you will be able to enter mysql.
As shown in the figure below:

Reset password:
$mysql -u root -p
login password # mysql server mysql> Use mysql # using mysql database
mysql> Update user set password= password (“123456”) where user =’root’ # update user password
mysql> Flush privileges # to refresh the permissions
mysql> Quit # Quit the mysql server

Read More: