Linux 安装mysql_8

一、下载安装包

https://downloads.mysql.com/archives/community/

二、检查、清除

# 检查是否安装过
rpm -qa | grep -i mysql
# 清除
rpm -e --nodeps 软件名
# 或者卸载
yum remove mysql

三、安装

rpm -ivh rpm包
安装mysql-community-common-8.0.20-1.el8.x86_64.rpm
安装mysql-community-libs-8.0.20-1.el8.x86_64.rpm
安装mysql-community-client-8.0.20-1.el8.x86_64.rpm（前两个是其依赖）
安装mysql-community-sever-8.0.20-1.el8.x86_64.rpm

# 检查是否安装成功
ps -ef | grep mysql

安装sever可能会出错，如：
1.

# 卸载mariadb-connector-c-config
yum remove mariadb-connector-c-config -y 
# 重新安装sever
rpm -ivh mysql-community-sever-8.0.20-1.el8.x86_64.rpm

2.
error: Failed dependencies: perl(Data::Dumper) is needed by MySQL-server-5.6.46-1.el7.x8
解决方法:

yum install -y perl perl-devel autoconf libaio

四、初始化

mysqld --initialize

五、启动mysql

# 启动
systemctl start mysqld
# 查看状态
systemctl status mysqld 
# 停止
systemctl stop mysqld 
# 重启
systemctl restart mysqld 

如果报错：

修改目录权限

chown -R mysql:mysql /var/lib/mysql/

启动mysql

六、查看初始化随机生成的root密码

cat /var/log/mysqld.log | grep password

七、设置

mysql_secure_installation

八、登录

# 登录
mysql -uroot -p 
# 修改密码root用户
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newpassword';
# 相关命令
/usr/bin 
# 配置文件目录
/usr/share/mysql
# 数据库文件存放目录
/var/lib/mysql
# mysql的启动配置文件
/etc/my.cnf
# 开启远程登录
update user set host = '%' where user = 'root';
flush privileges;
mysql的启动配置文件
/etc/my.cnf
# 开启远程登录
update user set host = '%' where user = 'root';
flush privileges;

九、忘记密码

#忘记密码后在mysql8配置文件中[mysqld]下添加参数(跳过密码验证登录)
skip-grant-tables
# 连接MySQL  
mysql -uroot -p
# 修改密码前先把密码置为空字符串；（不让后面修改密码会报错）
use mysql;
update user set authentication_string="" where user="root";
flush privileges;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码';

十、创建用户、赋权

create user 'user001'@'%' identified by '密码';
SHOW GRANTS FOR user001;
GRANT select, update, delete, insert ON *.* TO 'user001'@'%';
flush privileges;