mysql5.6.39编译安装

安装数据库依赖
yum -y install make gcc-c++ cmake bison-devel ncurses-devel libaio
yum install libaio libaio-devel -y
yum install perl-Data-Dumper -y
yum install net-tools -y

上传解压安装
cd /tools/
tar -xf /tools/mysql-5.6.40.tar.gz
cd /tools/mysql-5.6.40/

开始编译
cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.6.40 \
-DMYSQL_DATADIR=/application/mysql-5.6.40/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.6.40/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

创建软连接
ln -s /application/mysql-5.6.40/ /application/mysql

拷贝配置文件
mv /etc/my.cnf /tmp
cp /application/mysql/support-files/my-default.cnf /etc/my.cnf

初始化数据：
/application/mysql/scripts/mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data --user=mysql
修改软件路径归属：
chown -R mysql.mysql /application/mysql/
拷贝启动脚本到Sys-v模式目录：
cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld

启动数据库：
/etc/init.d/mysqld start
查看端口号：
netstat -lntup|grep 330
启动报错
[root@centos7 mysql-5.6.40]# /etc/init.d/mysqld start
Starting MySQL.Logging to '/application/mysql-5.6.40/data/centos7.err'.
190716 12:29:47 mysqld_safe Directory '/application/mysql-5.6.40/tmp' for UNIX socket file don't exists.
 ERROR! The server quit without updating PID file (/application/mysql-5.6.40/data/centos7.pid)


 解决方法
 [root@centos7 mysql-5.6.40]# touch /application/mysql-5.6.40/data/centos7.pid
 [root@centos7 mysql]# mkdir -p /application/mysql-5.6.40/tmp
 [root@centos7 mysql]# chown -R mysql.mysql /application/mysql/

配置环境变量
echo 'PATH=/application/mysql/bin/:$PATH' >>/etc/profile
tail -1 /etc/profile
source /etc/profile 
echo $PATH
mysql

安装完成之后设置密码（设定root的密码）
mysqladmin password 123

或者
mysqladmin -uroot -p password oldboy123
Enter password:旧密码

数据库做安全初始化
[root@centos7 data]# /application/mysql/bin/mysql_secure_installation 

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL

YYQ运维技术博客_运维的工作学习之路
https://www.yeyouqing.top
https://yeyouqing.top
yeyouqing.top
www.yeyouqing.top