mysql在linux系统安装

1.下载：https://dev.mysql.com/downloads/repo/yum

 

2.安装https://jingyan.baidu.com/article/6525d4b1704f52ac7d2e94c1.html 

拖到linux系统：安装顺序 common>libs>client>server>devel

按着这个上面步骤走：https://www.cnblogs.com/lemon-feng/p/11233227.html

3.安装时如果没以下的报错可以直接忽略这一步：

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

密码设置错误时：https://www.jianshu.com/p/804cd2d2cdbf   用方案二

设置成功：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.02 sec)

use mysql

select *from user;

mysql> update user set
    -> `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'
    -> where user='root' and host='%';

 

flush privileges;

Delete FROM user Where User='root' and Host='%';

select user,host from user；

改用户名为root1,密码为123456

create user 'root1'@'%' identified with mysql_native_password by '123456';

 grant all privileges on *.* to 'root1'@'%' with grant option;

flush privileges;

exit;

mysql -uroot -p

123456

show databases;

 

 

 

 

 

 

4.Navicate：