mysql5.6编译安装

# 工具

yum -y install gcc

yum -y install gcc-c++

yum -y install make

yum -y install cmake （注：Mysql 5.5后不再使用 ./configure 改用 cmake 编译工具）

//wget http://www.cmake.org/files/v3.1/cmake-3.1.1.tar.gz；tar -zxf cmake-3.1.1.tar.gz；./bootstrap；make；make install

yum -y install autoconf    生成makefile文件

 

# 依赖

yum -y install libtool-ltdl-devel    libtool依赖检查

yum -y install freetype-devel

yum -y install libxml2-devel    XML扩展

yum -y install gd-devel    图片GD库

yum -y install libjpeg-devel

yum -y install libpng-devel

yum -y install openssl openssl-devel

yum -y install curl-devel

yum -y install patch

yum -y install unzip    ZIP解压缩

yum -y install epel-release    提供额外的包 

yum -y install libmcrypt-devel    加密库

yum -y install libmhash-devel    加密库

yum -y install ncurses-devel    mysql 控制终端显示的库文件

yum -y install sudo

yum -y install bzip2    .bz2压缩

yum -y install flex        词法分析器

yum -y install bison bison-devel    语法分析器

yum -y install libaio-devel    异步io

yum -y install glibc

 

# 编译

wget https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.48.tar.gz

tar -zxf mysql-5.6.48.tar.gz

cd mysql-5.6.48/

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \    安装位置

    -DMYSQL_DATADIR=/usr/local/mysql/data \    数据目录

    -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \    套接字

    -DDEFAULT_CHARSET=utf8 \    默认字符集

    -DDEFAULT_COLLATION=utf8_general_ci \    默认校对字符集

    -DWITH_EXTRA_CHARSETS=all \    扩展字符集

    -DWITH_INNOBASE_STORAGE_ENGINE=1 \    innodb 引擎

    -DWITH_FEDERATED_STORAGE_ENGINE=1 \  ??

    -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ ??

    -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \ ??

    -DWITH_ZLIB=system\    bundled：坑死

    -DWITH_SSL=system\    bundled：坑死

    -DENABLED_LOCAL_INFILE=1 \

    -DWITH_EMBEDDED_SERVER=1 \

    -DENABLE_DOWNLOADS=1 \

    -DWITH_DEBUG=0

    

    //默认

    //-DWITH_MYISAM_STORAGE_ENGINE=1 \   myisam 引擎

    //-DWITH_MEMORY_STORAGE_ENGINE=1 \ memory 引擎

    //-DWITH_READLINE=1 \    readline 库

    //-DMYSQL_USER=mysql \    用户

    //-DMYSQL_TCP_PORT=3306 \    端口

 

make

make install

 

# 初始化

/usr/sbin/groupadd mysql

/usr/sbin/useradd -g mysql mysql

 

cp support-files/my-default.cnf /etc/my.cnf

/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --no-defaults--user=mysql

chown -R mysql:mysql /usr/local/mysql/

cp support-files/mysql.server /etc/init.d/mysqld    启动脚本

chmod +x /etc/init.d/mysqld

/etc/init.d/mysqld start     泪奔：Starting MySQL.. SUCCESS!        错误日志：vim /usr/local/mysql/data/centos-linux.shared.err

ln -s /usr/local/mysql/bin/* /usr/bin/

chkconfig --add mysqld；chkconfig --level 35 mysqld on；开机自启；

 

/etc/init.d/mysqld start

service mysqld start

 

# 默认密码

/usr/local/mysql/bin/mysqld_safe --skip-grant-tables &        &:后台运行

mysql -u root -p;

use mysql;

desc user \G;

update user set password=password("123456") where User='root’;

flush privileges;

quit

service mysql restart

 

# 远程

use mysql;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

mysql -u root -p -h 10.211.55.11

 

/usr/local/mysql/bin/mysqladmin-u root -h 10.211.55.11 password 'new-password'

 

 

# 自启

cp support-files/mysql.server /etc/rc.d/init.d/mysqld

chkconfig --add mysqld

chkconfig --level 35 mysqld on

 

# 清理

find / -name mysql -exec rm -rf {} \;

whereis mysql -exec rm -rf {} \;

make clean

rm -f  CMakeCache.txt

 

# 伪用户

cat /etc/group | grep mysql

cat /etc/passwd |grep mysql

 

 

# cmake 和 configure 的区别

configure 生成：config.log + config.status

cmake 生成    ：CMakeFiles/CMakeError.log + CMakeFiles/CMakeOutput.log

 

# 帮助

/usr/local/mysql/bin/mysql --help

./configure —help

mysqld --verbose --help