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:
|
<<: Ubuntu 19.10 enables ssh service (detailed process)
>>: js Promise concurrent control method
Table of contents 1. Event Processing Model 1. Ev...
This article shares with you the installation tut...
This article shares the specific code of JavaScri...
Introduction The Docker-Compose project is an off...
This article shares with you how to use Vue to im...
The new project has basically come to an end. It ...
What is HTML? HTML is a language used to describe...
A common problem encountered during the developme...
In the previous article, we played with timeouts ...
This article uses the gearman+mysql method to imp...
Table of contents Preface 1. Optimistic Locking A...
Installing MySQL 5.7 from TAR.GZ on Mac OS X Comp...
one. Overview of IE8 Compatibility View <br /&...
Relationship between MySQL and MariaDB MariaDB da...
XHTML is the standard website design language cur...