二进制安装mysql5.6.40

王凯\期中架构软件包\mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz
上传-5.6.40-linux-glibc2.12-x86_64.tar.gz
[root@db02 ~]# tar xf mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz
[root@db02 ~]# mkdir /application
[root@db02 ~]# mv mysql-5.6.40-linux-glibc2.12-x86_64 /application/mysql-5.6.40
[root@db04 ~]# cd /application/mysql-5.6.40
[root@db02 mysql-5.6.40]# cd support-files/
[root@db02 support-files]# cp my-default.cnf /etc/my.cnf #拷贝配置文件
cp: overwrite ‘/etc/my.cnf’? y
[root@db02 support-files]# cp mysql.server /etc/init.d/mysqld #拷贝mysql启动脚本
[root@db02 support-files]# useradd mysql -s /sbin/nologin –M
[root@db02 support-files]# cd /application/mysql-5.6.40/scripts
[root@db02 scripts]# ln -s /application/mysql-5.6.40 /application/mysql
[root@db04 scripts]# ./mysql_install_db --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data
[root@db02 scripts]# sed -i 's#/usr/local#/application#g' /etc/init.d/mysqld /application/mysql/bin/mysqld_safe
[root@db02 scripts]# /etc/init.d/mysqld start
Starting MySQL.Logging to '/application/mysql/data/db02.err'.
SUCCESS!
加入坏境变量，如果不加坏境变量，就使用不了关于mysql的命令
[root@db02 scripts]# vim /etc/profile.d/mysql.sh
export PATH="/application/mysql/bin:$PATH"
[root@db04 scripts]# source /etc/profile
Systemd管理MySQL启动，则需要加入以下配置文件
[root@db02 scripts]# vim /usr/lib/systemd/system/mysqld.service

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=https://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/application/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
[root@db02 scripts]# systemctl start mysqld
[root@db02 scripts]# systemctl enable mysqld
Created symlink from /etc/systemd/system/multi-user.target.wants/mysqld.service to /usr/lib/systemd/system/mysqld.service.
[root@db02 scripts]# /etc/init.d/mysqld stop
[root@db02 scripts]# chown -R mysql.mysql /application/mysql*

数据库起不来，也会产生这种报错，即使执行systemc tl restart mysqld没有任何报错，但是ps –ef查看数据库进程，确没有这个mysql进程，等于数据库没

解决办法
[root@db02 scripts]# vim /etc/my.cnf

[mysqld]
basedir=/application/mysql
datadir=/application/mysql/data
在重启一下
[root@db02 scripts]# systemctl start mysqld
[root@db02 scripts]# ps -ef |grep mysql
mysql 19220 1 0 16:37 ? 00:00:02 /application/mysql/bin/mysqld --defaults-file=/etc/my.cnf
root 19349 18172 0 17:55 pts/1 00:00:00 grep --color=auto mysql
[root@db02 scripts]# mysql

转载于:https://blog.51cto.com/13523963/2344342