Linux 安装 MySQL

说明

命令

检查是否安装MySQL

rpm -qa |grep -i mysql

检查是否安装MariaDB

rpm -qa | grep -i mariadb

卸载MariaDB

rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64

删除MySQL配置文件

rm -rf /etc/my.cnf

rm -rf /var/lib/mysql

卸载后/var/lib/mysql中的数据及/etc/my.cnf不会删除，确定没用后就手动删除。

安装perl

yum install perl

安装net-tools

yum install net-tools

解压安装包

tar -xvf mysql-5.7.30-1.el6.x86_64.rpm-bundle.tar

依次安装rpm包

rpm -ivh mysql-community-common-5.7.30-1.el6.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.30-1.el6.x86_64.rpm

rpm -ivh mysql-community-client-5.7.30-1.el6.x86_64.rpm

rpm -ivh mysql-community-server-5.7.30-1.el6.x86_64.rpm --force --nodeps

说明

命令

查看MySQL状态

systemctl status mysqld

启动MySQL服务

systemctl start mysqld

停止MySQL服务

systemctl stop mysqld

查看临时密码

grep password /var/log/mysqld.log

使用密码登录

mysql -u root -p

设置密码为 ABCabc_1234

set password = password("ABCabc_1234");

退出MySQL

exit