LNMP架构一，MySQL的安装

MySQL的安装

• MySQL的几个常用安装包:rpm、源码、二进制免编译
• cd/usr/local/src/
• wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz

  [root@linux001 ~]# cd /usr/local/src/
  [root@linux001 src]# wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz

• 解压缩

  tar zxvf mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz

• 移动解压缩后的目录并重命名为mysql

  mv mysql-5.6.35-linux-glibc2.5-x86_64 /usr/local/mysql   //移动并改名为mysql

• 进入mysql目录

  cd /usr/local/mysql
  [root@linux001 mysql]# ls
  bin  COPYING  data  docs  include  lib  man  mysql-test  README  scripts  share  sql-bench  support-files

• 新建mysql用户，命名为mysql，新建mysql数据库存放目录/data

  [root@linux001 mysql]# useradd mysql
  [root@linux001 mysql]# mkdir /data/

• 编译并安装
• ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql

  [root@linux001 mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql
  FATAL ERROR: please install the following Perl modules before executing ./scripts/mysql_install_db:
  Data::Dumper
  [root@linux001 mysql]# yum list |grep perl |grep -i dumper   //上一条提示需要安装包，根据提示搜索含per和dumper的rpm包并选择安装
  perl-Data-Dumper.x86_64                 2.145-3.el7                    base     
  perl-Data-Dumper-Concise.noarch         2.020-6.el7                    epel     
  perl-Data-Dumper-Names.noarch           0.03-17.el7                    epel     
  perl-XML-Dumper.noarch                  0.81-17.el7                    base     
  [root@linux001 mysql]# yum install -y perl-Data-Dumper   
  [root@linux001 mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql
  [root@linux001 mysql]# echo $?      //初始化之后，可以通过查看初始化过程中是否有两个OK提示，或者初始化之后立即执行echo $?查看命令执行结果是否正确。
  0

• 配置mysql文件，如下修改datadir，basedir，socket这三项
• cp support-files/my-defalult.cnf /etc/my.cnf
• vi /etc/my.cnf

[root@linux001 ~]# vim /etc/my.cnf

[mysqld]
datadir=/data/mysql
socket=/tmp/mysql.sock
basedir=/usr/local/mysql

将mysql启动文件放入/etc/init.d目录下，并修改配置

cp support-files/mysql.service /etc/init.d/mysqld
vi /etc/init.d/mysqld   

basedir=/user/local/mysql
datadir=/data/mysql

/etc/init.d/mysqld文件权限需为755，默认也是755

• mysqld加入开机启动

[root@linux001 mysql]# chkconfig --add mysqld
[root@linux001 mysql]# chkconfig --list

mysqld          0:关 1:关 2:开 3:开 4:开 5:开 6:关
netconsole      0:关 1:关 2:关 3:关 4:关 5:关 6:关
network         0:关 1:关 2:开 3:关 4:开 5:关 6:关

• /etc/init.d/mysqld.service start //启动mysql服务

  [root@linux001 ~]# service mysqld start
  Starting MySQL.Logging to '/data/mysql/linux001.err'.
  . SUCCESS!

• 查看MySQL进程

  [root@linux001 ~]# ps aux|grep mysql
  root       2472  0.0  0.0  11756  1588 pts/0    S    09:23   0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/data/mysql/linux001.pid
  mysql      2607  1.8 24.0 973044 449512 pts/0   Sl   09:23   0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/linux001.err --pid-file=/data/mysql/linux001.pid --socket=/tmp/mysql.sock
  root       2633  0.0  0.0 112660   976 pts/0    S+   09:24   0:00 grep --color=auto mysql

• 查看MySQL连接端口

  [root@linux001 ~]# netstat -lntp
  Active Internet connections (only servers)
  Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
  tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      813/sshd            
  tcp        0      0 127.0.0.1:25            0.0.0.0:*               LISTEN      1964/master         
  tcp6       0      0 :::3306                 :::*                    LISTEN      2607/mysqld         
  tcp6       0      0 :::22                   :::*                    LISTEN      813/sshd            
  tcp6       0      0 ::1:25                  :::*                    LISTEN      1964/master   

• 查看mysql状态status

[root@load-balancer vhost]# systemctl status mysql
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: active (running) since 四 2017-11-30 09:32:04 HKT; 58min ago
     Docs: man:systemd-sysv-generator(8)
   CGroup: /system.slice/mysqld.service
           ├─1104 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/data/mysql/load-balancer.pid
           └─1492 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log...

11月 30 09:32:01 load-balancer systemd[1]: Starting LSB: start and stop MySQL...
11月 30 09:32:04 load-balancer mysqld[883]: Starting MySQL.. SUCCESS!
11月 30 09:32:04 load-balancer systemd[1]: Started LSB: start and stop MySQL.

转载于:https://blog.51cto.com/fonphxion/2045941