mysql安装流程

[root@n5 ~]# rpm -q mariadb-server mariadb    #如果之前安装过mariadb，需要卸载

[root@n5 ~]# ls    #把安装包上传到root目录下
anaconda-ks.cfg  mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz

[root@n5 ~]# useradd -r mysql    #创建一个系统用户mysql

[root@n5 ~]# id mysql
uid=997(mysql) gid=995(mysql) groups=995(mysql)

[root@n5 ~]# tar xf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz -C /usr/local    #展开安装包

[root@n5 ~]# cd /usr/local/
[root@n5 local]# ln -sn mysql-5.7.18-linux-glibc2.5-x86_64/ mysql    #制作链接文件
lrwxrwxrwx  1 root root  35 Apr 12 23:20 mysql -> mysql-5.7.18-linux-glibc2.5-x86_64/

[root@n5 local]# cd mysql
[root@n5 mysql]# chown -R root.mysql ./\*    #修改mysql所有文件属组为mysql
[root@n5 mysql]# ll
total 36
drwxr-xr-x  2 root mysql  4096 Apr 12 23:16 bin
-rw-r--r--  1 root mysql 17987 Mar 18  2017 COPYING
drwxr-xr-x  2 root mysql    55 Apr 12 23:16 docs
drwxr-xr-x  3 root mysql  4096 Apr 12 23:16 include
drwxr-xr-x  5 root mysql   229 Apr 12 23:16 lib
drwxr-xr-x  4 root mysql    30 Apr 12 23:16 man
-rw-r--r--  1 root mysql  2478 Mar 18  2017 README
drwxr-xr-x 28 root mysql  4096 Apr 12 23:16 share
drwxr-xr-x  2 root mysql    90 Apr 12 23:16 support-files

[root@n5 mysql]# mkdir -pv /data/mysql    #创建mysql数据目录
mkdir: created directory ‘/data’
mkdir: created directory ‘/data/mysql’
[root@n5 mysql]# chown -R mysql.mysql /data/mysql/    #mysql进程要进行写操作,修改权限
[root@n5 mysql]# ll /data
total 0
drwxr-xr-x 2 mysql mysql 6 Apr 12 23:28 mysql

[root@n5 mysql]# vim /etc/profile.d/mysql.sh    #编写修改环境变量脚本
export PATH=/usr/local/mysql/bin:$PATH
[root@n5 mysql]# . /etc/profile.d/mysql.sh    #读取环境变量

[root@n5 mysql]# mkdir etc
[root@n5 mysql]# mkdir logs
[root@n5 mysql]# chown -R mysql.mysql logs/    #更改日志目录权限

[root@n5 mysql]# mysqld --initialize-insecure --user=mysql --datadir=/data/mysql --basedir=/usr/local/mysql
2018-04-13T05:28:25.149583Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-04-13T05:28:25.948412Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-04-13T05:28:26.058553Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-04-13T05:28:26.121981Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 7da0526b-3edb-11e8-a71c-000c2977a305.
2018-04-13T05:28:26.124459Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-04-13T05:28:26.127938Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

[root@n5 mysql]# cp /etc/my.cnf etc/
[root@n5 mysql]# vim etc/my.cnf    #修改mysql配置文件
[mysqld]
datadir=/data/mysql
socket=/tmp/mysql.sock
symbolic-links=0
[mysqld_safe]
log-error=/usr/local/mysql/logs/error.log
pid-file=/var/run/mysql/mysql.pid
!includedir /usr/local/mysql/etc/my.cnf.d

[root@n5 mysql]# cp support-files/mysql.server /etc/init.d/mysqld
[root@n5 mysql]# ll /etc/init.d/mysqld    #确保有执行权限
-rwxr-xr-x 1 root root 10576 Apr 13 01:39 /etc/init.d/mysqld
[root@n5 mysql]# chkconfig --add mysqld
[root@n5 mysql]# mkdir etc/my.cnf.d
[root@n5 mysql]# touch logs/error.log    #新建错误日志文件
[root@n5 mysql]# chown -R mysql.mysql logs/error.log    #修改错误日志文件属主属组

[root@n5 mysql]# service mysql start    #开启mysql服务
Redirecting to /bin/systemctl start mysql.service
[root@n5 mysql]# mysql    #运行mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.18 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>