下载mysql8
- 下载地址
- 上传到服务器
- 安装
rpm –ivh xxx.rpm
- 安装服务
yum -y install mysql-community-server
- 启动myslq
systemctl start mysqld
启动:systemctl start mysqld
停止:systemctl stop mysqld
重启:systemctl restart mysqld
- 查看密码
grep "password" /var/log/mysqld.log
- 登录
mysql –uroot –p
- 修改密码
ALTER USER `root`@`localhost` IDENTIFIED BY '你的密码';
- 修改远程连接
RENAME USER `root`@`localhost` TO `root`@`%`;
- 开机自启
systemctl enable mysqld
systemctl daemon-reload