1.解压文件
[root@centos3 ~]# tar -zxvf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
2.重命名
[root@centos3 ~]# cd /usr/local/
[root@centos3 local]# mv mysql-5.7.19-linux-glibc2.12-x86_64/ mysql
3.配置环境变量
[root@centos3 local]# vi + /etc/profile
[root@centos3 local]# source /etc/profile
4.创建组和用户并授权
[root@centos3 local]# groupadd mysql
[root@centos3 local]# useradd -r -g mysql -s /bin/false mysql
[root@centos3 local]# chown -R mysql mysql/
[root@centos3 local]# chgrp -R mysql mysql/
5.修改mysql.server.文件并复制到 /etc/init.d/目录下
[root@centos3 local]# cd /usr/local/mysql/support-files/
[root@centos3 support-files]# vi mysql.server
[root@centos3 support-files]# cp mysql.server /etc/init.d/mysqld
6.设置开机启动
[root@centos3 support-files]# chmod +x /etc/init.d/mysqld
[root@centos3 support-files]# chkconfig --add mysqld
[root@centos3 support-files]# chkconfig mysqld on
//查看开机启动是否成功
[root@centos3 support-files]# chkconfig --list mysqld
7.编辑my.cnf
###修改/etc/my.cnf中datadir的值和/usr/local/mysql/support-files/mysql.server中的datadir的值一样
[root@centos3 support-files]# vi /etc/my.cnf
8.为/etc/my.cnf中socket 、log-error、pid-file 创建目录及文件并修改用户和组
[root@centos3 local]# mkdir /var/run/mariadb
[root@centos3 local]# chown -R mysql /var/run/mariadb
[root@centos3 local]# chgrp -R mysql /var/run/mariadb
[root@centos3 local]# mkdir /var/log/mariadb
[root@centos3 local]# touch /var/log/mariadb/mariadb.log
[root@centos3 local]# chown -R mysql /var/log/mariadb
[root@centos3 local]# chgrp -R mysql /var/log/mariadb
[root@centos3 local]# mkdir /var/lib/mysql
[root@centos3 local]# chown -R mysql /var/lib/mysql
[root@centos3 local]# chgrp -R mysql /var/lib/mysql
9.初始化并记住最后的12位密码
[root@centos3 local]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --lc_messages_dir=/usr/local/mysql/share --lc_messages=zh_CN
10.启动服务
[root@centos3 support-files]# /etc/init.d/mysqld start
[root@centos3 support-files]# service mysql start
11.为/etc/my.cnf中socket文件创建软连接
[root@centos3 support-files]# ln -s /var/lib/mysql/mysql.sock /tmp/
12.登录修改密码，密码就是第9步系统生成的
[root@centos3 support-files]# mysql -uroot -p
mysql> set password=password("1234");
创建数据库创建用户授权
//创建数据库
create database dbusmgr DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
//创建用户语法 CREATE USER <用户名> [ IDENTIFIED ] BY [ PASSWORD ] <口令>
create user test identified by '123456';
//刷新
flush privileges;
//授权语法 grant 权限1,权限2,…权限n on 数据库名称.表名称 to 用户名@用户地址 identified by ‘连接口令’;
grant all privileges on dbusmgr.* to 'test'@'%' identified by '123456';
//刷新
flush privileges;