pm -aq | grep mysql | xargs rpm -e --nodeps ( 卸载应用同时卸载掉相关联的缓存 )
rpm -aq | grep mariadb | xargs rpm -e --nodeps
rm -rf find / -name mysql
2.使用传输工具rz或xftp根据个人喜好上传到CenOS8任意目录,(一般放到在home目录下新建的Mysql8目录下)3.解压后会生成四个文件包:
rpm -ivh mysql-community-common-8.0.22-1.el8.x86_64.rpm --force --nodeps
rpm -ivh mysql-community-libs-8.0.22-1.el8.x86_64.rpm --force --nodeps
rpm -ivh mysql-community-client-8.0.22-1.el8.x86_64.rpm --force --nodeps
rpm -ivh mysql-community-server-8.0.22-1.el8.x86_64.rpm --force --nodeps
5.检查是否全部安装成功:rpm -aq|grep mysql
6.初始化密码设计,并生成随机密码,方便初次进行密码设置:mysql --initialize
7.改变属主:chown -R mysql:mysql /var/lib/mysql/
8.启动Mysql:systemctl start mysqld (一般我喜欢使用restart 进行重启mysql)
9.查看第一次生成的Mysql随机密码:
cat /var/log/mysqld.log | grep password (注意不要带空格)
10.数据库Mysql进行设置:mysql_secure_installation
、
# 启动数据库
systemctl start mysqld
# 关闭数据库
systemctl stop mysqld
# 重启数据库
systemctl restart mysqld
# 查看数据库状态
systemctl status mysqld
# 进入mysql
mysql -u root -p'密码'
### 授予远程连接权限
create user 'root'@'%' identified by '123123';
grant all on *.* to `root`@`%` WITH GRANT OPTION;
ALTER USER 'root'@'%' IDENTIFIED with mysql_native_password by '123123';
flush privileges;
#设置mysql开机自启:
配置mysql开机启动vi /etc/rc.local在文件中添加 service mysqld start即可
,