MySQL安装

1、检查是否已经安装了mysql 和 mariadb

rpm -qa | grep mysql
rpm -qa | grep mariadb

# 如果已经安装,就先卸载:
rpm -e --nodeps  软件名

2、安装mysql

# 按顺序安装:8.0.28-1.el7版本

rpm -ivh mysql-community-common-8.0.28-1.el7.aarch64.rpm 

rpm -ivh mysql-community-client-plugins-8.0.28-1.el7.aarch64.rpm 

rpm -ivh mysql-community-libs-8.0.28-1.el7.aarch64.rpm

rpm -ivh mysql-community-client-8.0.28-1.el7.aarch64.rpm

rpm -ivh mysql-community-icu-data-files-8.0.28-1.el7.aarch64.rpm

rpm -ivh mysql-community-server-8.0.28-1.el7.aarch64.rpm 

注:8.0.28-1.el7版本后解压内容多了几个文件,安装顺序可能会有所改变

3、查看mysql状态

systemctl status mysqld

4、启动mysql服务

systemctl start mysqld

5、设置开机启动服务

systemctl enable mysqld

6、查看服务是否成功启动

netstat -tunlp | grep mysql

7、查看初始密码

cat /var/log/mysqld.log
# 或
cat /var/log/mysqld.log | grep password
# 找到密码,注意,不要冒号后的空格

8、登录mysql

mysql -uroot -p

9、远程访问授权

create user '用户名'@'%' identified with mysql_native_password by '密码';
grant all privileges on *.* to '用户名'@'%' with grant option;
flush privileges;

10、防火墙开启 3306 端口

11、安装完毕!

PS:安装过程中可能提示要安装 net-tools 依赖:
yum install net-tools

PS:安装过程中可能提示依赖libaio….什么的,那么安装libaio再继续安装mysql剩下部分就可以:
yum install libaio

更新yum源:
yum update

posted @ 2023-05-26 09:42  The Answer  阅读(13)  评论(0编辑  收藏  举报