Linux安装mysql总结

1、删除原有的mariadb

查看  mariadb

rpm -qa|grep mariadb

删除mariadb

rpm -e --nodeps mariadb-libs

查看之前是否安装

[root@localhost ~]# rpm -qa |grep -i mysql
mysql80-community-release-el8-1.noarch
mysql-community-server-8.0.27-1.el8.x86_64
mysql-community-client-plugins-8.0.27-1.el8.x86_64
mysql-community-libs-8.0.27-1.el8.x86_64
mysql-community-client-8.0.27-1.el8.x86_64
bt-mysql57-5.7.34-1.el8.x86_64
mysql-community-common-8.0.27-1.el8.x86_64

卸载之前安装的mysql

yum remove mysql80-community-release-el8-1.noarch
yum remove mysql-community-server-8.0.27-1.el8.x86_64
yum remove mysql-community-client-plugins-8.0.27-1.el8.x86_64
yum remove mysql-community-libs-8.0.27-1.el8.x86_64
yum remove mysql-community-client-8.0.27-1.el8.x86_64
yum remove bt-mysql57-5.7.34-1.el8.x86_64
yum remove mysql-community-common-8.0.27-1.el8.x86_64

查看相关安装目录残留

[root@localhost ~]# find / -name mysql
find: ‘/proc/29250/task/29250/net’: Invalid argument
find: ‘/proc/29250/net’: Invalid argument
/etc/logrotate.d/mysql
/var/lib/selinux/targeted/active/modules/100/mysql
/var/lib/selinux/targeted/tmp/modules/100/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/bin/mysql
/usr/lib64/mysql
/usr/share/selinux/targeted/default/active/modules/100/mysql

删除残留

rm -rf /etc/logrotate.d/mysql
rm -rf /var/lib/selinux/targeted/active/modules/100/mysql
rm -rf /var/lib/selinux/targeted/tmp/modules/100/mysql
rm -rf /var/lib/mysql
rm -rf /var/lib/mysql/mysql
rm -rf /usr/bin/mysql
rm -rf /usr/lib64/mysql
rm -rf /usr/share/selinux/targeted/default/active/modules/100/mysql

删除/etc/my.cnf 文件

 rm -rf /etc/my.cnf

删除 /var/log/mysql/mysqld.log文件

rm -rf /var/log/mysql/mysqld.log

 

 

 

 

 

2、安装依赖（缺什么就安装什么）

yum install openssl-devel.x86_64 openssl.x86_64 -y
yum install perl.x86_64 perl-devel.x86_64 -y
yum install perl-JSON.noarch -y
yum install autoconf -y

 

3、下载mysql

  MySQL https://dev.mysql.com/downloads/mysql/

 

 

 

4、逐个安装mysql（保持顺序）

参考如下顺序：

 

 

逐个安装，命令如下：【必须安装】

rpm -ivh mysql-community-common-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.16-2.el7.x86_64.rpm

rpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm

【非必须安装】
rpm -ivh mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-test-8.0.16-2.el7.x86_64.rpm

 

 

 

5、启动mysql

systemctl start mysqld

特别说明，如果启动不了 就是目录权限 的问题 

 

 

6、查看临时密码

grep "A temporary password" /var/log/mysqld.log

 

7、修改密码

这里特别说明：先用临时密码登录，然后修改为复杂的密码，在修改密码策略，才能修改为简单的密码（由于密码策略的影响不能直接修改为123456，需要先修改为复杂的密码，然后修改密码策略，才能修改为简单的密码。但是修改密码策略之前必需先修改密码不然提示You must reset your password using ALTER USER statement before executing this statement.）

 

登录
mysql -uroot -p

修改密码
ALTER USER USER() IDENTIFIED BY '123456';

修改密码长度：
set global validate_password.length=4;

修改密码规则：
set global validate_password.policy=LOW;

查看密码规则
SHOW VARIABLES LIKE 'validate_password%';

 

问题总结

1、Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

上面这个问题 都是目录权限问题 修改目录用户组即可

chown -R mysql:mysql mysql/

 

chmod -R 755 mysql/