Solve the problem of Access denied for user 'root'@'%' to database 'xxx' after creating a database in MySQL

Preface

I recently encountered a problem at work. After creating the database, an error occurred when connecting to the database. The error code was Access denied for user 'root'@'%' to database 'xxx'. I finally solved this problem by searching for relevant information. So I thought of summarizing it and sharing it with friends in need for reference and study. Let's take a look together.

Solution process

1. Create a database

create database mytest;

2. Connect to the database and report the following error:

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

Reason: After creating the database, authorization is required. This problem generally does not occur when accessing locally.

3. Authorize database operations

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

Among them: xxx represents the created database; password is the user password, which is the root password in this case.

Summarize

The above is the full content of this article. I hope that the content of this article can bring some help to your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support of 123WORDPRESS.COM.