Centos编译安装mysql5.6.21_MySQL

1.yum安装各个依赖包

[root@WebServer ~]# yum -y install gcc gcc-devel gcc-c++ gcc-c++-devel autoconf* automake* zlib* libxml* ncurses-devel ncurses libgcrypt* libtool* cmake openssl openssl-devel bison bison-devel unzip

2.创建mysql安装目录和数据库目录

mkdir -p /opt/mysql/datamkdir -p /opt/mysql/etcmkdir -p /opt/mysql/log

3.更改mysql目录的权限为自己当前用户（我的用户名是mysql）

chown mysql.mysql /opt/mysql

chown mysql.mysql /opt/mysql/data –

4.解压mysql-5.6.21.tar.gz源码包

tar zxvf ~/下载/mysql-5.6.21.tar.gz -C /usr/local/src/chown mysql.mysql /usr/share/src/mysql-5.6.21hown mysql.mysql /usr/share/src/mysql-5.6.21/ -R

5.下载gmock-1.6.0.zip，解压至源码中的source_downloads目录下

http://bbs.ithome.com/forum.php?mod=attachment&aid=NTk1MjYwfGNkYzNjZDM0fDE0MTM4NTU1MzR8MjA5NDI5Nnw2Mzg1NTA%3Dunzip ~/下载/gmock-1.6.0.zipmv gmock-1.6.0 /usr/local/src/mysql-5.6.21/source_downloads/cd /usr/local/src/mysql-5.6.21/source_downloads/gmock-1.6.0./configuremakecd ../../

6.编译安装

cmake \-DCMAKE_INSTALL_PREFIX=/opt/mysql \-DMYSQL_DATADIR=/opt/mysql/database \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_MEMORY_STORAGE_ENGINE=1 \-DWITH_ARCHIVE_STORAGE_ENGINE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1<strong>本文来源gao@daima#com搞(%代@#码网</strong> \-DWITH_READLINE=1 \-DENABLE_DOWNLOADS=1 \-DENABLED_LOCAL_INFILE=1 \-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DEXTRA_CHARSETS=all \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_cimakemake install

7.创建配置文件

cp /opt/mysql/support-files/my-default.cnf /opt/mysql/etc/my.cnf[root@master support-files]# cat /opt/mysql/etc/my.cnf[mysqld]datadir = /opt/mysqldatadir = /opt/mysql/data#socket = /tmp/mysql.socksocket = /opt/mysql/data/mysql.sock#log = /opt/mysql/log/mysql.logpid-file = /opt/mysql/data/mysql.piduser = mysqlport = 3306#tmpdir = /tmplog-error = /opt/mysql/log/mysql.err[client]socket = /opt/mysql/data/mysql.sock

8.初始化数据库

/opt/mysql/scripts/mysql_install_db –user=mysql –basedir=/opt/mysql –datadir=/opt/mysql/data

9.创建管理MySQL数据库的shell脚本

root@master support-files]# cp mysql.server /etc/init.d/mysql[root@master support-files]# chmod +x /etc/init.d/mysql[root@master support-files]# service mysql startStarting MySQL.. [确定][root@master support-files]#

10.设置MySQL root用户的密码

/opt/msql/bin/mysqladmin -u root password 123123 #修改mysql数据库的root账户密码是123123

11.登录mysql

[root@master support-files]# mysql -uroot -p123123Warning: Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.6.21 Source distributionCopyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

喜欢 (0)赏

[搞代码]

分享 (0)