mysql在linux系统安装
作者:神秘网友
发布时间:2020-09-09 12:16:31
mysql在linux系统安装
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: