CC00013.MySQL——|Mysql.V5.7.26部署|——|标准版本|...

一、centos7.x环境部署mysql.v5.7.36

### --- 下载mysql.rpm版本包并安装rpm包

~~~     # 下载mysql版本包
[root@localhost ~]#  wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm
~~~     # 安装mysql.rpm源
[root@localhost ~]# rpm -Uvh mysql57-community-release-el7-10.noarch.rpm

### --- 安装mysql版本包并启动

~~~     # 查询是否安装了mariadb
[root@localhost ~]# rpm -aq | grep mariadb
mariadb-libs-5.5.60-1.el7_5.x86_64
~~~     # 删除mariadb -e 删除指定的套件；--nodeps 不验证套件的相互关联性
[root@localhost ~]# rpm -e --nodeps mariadb-libs

~~~     # 安装mysql版本包

[root@localhost ~]# yum install -y mysql-community-server
[root@localhost ~]# systemctl start mysqld.service
[root@localhost ~]# systemctl status mysqld.service

### --- 设置mysql开机自启动

~~~     # 设置mysql开机自启动
[root@localhost ~]# systemctl enable mysqld
[root@localhost ~]# systemctl daemon-reload

### --- 查看mysql临时密码

~~~     # 查看mysql临时密码
[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log 
[Note] A temporary password is generated for root@localhost: P)C5h7(6H1eB

二、mysql配置：通过临时密码登录mysql，mysql初始配置

### --- 进入mysql数据库
~~~     使用临时密码登录后，不能进行其他的操作，否则会报错，这时候我们进行修改密码操作
~~~     因为MySQL的密码规则需要很复杂，我们一般自己设置的不会设置成这样，所以我们全局修改一下

[root@localhost ~]# mysql -uroot -p
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=6;

### --- mysql更改密码并授权远程登录

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

三、my.cnf文件配置：设置mysql字符集及中文支持

### ---设置mysql字符集及中文支持

[root@localhost ~]# vim /etc/my.cnf

[mysql]
default-character-set=utf8

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
default-storage-engine=INNODB
character_set_server=utf8

symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

### --- 重启mysql

[root@localhost ~]# systemctl restart mysqld

四、防火墙配置

### --- 开启3306端口

[root@localhost ~]#  firewall-cmd --state
[root@localhost ~]#  firewall-cmd --zone=public --add-port=3306/tcp --permanent
[root@localhost ~]#  firewall-cmd --reload

五、卸载mysql数据库

### --- 查看mysql版本包

[root@localhost ~]#  rpm -qa | grep mysql
[root@localhost ~]#  yum -y remove mysql57-community-release-el7-10.noarch

附录一：创建用户并开启远程权限

### --- 创建用户设置口令、授权、刷新

mysql> CREATE USER 'hive'@'%' IDENTIFIED BY '123456';
mysql> GRANT ALL ON *.* TO 'hive'@'%';
mysql> FLUSH PRIVILEGES;

附录二：设置mysql远程登录

### --- 方法一：开启mysql远程权限：智慧物流

~~~     # 设置mysql.root远程权限
mysql> use mysql;
mysql> desc user;
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";　　　
mysql> update user set authentication_string = password('123456') where User='root';
mysql> select Host,User,authentication_string  from user where User='root';
mysql> flush privileges;
mysql> exit

### --- 方法二：开启mysql远程权限

~~~     # mysql开通root远程权限：
mysql>  use mysql;
mysql>  select user,host from user;
mysql>  update user set host=’%’ where user=‘root';
mysql>  flush privileges;

### --- 方法三：开启mysql远程权限：

~~~     # mysql开通root远程权限：
mysql>  select  User,authentication_string,Host from user;
mysql>  SHOW VARIABLES LIKE 'validate_password%';
mysql>  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456'
mysql>  GRANT ALL ON *.* TO 'root'@'%' BY '123456';
 
mysql>  DROP USER 'scm'@'%';