Mysql 5.6.36 单实例安装-编译的方式-CSDN博客

Mysql 5.6.36 单实例安装

#一、安装依赖包
yum install ncurses-devel libaio-devel -y
rpm -qa ncurses-devel libaio-devel

yum install cmake -y
rpm -qa cmake

#二、建立mysql用户安装使用
useradd -s /sbin/nologin -M mysql
id mysql

#解压编译安装
cd /home/oldboy/tools/
tar xf mysql-5.6.36.tar.gz
cd mysql-5.6.36
#cmake编译安装
#官方5.6的cmake编译参数
#http://dev.mysql.com/doc/refman/5.6/en/source-configuration-options.html

cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.6.36 \
-DMYSQL_DATADIR=/application/mysql-5.6.36/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.6.36/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS=all \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITH_ZLIB=bundled \
-DWITH_SSL=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLE_DOWNLOADS=1 \
-DWITH_DEBUG=0

make && make install&&cd ..
ln -s /application/mysql-5.6.36/ /application/mysql
cd /application/mysql/
cp support-files/my*.cnf /etc/my.cnf
#cp: overwrite `/etc/my.cnf'? y
/application/mysql/scripts/mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data --user=mysql
chown -R mysql.mysql /application/mysql/
cp support-files/mysql.server /etc/init.d/mysqld
chmod 700 /etc/init.d/mysqld
chkconfig mysqld on
chkconfig --list mysqld
/etc/init.d/mysqld start
netstat -lntup|grep 330
################
mysql错误：
[root@db02 mysql-5.6.36]# /etc/init.d/mysqld start
Starting MySQL.Logging to '/application/mysql-5.6.36/data/db02.err'.
170507 11:36:28 mysqld_safe Directory '/application/mysql-5.6.36/tmp' for UNIX socket file don't exists.
ERROR! The server quit without updating PID file (/application/mysql-5.6.36/data/db02.pid).
排错：
[root@db02 mysql-5.6.36]# mkdir /application/mysql/tmp -p
[root@db02 mysql-5.6.36]# chown -R mysql.mysql /application/mysql/
[root@db02 mysql-5.6.36]# /etc/init.d/mysqld start
Starting MySQL.Logging to '/application/mysql-5.6.36/data/db02.err'.
.. SUCCESS!
#################
问题：
[root@db02 mysql]# /etc/init.d/mysqld start
Starting MySQL... ERROR! The server quit without updating PID file (/application/mysql-5.6.36/data/db02.pid).

可能原因：
1、授权问题
2、磁盘空间
3、看日志排查。
######
echo 'PATH=/application/mysql/bin/:$PATH' >>/etc/profile
tail -1 /etc/profile
source /etc/profile
echo $PATH
mysql
########

##排错：
tail -100 /application/mysql/data/db02.err
##设置mysql密码##
mysqladmin -u root password 'oldboy123'

######安全优化###
select user,host from mysql.user;
drop user ''@'db02';
drop user ''@'localhost';
drop user 'root'@'db02';
drop user 'root'@'::1';
select user,host from mysql.user;
drop database test;
show databases;