MySQL编译部署_沁贰百科
1、系统环境(本站使用centos6.8_x64)
1 [root@centos ~]# cat /etc/redhat-release2 CentOS release 6.8 (Final)
2、yum安装MySQL依赖包
1 yum install ncurses-devel libaio-devel cmake -y2 rpm -qa ncurses-devel libaio-devel cmake
3、创建MySQL用户
1 useradd -s /sbin/nologin -M mysql2 id mysql
4、下载MySQL源码包到指定目录
1 cd /home/oldboy/tools/
2 wget -q http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.36.tar.gz
3 或本站提供百度云下载,如下: 点击这里
5、下载完成后,解压并进入解压后的目录中
1 tar xf mysql-5.6.36.tar.gz2 cd mysql-5.6.36
6、编译指定参数
1 cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.6.36\2 -DMYSQL_DATADIR=/application/mysql-5.6.36/data \3 -DMYSQL_UNIX_ADDR=/application/mysql-5.6.36/tmp/mysql.sock \4 -DDEFAULT_CHARSET=utf8 \5 -DDEFAULT_COLLATION=utf8_general_ci \6 -DWITH_EXTRA_CHARSETS=all \7 -DWITH_INNOBASE_STORAGE_ENGINE=1\8 -DWITH_FEDERATED_STORAGE_ENGINE=1\9 -DWITH_BLACKHOLE_STORAGE_ENGINE=1\10 -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1\11 -DWITH_ZLIB=bundled \12 -DWITH_SSL=bundled \13 -DENABLED_LOCAL_INFILE=1\14 -DWITH_EMBEDDED_SERVER=1\15 -DENABLE_DOWNLOADS=1\16 -DWITH_DEBUG=0
7、make安装
1 make && make install
8、创建软连接
1 ln -s /application/mysql-5.6.36/ /application/mysql
9、复制配置文件到/etc/my.cnf
1 [root@db01 mysql-5.6.36]# cp support-files/my*.cnf /etc/my.cnf2 cp: overwrite `/etc/my.cnf'? y
10、初始化MySQL
1 /application/mysql/scripts/mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data --user=mysql
11、授权MySQL用户
1 chown -R mysql.mysql /application/mysql/
12、制作启动文件
1 cp support-files/mysql.server /etc/init.d/mysqld
13、给予权限
1 chmod 700 /etc/init.d/mysqld
14、设置开机启动并查看是否成功
1 chkconfig mysqld on2 chkconfig --list mysqld
15、增加MySQL环境变量
1 echo 'PATH=/application/mysql/bin/:$PATH' >>/etc/profile2 tail -1 /etc/profile3 source /etc/profile4 echo $PATH
16、(现在启动一般会报tmp或者以主机名命名的.err,,先来创建一下吧)填了无数坑,还是先记录下吧
1 mkdir /application/mysql/tmp2 chown -R mysql.mysql /application/mysql/
17、开始启动MySQL……
1 /etc/init.d/mysqld start2 netstat -lntup|grep 330
18、增加MySQL登录密码
mysqladmin -u root password 'oldboy123'
19、登录MySQL……
[root@centos ~]# mysql -uroot -poldboy123
Warning: Using a password on the command lineinterfacecan be insecure.
Server version:5.6.36Source distribution
Copyright (c)2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracleis a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type'help;' or '\h' for help. Type '\c'to clear the current input statement.
mysql>
出现以上信息,那么恭喜你已经部署完成。