centos 安装mariadb
yum -y install mariadb*
systemctl start mariadb.service
systemctl enable mariadb.service
修改mysql登录密码
UPDATE user SET password=password("新密码") WHERE user='root';
赋予远程登录权限
grant all privileges on *.* to root@'%' identified by 'Changeme_123';
flush privileges; --刷新权限
查看是否已安装过mysql
rpm -qa |grep -i mysql
rpm -qal |grep mysql 查看所有
移除安装的包 (在之前如果有启动mysql最好关掉服务)
rpm –ev 包名
删除文件目录 find /-name mysql
rm -rf /var/lib/mysql/
rm -rf /etc/my.cnf.d
rm /usr/my.cnf
rm -rf /usr/bin/mysql*
确认是否已删除
rpm -qa | grep -i mysql
在终端命令行输入
mysqld_safe --skip-grant-tables & 【登录mysql系统】