一、安装并配置mysql
1、将mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar压缩包复制到/opt目录下
[root@linux-84750 database] cp mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar /opt/
2、创建指定目录
[root@linux-84750 opt] mkdir -p /usr/local/mysql
3、将mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar的压缩包解压到 /usr/local/mysql
[root@linux-84750 opt] tar -xvf mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql/
4、删除系统自带的MySQL-libs
[root@linux-84750 mysql]# yum remove -y mysql-libs
5、安装server时要依赖
[root@linux-84750 mysql]# yum install -y net-tools
6、离线安装
[ ] rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
[ ] rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
[ ] rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
[ ] rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
[ ] rpm -ivh mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm
7、启动Mysql
8、查看mysql初始密码
9、登录mysql命令行
10、设置初始密码
11、修改配置文件
1
[root@linux-84750 ~]# vim /etc/my.cnf
删除 [mysqld] 并添加如下内容：
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character_set_server=utf8
保存退出，并重启一下mysql服务
12、对外开放权限
1
2
mysql> set global validate_password_policy=LOW;
mysql> grant all privileges on . to 'root'@'%' identified by '12345678' ;
