RPM方式安装mysql

系统环境

Centos-7

mysql版本

mysql-5.7.17

1、下载并解压rpm包

[root@VM_42_245_centos ~]# tar xf mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar 
[root@VM_42_245_centos ~]# ls
mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar
mysql-community-client-5.7.17-1.el7.x86_64.rpm
mysql-community-common-5.7.17-1.el7.x86_64.rpm
mysql-community-devel-5.7.17-1.el7.x86_64.rpm
mysql-community-embedded-5.7.17-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.17-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.17-1.el7.x86_64.rpm
mysql-community-libs-5.7.17-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.17-1.el7.x86_64.rpm
mysql-community-minimal-debuginfo-5.7.17-1.el7.x86_64.rpm
mysql-community-server-5.7.17-1.el7.x86_64.rpm
mysql-community-server-minimal-5.7.17-1.el7.x86_64.rpm
mysql-community-test-5.7.17-1.el7.x86_64.rpm

2、清除原有的安装包和yum源

[root@VM_42_245_centos ~]# rpm -qa |grep mariadb
mariadb-libs-5.5.50-1.el7_2.x86_64
[root@VM_42_245_centos ~]# rpm -e --nodeps mariadb-libs-5.5.50-1.el7_2.x86_64

3、添加用户

[root@VM_42_245_centos ~]# useradd -s /sbin/nologin mysql

4、安装mysql

[root@VM_42_245_centos ~]# rpm -ivh mysql-community-common-5.7.17-1.el7.x86_64.rpm 
[root@VM_42_245_centos ~]# rpm -ivh mysql-community-libs-5.7.17-1.el7.x86_64.rpm 
[root@VM_42_245_centos ~]# rpm -ivh mysql-community-devel-5.7.17-1.el7.x86_64.rpm  
[root@VM_42_245_centos ~]# rpm -ivh mysql-community-client-5.7.17-1.el7.x86_64.rpm 
[root@VM_42_245_centos ~]# rpm -ivh mysql-community-libs-compat-5.7.17-1.el7.x86_64.rpm 
[root@VM_42_245_centos ~]# yum -y install numactl-libs
[root@VM_42_245_centos ~]# rpm -ivh mysql-community-server-5.7.17-1.el7.x86_64.rpm 

5.7中已经自动生成了/etc/my.cnf文件

5、初始化mysql

[root@VM_42_245_centos lib]# cd /usr/bin/
[root@VM_42_245_centos bin]# mysqld --initialize --user=mysql
[root@VM_42_245_centos bin]# systemctl start mysqld

查看mysql的root密码

[root@VM_42_245_centos bin]# cat /var/log/mysqld.log |grep pass

安全初始化

[root@VM_42_245_centos bin]# mysql_secure_installation 

输入root密码后输入新密码，新密码要求长度应该大于8位，然后全部输入‘y’

6、登录mysql数据库

[root@VM_42_245_centos bin]# mysql -uroot -p

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.17    |
+-----------+

1 row in set (0.00 sec)

7、添加远程登录用户

默认只允许root帐户在本地登录，如果要在其它机器上连接mysql，必须修改root允许远程连接，或者添加一个允许远程连接的帐户，为了安全起见，我添加一个新的帐户：

mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

8、配置默认编码为UTF-8

修改/etc/my.cnf配置文件，在[mysqld]下添加编码配置，如下所示：

[mysqld]

character_set_server=utf8

init_connect='SET NAMES utf8'

重新启动mysql服务，查看数据库默认编码如下所示：

mysql安装完成！