linux下卸载和安装mysql

卸载mysql

查看是否安装mysql

rpm -qa | grep -i mysql

删除查询出来的包些包

 rpm -e  mysql-community-libs-8.0.17-1.el7.x86_64 --nodeps
 rpm -e  mysql-community-server-8.0.17-1.el7.x86_64 --nodeps
 rpm -e  mysql-community-devel-8.0.17-1.el7.x86_64 --nodeps
 rpm -e  mysql-community-embedded-compat-8.0.17-1.el7.x86_64 --nodeps
 rpm -e  mysql-community-common-8.0.17-1.el7.x86_64 --nodeps
 rpm -e mysql-community-client-8.0.17-1.el7.x86_64 --nodeps
 rpm -e  mysql-community-test-8.0.17-1.el7.x86_64 --nodeps
 rpm -e mysql-community-libs-compat-8.0.17-1.el7.x86_64 --nodeps

上面的命令删除不掉的话，建议换下面的命令

#yum remove 文件名
yum remove mysql-community-libs-8.0.17-1.el7.x86_64

确定删除完再执行下面的操作

删除残留的mysql目录或文件

whereis mysql

rm -rf /var/lib/mysql
rm -rf /var/lib/mysql/mysql
rm -rf /data/mysql

查看mysql文件，删除

find / -name mysql

rm -rf /usr/lib64/mysql
rm -rf /usr/share/mysql
rm -rf /usr/bin/mysql
rm -rf /etc/logrotate.d/mysql
rm -rf /var/lib/mysql
rm -rf /var/lib/mysql/mysql

还有/etc/my.cnf文件也要删除
确定几个查询方式，找不出任何mysql文件就可以安装mysql了

安装mysql

这里装的是 5.1.27版本 的mysql

解压mysql的安装包

unzip mysql-libs.zip

centos7的不能使用unzip命令的话可以参考下面的博客
https://blog.csdn.net/weixin_45271668/article/details/107226716

到mysql-libs文件夹下

# ll
MySQL-client-5.6.24-1.el6.x86_64.rpm
mysql-connector-java-5.1.27.tar.gz
MySQL-server-5.6.24-1.el6.x86_64.rpm

安装mysql服务端

rpm -ivh MySQL-server-5.6.24-1.el6.x86_64.rpm

安装服务端时报错
参考下面的解决方案即可
1. file /usr/share/mysql/charsets/README from install of MySQL-server-5.6.24-1.el6.x86_64 conflicts with file from package mariadb-libs-1:5.5.65-1.el7.x86_64
https://blog.csdn.net/weixin_45271668/article/details/112913306
2. FATAL ERROR: please install the following Perl modules before executing /usr/bin/mysql_install_db: Data::Dumper
https://blog.csdn.net/weixin_45271668/article/details/107883938

查看产生的随机密码

cat /root/.mysql_secret
#产生的随机密码
dtWtBgZyScCCuGXQ

查看mysql状态

service mysql status

启动mysql

service mysql start

安装mysql客户端

rpm -ivh MySQL-client-5.6.24-1.el6.x86_64.rpm

连接mysql

# dtWtBgZyScCCuGXQ：上面查询到的密码
mysql -uroot -pdtWtBgZyScCCuGXQ

修改密码

mysql>SET PASSWORD=PASSWORD('123456');

退出mysql

mysql>exit

再使用新密码登录mysql,

show databases; 

能查询数据库代表mysql安装成功了

安装完成之后
navicat远程连接mysql
连接mysql服务器
看当前所有数据库：

show databases;

进入mysql数据库：

use mysql;

查看mysql数据库中所有的表：

show tables;

查看user表中的数据:

select host,user,password from user;

修改user表中的host:

update user set host='%' where host='localhost';

删除host里面的node1:

delete from user where Host='node1';

删除host里面的127.0.0.1:

delete from user where Host='127.0.0.1';

删除host里面的::1 :

delete from user where Host='::1';

刷新授权列表：

flush privileges;

退出mysql

exit

------安--装--成--功---------