MySQL安装包
链接:https://pan.baidu.com/s/1gX24GVANqc07uDhNh2vOhg?pwd=1111
提取码:1111
(1)将MySQL安装文件上传到 /opt/software 自己的目录
01_mysql-community-common-5.7.16-1.el7.x86_64.rpm
02_mysql-community-libs-5.7.16-1.el7.x86_64.rpm
03_mysql-community-libs-compat-5.7.16-1.el7.x86_64.rpm
04_mysql-community-client-5.7.16-1.el7.x86_64.rpm
05_mysql-community-server-5.7.16-1.el7.x86_64.rpm
mysql-connector-java-5.1.27-bin.jar
我用的是xshlle
也可以用 cmd 下输入:
scp -r 上传的文件路径 Linux用户名@IP地址:/opt/software
例如 scp -r C:\Users\mysql\01_mysql-community-common-5.7.16-1.el7.x86_64.rpm root@192.168.10.101:/opt/software 自己看自己Linux下的用户名与IP地址
(2)卸载自带的Mysql-libs(如果之前安装过MySQL,要全都卸载掉)
rpm -qa | grep -i -E mysql\|mariadb | xargs -n1 sudo rpm -e --nodeps
(3)安装 MySQL 依赖
sudo rpm -ivh 01_mysql-community-common-5.7.16-1.el7.x86_64.rpm
sudo rpm -ivh 02_mysql-community-libs-5.7.16-1.el7.x86_64.rpm
sudo rpm -ivh 03_mysql-community-libs-compat-5.7.16-1.el7.x86_64.rpm
安装客户端与服务的
sudo rpm -ivh 04_mysql-community-client-5.7.16-1.el7.x86_64.rpm
sudo rpm -ivh 05_mysql-community-server-5.7.16-1.el7.x86_64.rpm
启动MySQL
sudo systemctl start mysqld
查看MySQL的初始化密码
sudo cat /var/log/mysqld.log | grep password
进入MySQL
mysql -uroot -p'password'
需改密码策略
set global validate_password_length=4;
set global validate_password_policy=0;
设置简单好记的密码
set password=password("000000");
进入MySQL库
mysql> use mysql
查询user表
mysql> select user, host from user;
修改user表,把Host表内容修改为% 允许任意主机登录mysql
mysql> update user set host="%" where user="root";
刷新生效
mysql> flush privileges;
完成!