No Mysql and performance_schema databases are available when mysql is installed and running.

No Mysql and performance_schema databases are available when mysql is installed and running.

Mysql ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES)

No Mysql and performance_schema databases are available when mysql is installed and running.

Problem 1: Previously uninstalled and not uninstalled clean

Problem 2: you do not have the Administrator permission to access

Question 3: When logging on, the password is blank and anonymous logon is used.

In Windows

Method 1:

Add skip-grant-tables to the [mysqld] field of my. ini in the installation path.

Restart the mysql service. At this time, mysql can log on to the database without a password and then enter mysql.

Mysql> use mysql;

Mysql> update user set password = password ('new password') WHERE User = 'root ';

Mysql> flush privileges;

After running the command, remove skip-grant-tables from my. ini and restart mysqld.

Video link: http://www.tudou.com/programs/view/ZeHXZx4G6dk/

Method 2:

Without modifying my. ini to restart the service, you can add skip-grant-tables to run mysql in non-service mode to change the mysql password to stop the mysql service.

Open the command line window and start it with mysqld-nt.exe in the bindirectory. That is, run mysqld-nt -- skip-grant-tables in the command line window.

Open a command line window and log on to mysql. You do not need to enter the mysql password.

After changing the password, close the window in which the command line runs mysql. In this case, mysql is closed. If mysql is still running, stop the corresponding process.

Start the mysql service.