Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "mysql root users can not authorize and solve navicat remote authorization tips 1044 example analysis", the content is easy to understand, well-organized, hope to help you solve your doubts, the following let the editor lead you to study and learn "mysql root users can not authorize and solve navicat remote authorization tips 1044 example analysis" of this article.

Look at the solution first.

#-mysql root users cannot solve the problem of authorization-1. Log in to mysql-u root-p2 use mysql; to select mysql database 3, and perform the following operations (query the user's weighted permissions, change the authorized permissions, refresh takes 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: 0mysql > flush privileges;# Refresh permission 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)

Parsing: from the first query statement, you can see that the default root grant_priv (weighted permissions) in non-local permissions is turned off.

It can be understood that root users can be empowered on the local machine (the machine on which mysql is installed). Other IP authorizations are not allowed by default. Maybe for security reasons.

Then 1044 code will appear when we use the tool to create a user remotely. This problem can be solved by renewing permissions.

The above is the "mysql root users can not authorize and solve the navicat remote authorization prompt 1044 example analysis" all the content of this article, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.