Linux下安装MySQL

https://dev.mysql.com/downloads/file/?id=485654                                  /对应Linux版本下载MySQL安装包
http://rpmfind.net/linux/rpm2html/search.php?query=？？？                        /下载依赖包
libaio-0.3.109-13.el7.x86_64.rpm
perl-Data-Dumper-2.145-3.el7.x86_64.rpm
numactl-2.0.9-7.el7.x86_64.rpm
numactl-devel-2.0.9-7.el7.x86_64.rpm
numactl-libs-2.0.9-7.el7.x86_64.rpm
***上传包***
[root@wisdom tcsoft]# rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm                  /安装依赖包
[root@wisdom tcsoft]# rpm -ivh numactl-2.0.9-7.el7.x86_64.rpm                    /安装依赖包
[root@wisdom tcsoft]# rpm -ivh numactl-devel-2.0.9-7.el7.x86_64.rpm              /安装依赖包
[root@wisdom tcsoft]# rpm -ivh numactl-libs-2.0.9-7.el7.x86_64.rpm               /安装依赖包
[root@wisdom tcsoft]# rpm -ivh perl-Data-Dumper-2.145-3.el7.x86_64.rpm           /安装依赖包
[root@wisdom tcsoft]# rpm -qa | grep mariadb                                     /查看mariadb版本
[root@wisdom tcsoft]# rpm -e --nodeps mariadb-server-5.5.60-1.el7_5.x86_64       /卸载系统安装的mariadb
[root@wisdom tcsoft]# rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64         /卸载系统安装的mariadb
[root@wisdom tcsoft]# rpm -e --nodeps mariadb-5.5.60-1.el7_5.x86_64              /卸载系统安装的mariadb
[root@wisdom tcsoft]# rpm -e --nodeps mariadb-devel-5.5.60-1.el7_5.x86_64        /卸载系统安装的mariadb
[root@wisdom tcsoft]# rpm -qa | grep mariadb                                     /查看mariadb版本
[root@wisdom tcsoft]# tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar          /解压MySQL安装包
[root@wisdom tcsoft]# yum -y install perl-JSON.noarch                            /安装该依赖包 perl(JSON)
[root@wisdom tcsoft]# rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm    /按照先后安装依赖包
[root@wisdom tcsoft]# rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm      /按照先后安装依赖包
[root@wisdom tcsoft]# rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm    /按照先后安装依赖包
[root@wisdom tcsoft]# rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm    /按照先后安装依赖包
[root@wisdom tcsoft]# mysqld --initialize-insecure --user=mysql                  /设置root账号密码为空
[root@wisdom tcsoft]# systemctl start mysqld                                     /启动MySQL
[root@wisdom tcsoft]# mysql -uroot -p                                            /登录MySQL
mysql> alter user 'root'@'localhost'  identified by 'root';                      /登录密码为空
mysql> show variables like 'char%';                                              /查看字符集
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
mysql> exit;
[root@wisdom tcsoft]# vi /etc/my.cnf                                            /修改字符集为utf8
[client]
default-character-set=utf8

[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci

[root@wisdom tcsoft]# service mysqld restart                                    /重启数据库
[root@wisdom tcsoft]# mysql -uroot -p                                           /登录MySQL，密码为root
mysql> show variables like 'char%';                                             /检查字符集
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
mysql> exit;
[root@wisdom tcsoft]# iptables -I INPUT -p tcp --dport 3306 -j ACCEPT           /开放端口3306