mysql root user cannot be authorized and solve the problem of navicat remote authorization prompt 1044

mysql root user cannot be authorized and solve the problem of navicat remote authorization prompt 1044

Look at the solution first

#------------The problem of mysql root user being unable to be empowered is solved--------
1. Log in to mysql -u root -p
2. Use mysql; Select mysql database 3. Perform the following operations (query the user's authorization permissions, change the authorization permissions, and refresh to take effect)
mysql> select user,host,grant_priv from user;
+---------------+-----------+------------+
| user | host | grant_priv |
+---------------+-----------+------------+
| root | localhost | Y |
| mysql.session | localhost | N |
| mysql.sys | localhost | N |
| root | % | N |
| xc_admin | % | N |
+---------------+-----------+------------+
5 rows in set (0.00 sec)
mysql> update user set grant_priv='Y' where user = 'root';'
Query OK, 1 row affected (0.00 sec)
Rows matched: 2 Changed: 1 Warnings: 0
mysql> flush privileges;#Refresh privileges Query OK, 0 rows affected (0.00 sec)
mysql> select user,host,grant_priv from user;
+---------------+-----------+------------+
| user | host | grant_priv |
+---------------+-----------+------------+
| root | localhost | Y |
| mysql.session | localhost | N |
| mysql.sys | localhost | N |
| root | % | Y |
| xc_admin | % | N |
+---------------+-----------+------------+
5 rows in set (0.00 sec)

Analysis: From the first query statement, we can see that the default root grant_priv (grant permission) in non-local permissions is disabled.

It can be understood as: the root user can be empowered on the local machine (the machine where MySQL is installed). Other IP authorizations are not allowed by default. Maybe for safety reasons

If we use the tool to remotely create a user, code 1044 will appear. This problem can be solved by re-updating the permissions.

Summarize

The above is what I introduced to you about the root user of mysql being unable to be authorized and solving the problem of navicat remote authorization prompting 1044. I hope it will be helpful to everyone, and thank you very much for your support of the 123WORDPRESS.COM website!

You may also be interested in:
  • Detailed explanation of the idea of ​​installing mysql8.0.11 and changing the root password and connecting navicat for mysql
  • Solution to 1045 error when navicat connects to mysql
  • Navicat for MySQL garbled code problem solution
  • Solution to Navicat's inability to remotely connect to MySQL
  • Solution to 1044/1045 error when installing Navicat in MySQL
  • Detailed explanation of Navicat's remote automatic backup method for MySQL (picture and text)

<<:  Ubuntu 19.10 enables ssh service (detailed process)

>>:  js Promise concurrent control method

Recommend

Detailed explanation of Javascript event capture and bubbling methods

Table of contents 1. Event Processing Model 1. Ev...

Ubuntu 16.04 image complete installation tutorial under VMware

This article shares with you the installation tut...

JavaScript custom calendar effect

This article shares the specific code of JavaScri...

Docker-compose image release process analysis of springboot project

Introduction The Docker-Compose project is an off...

Vue implements a search box with a magnifying glass

This article shares with you how to use Vue to im...

Detailed explanation of html download function

The new project has basically come to an end. It ...

Introduction to HTML_PowerNode Java Academy

What is HTML? HTML is a language used to describe...

Monitor the size change of a DOM element through iframe

A common problem encountered during the developme...

Play with the connect function with timeout in Linux

In the previous article, we played with timeouts ...

Gearman + MySQL to achieve persistence operation example

This article uses the gearman+mysql method to imp...

MySQL lock control concurrency method

Table of contents Preface 1. Optimistic Locking A...

Detailed graphic and text instructions for installing MySQL 5.7.20 on Mac OS

Installing MySQL 5.7 from TAR.GZ on Mac OS X Comp...

How to install MySQL and MariaDB in Docker

Relationship between MySQL and MariaDB MariaDB da...

Advantages and Problems of XHTML CSS Website Design

XHTML is the standard website design language cur...