After mysql creates a database, the following error occurs: Access denied for user 'root' @ '%' to database 'xxx'. mysqldenied

After mysql creates a database, the following error occurs: Access denied for user 'root' @ '%' to database 'xxx'. mysqldenied

Preface

Recently, I encountered a problem during my work. I encountered an error when I connected to the database after creating the database. The error code is Access denied for user 'root' @ '%' to database 'xxx ', after finding relevant information, I finally solved this problem. So I want to summarize it and share it with my friends who need it. Let's take a look at it.

Solution Process

1. Create a database

Create database mytest;

2. When connecting to the database, the following error is reported:

Access denied for user 'root' @ '%' to database 'mytest'

Cause:After the database is created, authorization is required. This issue is not typically found during local access.

3. Authorize database operations

Grant all on xxx. * to 'root' @ '%' identified by 'Password' with grant option;

Xxx indicates the database created, password indicates the user password, and root indicates the password.

Summary

The above is all the content of this article. I hope the content of this article will help you in your study or work. If you have any questions, please leave a message, thank you for your support.