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

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.

You may also be interested in:
  • Solve the problem of Django writing Chinese characters to MySQL
  • Solution to the error of inserting Chinese characters into MySQL under centOS7
  • How to avoid garbled characters when accessing Chinese characters in C# and MySQL
  • Example of how to create a local user in mysql and grant database permissions
  • How to create a MySQL database and support Chinese characters

<<:  Implementing Binary Search Tree in JavaScript

>>:  Solution to uninstalling Python and yum in CentOs system

Recommend

Detailed explanation of MySQL master-slave replication process

1. What is master-slave replication? The DDL and ...

Convert XHTML CSS pages to printer pages

In the past, creating a printer-friendly version ...

Summary of 4 solutions for returning values ​​on WeChat Mini Program pages

Table of contents Usage scenarios Solution 1. Use...

Detailed tutorial on deploying SpringBoot + Vue project to Linux server

Preface Let me share with you how I deployed a Sp...

Some methods to optimize query speed when MySQL processes massive data

In the actual projects I participated in, I found...

HTML table tag tutorial (20): row background color attribute BGCOLOR

The BGCOLOR attribute can be used to set the back...

How to use mixins in Vue

Table of contents Preface How to use Summarize Pr...

Detailed tutorial on installing CUDA9.0 on Ubuntu16.04

Preface: This article is based on the experience ...

Detailed explanation of slave_exec_mode parameter in MySQL

Today I accidentally saw the parameter slave_exec...

Solution to VMware virtual machine no network

Table of contents 1. Problem Description 2. Probl...

Docker-compose steps to configure the spring environment

Recently, I need to package the project for membe...

vue_drf implements SMS verification code

Table of contents 1. Demand 1. Demand 2. SDK para...

MySQL table type storage engine selection

Table of contents 1. View the storage engine of t...