1 下载安装包
MySQL
下载地址:https://dev.mysql.com/downloads/mysql/。
选择版本如下图:
2 解压
tar -xvf mysql-8.0.22-1.el8.x86_64.rpm-bundle.tar -C /home/
3 依次安装rpm包
yum install mysql-community-common-8.0.22-1.el8.x86_64.rpm
yum install mysql-community-client-plugins-8.0.22-1.el8.x86_64.rpm
yum install mysql-community-libs-8.0.22-1.el8.x86_64.rpm
yum install mysql-community-client-8.0.22-1.el8.x86_64.rpm
yum install mysql-community-server-8.0.22-1.el8.x86_64.rpm
4 MySQL启动和配置
# 修改权限
chown -R mysql:mysql /var/lib/mysql
# 开启MySQL
service mysqld start
# 查看启动后状态
service mysqld status
# 查找root密码
grep 'password' /var/log/mysqld.log
# 登陆mysql mysql -uroot -p
# 输入刚才查找到的密码
启动成功后查看状态(service mysqld status
)如下图:
# 登录MySQL后修改root密码
alter user 'root'@'localhost' identified by '自己的密码';
# 启动远程连接
show databases;
use mysql;
update user set host = '%' where user = 'root';
grant all privileges on *.* to 'root'@'%';
然后就可以远程登录root
账号了。