下载mysql-8.0.32一套:
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.32-1.el7.x86_64.rpm-bundle.tar
解压:
tar -xvf mysql-8.0.32-1.el7.x86_64.rpm-bundle.tar
排查残余mysql:
rpm -qa | grep -i mysql 再 rpm -e xxxx
whereis mysql 再 rm /usr/lib64/mysql -rf
find / -name mysql -print
安装RPM按顺序安:
rpm -ivh mysql-community-common-8.0.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.32-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.32-1.el7.x86_64.rpm
剩余的包选择安装
忽略依赖命令:
rpm -ivh --force --nodeps
只下载不安装(已安装好的rpm包再执行它不会有效果)适用于离线安装包含所需的依赖包:
yum install --downloadonly --downloaddir=/tmp xxx.rpm
初始化数据库:
mysqld --initialize --console
cd /var/lib/
chown -R mysql:mysql /var/lib/mysql/
启动:(不用新建mysql用户,不用加my.cnf,他会自己生成,后面想改就改)
systemctl start mysqld.service
systemctl stop mysqld.service
systemctl restart mysqld.service
展示状态:
systemctl status mysqld.service
开机自启;
systemctl enable mysqld.service
去/etc/my.cnf查看log文件拿到密码:
cat /etc/my.cnf
登录mysql -uroot -p
修改密码:
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘MyNewPass4!’;
flush privileges;
允许远程:
进入mysql库:
use mysql
更新域属性,‘%‘表示允许任意IP地址访问:
update user set host=’%’ where user =‘root’;
执行以上语句之后再执行:
FLUSH PRIVILEGES;
再执行授权语句:
GRANT ALL PRIVILEGES ON . TO ‘root’@'%'WITH GRANT OPTION;
注意:
/etc/systemd/system/mysqld.service
文件
如果其中的ExecStart
路径默认不要改,改了服务会起不起来