下载专用于centos8的编译版文件,具体过程就不说了,在以前的文章中写的有。
下载文件列表:
percona-server-test-8.0.30-22.1.el8.x86_64.rpm
percona-server-shared-compat-8.0.30-22.1.el8.x86_64.rpm
percona-server-shared-8.0.30-22.1.el8.x86_64.rpm
percona-server-server-8.0.30-22.1.el8.x86_64.rpm
percona-server-rocksdb-8.0.30-22.1.el8.x86_64.rpm
percona-server-devel-8.0.30-22.1.el8.x86_64.rpm
percona-server-debuginfo-8.0.30-22.1.el8.x86_64.rpm
percona-server-client-8.0.30-22.1.el8.x86_64.rpm
percona-icu-data-files-8.0.30-22.1.el8.x86_64.rpm
执行命令: yum install *.rpm
会自动安装,安装完后,会自动生成/etc/my.cnf
修改my.cnf中,将data-dir改为/myweb/mysql/data
修改密码验证插件为传统
default_authentication_plugin=mysql_native_password
关闭selinux
nano /etc/selinux/config
改为disabled
reboot
初始化数据库:mysqld --initialize --user=mysql
然后会生成密码到 /myweb/mysql/data/mysqld.log,将密码复制出来备用
systemctl start mysql
即可启动mysql
使用初始密码修改数据库root用户的密码 ,123456为新密码
sudo /myweb/mysql/bin/mysqladmin -hlocalhost -uroot password ‘123456’ -p
sudo mysql -uroot -p 输入设置的密码
create user ‘guest’@‘%’ identified by ‘123456’;
grant all privileges on . to guest@‘%’ with grant option;
flush privileges;
firewall-cmd --zone=public --add-port=3306/tcp --permanent
重新启动防火墙
firewall-cmd --reload
搞定。