Ubuntu18.04安装MySQL后解决普通用户不能进入MySQL的问题

￡神魔★判官ぃ 2022-04-25 03:16 260阅读 0赞

## 设置root密码 ##

> mysql5.7安装完成后普通用户不能进mysql，原因：root的plugin被修改成了auth\_socket，用密码登陆的plugin应该是mysql\_native\_password，直接用root权限登录就不用密码,修改root密码和登录验证方式：

$ sudo su
    # mysql
    mysql>
    mysql> select user, plugin from mysql.user;
    +------------------+-----------------------+
    | user             | plugin                |
    +------------------+-----------------------+
    | root             | auth_socket           |
    | mysql.session    | mysql_native_password |
    | mysql.sys        | mysql_native_password |
    | debian-sys-maint | mysql_native_password |
    +------------------+-----------------------+
    4 rows in set (0.00 sec)
    mysql> update mysql.user set authentication_string=PASSWORD('123456'), plugin='mysql_native_password' where user='root';
    mysql> flush privileges;
    mysql> exit
    Bye
    # exit
    $ sudo /etc/init.d/mysql restart
    $ mysql -uroot -p
    
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2
    Server version: 5.7.22-0ubuntu18.04.1 (Ubuntu)
    
    Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> 
    
    
     
      
     
      
       1
       2
       3
       4
       5
       6
       7
       8
       9
       10
       11
       12
       13
       14
       15
       16
       17
       18
       19
       20
       21
       22
       23
       24
       25
       26
       27
       28
       29
       30
       31
       32
       33
       34
       35
       36
       37