mysql的root权限故障解决方法

最新推荐文章于 2024-06-23 21:25:03 发布

钧娃

最新推荐文章于 2024-06-23 21:25:03 发布

阅读量1.2k

点赞数

分类专栏：笔记文章标签： mysql

本文链接：https://blog.csdn.net/liuestcjun/article/details/79097516

版权

笔记专栏收录该内容

21 篇文章 0 订阅

订阅专栏

查看权限发现所有都是N，所以我们要改为Y

mysql> select * from mysql.user\G
*************************** 1. row ***************************
                  Host:
                  User: root
              Password: *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B
           Select_priv: N
           Insert_priv: N
           Update_priv: N
           Delete_priv: N
           Create_priv: N
             Drop_priv: N
           Reload_priv: N
         Shutdown_priv: N
          Process_priv: N
             File_priv: N
            Grant_priv: N
       References_priv: N
            Index_priv: N
            Alter_priv: N
          Show_db_priv: N
            Super_priv: N
 Create_tmp_table_priv: N
      Lock_tables_priv: N
          Execute_priv: N
       Repl_slave_priv: N
      Repl_client_priv: N
      Create_view_priv: N
        Show_view_priv: N
   Create_routine_priv: N
    Alter_routine_priv: N
      Create_user_priv: N
            Event_priv: N
          Trigger_priv: N
Create_tablespace_priv: N
              ssl_type:
            ssl_cipher:
           x509_issuer:
          x509_subject:
         max_questions: 0
           max_updates: 0
       max_connections: 0
  max_user_connections: 0
                plugin:
 authentication_string: NULL
1 row in set (0.01 sec)

可以删除后新建一个：

mysql> delete from mysql.user where user='root';
Query OK, 1 row affected (0.00 sec)

mysql> use mysql
Database changed
mysql> insert into user (Select_priv,           Insert_priv,           Update_priv,           Delete_priv,           Create_priv,             Drop_priv,           Reload_priv,         Shutdown_priv,          Process_priv,             File_priv,            Grant_priv,       References_priv,            Index_priv,            Alter_priv,          Show_db_priv,            Super_priv, Create_tmp_table_priv,      Lock_tables_priv,          Execute_priv,       Repl_slave_priv,      Repl_client_priv,      Create_view_priv,        Show_view_priv,   Create_routine_priv,    Alter_routine_priv,      Create_user_priv,            Event_priv,          Trigger_priv,Create_tablespace_priv,User,Password) values ( 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','root','root');
Query OK, 1 row affected, 3 warnings (0.01 sec)

mysql>
mysql> UPDATE user SET Password=PASSWORD('root') where USER='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from mysql.user\G
*************************** 1. row ***************************
                  Host:
                  User: root
              Password: *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B
           Select_priv: Y
           Insert_priv: Y
           Update_priv: Y
           Delete_priv: Y
           Create_priv: Y
             Drop_priv: Y
           Reload_priv: Y
         Shutdown_priv: Y
          Process_priv: Y
             File_priv: Y
            Grant_priv: Y
       References_priv: Y
            Index_priv: Y
            Alter_priv: Y
          Show_db_priv: Y
            Super_priv: Y
 Create_tmp_table_priv: Y
      Lock_tables_priv: Y
          Execute_priv: Y
       Repl_slave_priv: Y
      Repl_client_priv: Y
      Create_view_priv: Y
        Show_view_priv: Y
   Create_routine_priv: Y
    Alter_routine_priv: Y
      Create_user_priv: Y
            Event_priv: Y
          Trigger_priv: Y
Create_tablespace_priv: Y
              ssl_type:
            ssl_cipher:
           x509_issuer:
          x509_subject:
         max_questions: 0
           max_updates: 0
       max_connections: 0
  max_user_connections: 0
                plugin:
 authentication_string: NULL
1 row in set (0.00 sec)