3.7.CentOS7下安装和配置MySQL5.6

python编程快速上手（持续更新中…）

推荐系统基础

---

一、准备工作

安装包同上

二、安装MySQL

1.卸载自带的mariadb（centos7 系统默认会自带mariadb）

# 查出mariadb的rpm包
[root@hadoop1 software]# rpm -qa|grep mariadb
mariadb-libs-5.5.68-1.el7.x86_64

# 忽略依赖关系，删除此包
$ rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

2.下载依赖包

yum install -y net-tools
yum install -y perl

yum install -y autoconf

3.客户端安装client

rpm -ivh MySQL-client-5.6.46-1.el7.x86_64.rpm

4.安装服务端server会报错

rpm -ivh MySQL-server-5.6.46-1.el7.x86_64.rpm

5.vi /usr/my.cnf

[client]
default-character-set = utf8
[mysqld]
lower_case_table_names # 忽略大小写
skip-grant-tables # 跳过用户登录
character_set_server = utf8
collation_server = utf8_general_ci

6.安装完成

[root@hadoop1 software]# service mysql start
Starting MySQL… SUCCESS!

7.无密登录

mysql
use mysql

8.设置密码登录

update user set password=password(‘root’);

重写确认
set password=password(‘root’);

注释：#skip-grant-tables

vi /usr/my.cnf

退出，重启

service mysql restart

重新登录

mysql -uroot -proot

9.Navicat远程连接MySQL

mysql>update user set host = ‘%’ where user =‘root’;
mysql>flush privileges; #刷新用户权限表