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 '