1、完全卸载
https://blog.csdn.net/alex_bean/article/details/55656236
2、mysql安装的几种方式
请参考https://blog.csdn.net/qq_39591494/article/details/78255286
(1) 第一种方式(yum安装),在centos7上亲测安装成功
建议参考官方文档 https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/#repo-qg-yum-install-components 里面对安装说的比较详细,默认安装mysql8.0,安装其他版本的方法,里面也提到了 。用里面的方法修改密码注意,密码必须有大小写字母+数字+特殊字符
如果安装比较慢,可以参考 https://www.cnblogs.com/downmoon/p/11896158.html
(2) 在centos6上yum安装mysql参考 https://www.cnblogs.com/gradven/p/5023734.html
(3) centos7二进制安装mysql5.7(第三种方式),可以参考如下网页,https://www.cnblogs.com/Roobbin/p/9959581.html 配置文件如下:1、其中路径根据你安装路径自己调整。2、其中.err的三个文件需要自己提前建好,并赋写权限
[client]
socket=/tmp/mysql.sock
[mysql]
default-character-set=utf8
[mysqld]
port=3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
pid-file=/usr/local/mysql/data/mysqld.pid
character-set-server=utf8
default_storage_engine = InnoDB
innodb_buffer_pool_size=200M
max_allowed_packet=16M
explicit_defaults_for_timestamp=1
log-output=FILE
general_log=0
general_log_file=/usr/local/mysql/log/mysql-general.err
slow_query_log=ON
slow_query_log_file=/usr/local/mysql/log/mysql-query.err
long_query_time=10
log-error=/usr/local/mysql/log/mysql-error.err
user=mysql
# 设置大小写不敏感
lower_case_table_names = 1
3、一些注意说明
(1) 如果安装好后,不能远程连接,可能是防火墙的原因,参照以下修改防火墙
centos6 https://blog.csdn.net/tongdengquan/article/details/82980017
centos7 https://www.cnblogs.com/heqiuyong/p/10460150.html
(2) 出现 Host 'xxx' is not allowed to connect to this MySQL server 是因为没有开启远程访问权限参考 https://www.cnblogs.com/vathena/p/4012399.html
(3) 如果是安装mysql8.0,出现客户端版本低的报错,client does not support authentication protocol requested by server 用如下方法https://blog.csdn.net/HaHa_Sir/article/details/80552663 再修改密码的时候,语句就要改成,如下方法https://blog.csdn.net/q258523454/article/details/84555847