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:
|
<<: Implementing Binary Search Tree in JavaScript
>>: Solution to uninstalling Python and yum in CentOs system
1. What is master-slave replication? The DDL and ...
In the past, creating a printer-friendly version ...
Table of contents Usage scenarios Solution 1. Use...
Preface Let me share with you how I deployed a Sp...
Effect picture: Implementation code: <template...
In the actual projects I participated in, I found...
The BGCOLOR attribute can be used to set the back...
Table of contents Preface How to use Summarize Pr...
Preface: This article is based on the experience ...
Today I accidentally saw the parameter slave_exec...
Table of contents chmod Example Special attention...
Table of contents 1. Problem Description 2. Probl...
Recently, I need to package the project for membe...
Table of contents 1. Demand 1. Demand 2. SDK para...
Table of contents 1. View the storage engine of t...