环境准备

版本 IP 配置 主机名
Centos7.2-1511 19.168.100. 2G 2vcpu 40G硬盘 Server

上传MySQL二进制免编译包

  1. # 上传文件包
  2. [root@localhost ~]# ls
  3. anaconda-ks.cfg  mysql-5.6.47-linux-glibc2.12-x86_64.tar.gz
  5. # 修改主机名
  6. [root@localhost ~]# hostnamectl set-hostname server
  7. [root@localhost ~]# su
  9. # 关闭防火墙
  10. [root@serve ~]# systemctl stop firewalld
  11. # 关闭selinux
  12. [root@serve ~]# setenforce 0

安装MySQL

  1. # 准备安装包
  2. [root@server ~]# ll -h mysql-5.6.47-linux-glibc2.12-x86_64.tar.gz 
  3. -rw-r--r-- 1 root root 385M Sep 11 22:34 mysql-5.6.47-linux-glibc2.12-x86_64.tar.gz
  4. # 解压
  5. [root@server ~]# tar -zxf mysql-5.6.47-linux-glibc2.12-x86_64.tar.gz 
  6. # 移动到指定目录
  7. [root@server ~]# mv mysql-5.6.47-linux-glibc2.12-x86_64 /usr/local/mysql
  8. # 创建MySQL启动用户，不可登录
  9. [root@server ~]# useradd -s /sbin/nologin mysql
  10. # 创建存放数据目录
  11. [root@server ~]# mkdir -p /data/mysql
  13. # 更改所属组，所属用户权限
  14. [root@server ~]# chown -R mysql:mysql /data/mysql/
  15. [root@server ~]# ls -la /data/mysql/
  16. total 0
  17. drwxr-xr-x 2 mysql mysql  6 Sep 11 22:37 .
  18. drwxr-xr-x 3 root  root  18 Sep 11 22:37 ..
  19. [root@server ~]# cd /usr/local/mysql/
  21. # 安装依赖
  22. [root@server ~]# yum install -y perl-Module-Install
  23. [root@server mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql/
  24. [root@server mysql]# cp support-files/my-default.cnf /etc/my.cnf
  25. cp: overwrite ‘/etc/my.cnf’? y
  27. # 修改MySQL的my.cnf文件
  28. [root@server mysql]# vim /etc/my.cnf
  29. basedir = /usr/local/mysql
  30. datadir = /data/mysql
  31. port = 3306
  32. server_id = 29
  33. socket = /tmp/mysql.sock
  35. # 配置启动脚本
  36. [root@server mysql]# cp support-files/mysql.server /etc/init.d/mysqld
  37. [root@server mysql]# chmod 777 /etc/init.d/mysqld 
  38. [root@server mysql]# vim /etc/init.d/mysqld
  39. basedir=/usr/local/mysql
  40. datadir=/data/mysql
  41. [root@server mysql]# chkconfig --add mysqld
  42. [root@server mysql]# chkconfig mysql on
  43. [root@server mysql]# service mysqld start 
  44. Starting MySQL. SUCCESS! 
  46. [root@server mysql]# netstat -ntlp
  47. Active Internet connections (only servers)
  48. Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
  49. tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1462/sshd           
  50. tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      2605/master         
  51. tcp6       0      0 :::3306                 :::*                    LISTEN      7891/mysqld         
  52. tcp6       0      0 :::22                   :::*                    LISTEN      1462/sshd           
  53. tcp6       0      0 ::1:25                  :::*                    LISTEN      2605/master         
  55. # 配置环境变量
  56. [root@server mysql]# vim /etc/profile
  57. # 最后一行添加
  58. PATH=$PATH:/usr/lcoal/mysql/bin
  59. [root@server mysql]# source /etc/profile
  60. [root@server mysql]# mysqladmin -uroot password '000000'
  61. Warning: Using a password on the command line interface can be insecure.
  62. [root@server mysql]# mysql -uroot -p000000
  63. Warning: Using a password on the command line interface can be insecure.
  64. Welcome to the MySQL monitor.  Commands end with ; or \g.
  65. Your MySQL connection id is 2
  66. Server version: 5.6.47 MySQL Community Server (GPL)
  68. Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
  70. Oracle is a registered trademark of Oracle Corporation and/or its
  71. affiliates. Other names may be trademarks of their respective
  72. owners.
  74. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  76. mysql> Ctrl-C -- exit!
  77. Aborted
  78. [root@server mysql]#

完成安装