CentOS下编译安装MySQL5.6的详细记录

1.安装依赖包

shell>#yum -y install gcc gcc-c++ ncurses ncurses-devel cmake

shell>#tar -zxvf mysql-5.6.19.tar.gzshell>#cd mysql-5.6.19

shell>#useradd -M -s /sbin/nologin mysql

shell>#mkdir -p /usr/local/web/mysqlshell>#mkdir -p /usr/local/web/mysql/data

shell>#cmake \-DCMAKE_INSTALL_PREFIX=/usr/local/web/mysql \-DMYSQL_UNIX_ADDR=/usr/local/web/mysql/mysql.sock \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNObase_STORAGE_ENGINE=1 \-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITH_MEMORY_STORAGE_ENGINE=1 \-DWITH_READLINE=1 \-DENABLED_LOCAL_INFILE=1 \-DMYSQL_DATADIR=/usr/local/web/mysql/data \-DMYSQL_USER=mysql \-DMYSQL_TCP_PORT=3306

shell>#make && make install复制配置文件shell>#cp support-files/my-medium.cnf /etc/my.cnf

shell>#chown -R mysql.mysql /usr/local/web/mysqlshell>#chown -R mysql:mysql /usr/local/web/mysql

shell>#/usr/local/web/mysql/scripts/mysql_install_db \--user=mysql \--basedir=/usr/local/web/mysql \--datadir=/usr/local/web/mysql/data &

shell>#cp /usr/local/web/mysql/support-files/mysql.server /etc/init.d/mysqld

shell>#service mysqld start

方式1：shell># vi /etc/rc.d/rc.local在  文件中增加启动相关服务的命令如下：/usr/local/mysql/bin/mysqld_safe --user=mysql &方式2：shell>#chkconfig --level 35 mysqld on

shell>#vi /etc/profile加入一下两句PATH=$PATH:/usr/local/web/mysql/bin:/usr/local/web/mysql/lib/export PATH保存推出，让其立即生效shell>#source /etc/profile

shell>#mysqladmin -u root password 'new-password'

shell>#mysql -uroot -p