mysql-5.6.24源码包编译安装

ezeke

[BEGIN] 2015/12/18 22:03:34　　
[root@localhost ~]# mkdir -p /usr/local/data/mysql/data
　　
[root@localhost ~]# useradd -s /sbin/nologin mysql
　　
[root@localhost ~]# chown -R mysql:mysql /usr/local/data/mysql/data
　　
[root@localhost ~]# yum install gcc gcc-c++ cmake ncurses-devel bison
　　
[root@localhost ~]# tar -zxvf mysql-5.6.24.tar.gz
　　
[root@localhost ~]# cd mysql-5.6.24
　　
[root@localhost mysql-5.6.24]# mkdir /usr/local/mysql
　　
[root@localhost mysql-5.6.24]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql/data -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_UNIX_ADDR=/tmp/mysql.sock  -DWITH_MYISAM_STORAGE_ENGINE=1  -DENABLE_DOWNLOADS=1
　　
[root@localhost mysql-5.6.24]# make
　　
[root@localhost mysql-5.6.24]# make install
　　
[root@localhost mysql-5.6.24]# chown -R mysql:mysql /usr/local/mysql/
　　
[root@localhost mysql-5.6.24]# cp -a /root/mysql-5.6.24/support-files/my-default.cnf /etc/my.cnf
　　
[root@localhost mysql-5.6.24]# cp -a /root/mysql-5.6.24/support-files/mysql.server /etc/init.d/mysqld
　　
[root@localhost mysql-5.6.24]# chmod a+x /etc/init.d/mysqld
　　
[root@localhost mysql-5.6.24]# chkconfig --level 345 mysqld on
　　
[root@localhost mysql-5.6.24]# echo "export PATH=/usr/local/mysql/bin/:$PATH" >> /etc/profile
　　
[root@localhost mysql-5.6.24]# source /etc/profile
　　
[root@localhost mysql-5.6.24]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/data/mysql/data
　　
[root@localhost mysql-5.6.24]# vi /etc/my.cnf
　　
[root@localhost mysql-5.6.24]# service mysqld start
　　
Starting MySQL... SUCCESS!
　　
[root@localhost mysql-5.6.24]# /usr/local/mysql/bin/mysqladmin -u root password '123456'
　　
[root@localhost mysql-5.6.24]# mysql -u root -p
　　
Enter password:
　　
Welcome to the MySQL monitor.  Commands end with ; or \g.
　　
Your MySQL connection id is 3
　　
Server version: 5.6.24 Source distribution
　　

　　
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
　　

　　
Oracle is 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> exit
　　
Bye