Access denied for user ' Bruce ' @ ' localhost ' to database ' Dbbruce '

Create the database ' Dbbruce ' when the user ' Bruce ' is created locally. -----------"MySQL tip: Access denied for user ' Bruce ' @ ' localhost ' to database ' Dbbruce '

How to resolve:

1. After logging into the database with the root user, query the table User:

----"SELECT * from Mysql.user;

2, the table has a lot of ' _priv ' End of the field, the user ' Bruce ' corresponding to the fields are all changed to ' Y '.

3. Right click on ' My Computer ' and ' manage ' to find ' service ' and turn off MySQL service.

4. Restart the MySQL service, log into the database with ' Bruce ' and create a database. Created successfully.

Note: The username of Access denied for user ' Bruce ' @ ' localhost ' to database ' dbbruce ' is more than just ' Bruce ' full name should be ' Bruce ' @ ' localhost ', that is: username kimono The name of the service device.

Access denied for user ' Bruce ' @ ' localhost ' to database ' Dbbruce '