mysql8安装

ubuntu 20.04下操作

1. mysql8的安装

    sudo apt-get install mysql-server
   

   安装成功后，登录mysql，默认无密码，sudo 命令登录

   sudo  mysql -u root 
   

   登陆后设置密码

    mysql> use mysql;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    
    Database changed
    mysql> select user,authentication_string,host from user;
    +------------------+------------------------------------------------------------------------+-----------+
    | user             | authentication_string                                                  | host      |
    +------------------+------------------------------------------------------------------------+-----------+
    | debian-sys-maint | $A$005$t9CpqWyJE@J=:c+KxpO.GsIq6lF1yoN.MA9I5uHZzwqGEZpL0Cl1Wmvky/ | localhost |
    | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | localhost |
    | mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | localhost |
    | mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | localhost |
    | root             |                                                                        | localhost |
    +------------------+------------------------------------------------------------------------+-----------+
    5 rows in set (0.00 sec)
    
    	mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'admin123';
    Query OK, 0 rows affected (0.01 sec)
    
    mysql> use mysql;
    Database changed
    mysql> select user,authentication_string,host from user;
    +------------------+------------------------------------------------------------------------+-----------+
    | user             | authentication_string                                                  | host      |
    +------------------+------------------------------------------------------------------------+-----------+
    | debian-sys-maint | $A$005$t9CpqWyJE@J=:c+KxpO.GsIq6lF1yoN.MA9I5uHZzwqGEZpL0Cl1Wmvky/ | localhost |
    | mysql.infoschema | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | localhost |
    | mysql.session    | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | localhost |
    | mysql.sys        | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | localhost |
    | root             | *01A6717B58FF5C7EAFFF6CB7C96F7428EA65FE4C                              | localhost |
    +------------------+------------------------------------------------------------------------+-----------+
    5 rows in set (0.00 sec)
    
    mysql> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.02 sec)
    
    mysql> exit
   

   常见命令：

   service mysql start # 启动mysql
   service mysql stop # 关闭mysql