学习总结之linux安装mysql详细步骤

1.下载mysql安装包,这里使用wget命令下载

 wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.34-1.el7.x86_64.rpm-bundle.tar

1.1如果找不到wget命令

yum install -y wget

2.解压mysql安装包

tar -xvf mysql-8.0.34-1.el7.x86_64.rpm-bundle.tar

3.装mysql前,系统自带的mariadb的lib包和mysql的lib包冲突，删掉

#检查
rpm -qa|grep mariadb
#卸载
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

4.一定按顺序安装mysql的安装包

#1
rpm -ivh mysql-community--common-8.0.34-1.el7.x86_64.rpm
#2
rpm -ivh mysql-community-client-plugins-8.0.34-1.el7.x86_64.rpm
#3
rpm -ivh mysql-community-libs-8.0.34-1.el7.x86_64.rpm
#4
rpm -ivh mysql-community-client-8.0.34-1.el7.x86_64.rpm
#5
rpm -ivh mysql-community-icu-data-files-8.0.34-1.el7.x86_64.rpm
#6
rpm -ivh mysql-community-libs-compat-8.0.34-1.el7.x86_64.rpm
#7
rpm -ivh mysql-community-server-8.0.34-1.el7.x86_64.rpm​

5.初始化mysql

mysqld --initialize --console

6.设置mysql的访问权限

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

7.启动mysql

systemctl start mysqld

8.查看mysql的临时密码

cat /var/log/mysqld.log|grep localhost
#2024-04-26T12:37:58.797333Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: a=yIj7,qC7#S

9.登录mysql

mysql -uroot -p
#临时密码:a=yIj7,qC7#S

10.重置mysql的root密码

mysql> alter user 'root'@'localhost' identified by '123456';

其他设置

1.开放3306端口

[root@localhost ~]# firewall-cmd --permanent --add-port=3306/tcp    
success
[root@localhost ~]# firewall-cmd --reload    
success