Centos6.5源码安装MySQL

CentOS 6.5环境源码安装MySQL 5.6
1.环境准备工作

编写Shell脚本安装环境(development.sh)#!/bin/bashyum install wget -yyum install cmake -yyum install gcc-c* -yyum install ncurses* -yyum install bison* -ywget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.37.tar.gz**执行脚本：**#chmod +x development.sh#./development.sh

2.添加用户组和用户权限

#groupadd    mysql#useradd   mysql   -g  mysql   -M  -s  /sbin/nologin   -M:创建家目录**创建数据库目录和权限：**mkdir -p  /usr/local/mysqlchown -R  root:mysql  /usr/local/mysqlmkdri -p  /database/mydatachown -R  mysql:mysql  /database/mydata

3.MySQL编译安装

#!/bin/bashcmake . \         -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \         -DMYSQL_DATADIR=/database/data \         -DSYSCONFDIR=/etc \         -DTMPDIR=/tmp \         -DWITH_INNOBASE_STORAGE_ENGINE=1 \         -DWITH_ARCHIVE_STORAGE_ENGINE=1 \         -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \         -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \         -DDEFAULT_CHARSET=utf8 \         -DENABLED_LOCAL_INFILE=1 \         -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \         -DWITH_EXTRA_CHARSETS=all \

#make && make install将/usr/local/mysql/support-files/的文件my-default.cnf复制到/etc/下面的my.cnf删除mysql安装目录下里面的CMakeCache.txt文件

4.修改配置文件

# vim /etc/my.cnf       [client]port = 3306socket = /tmp/mysql.sock[mysqld]user = mysqlinnodb_buffer_pool_size = 128Mlog_bin = master-logbasedir = /usr/local/mysqldatadir = /database/mydataport = 3306server_id = 1socket = /tmp/mysql.sockjoin_buffer_size = 128Msort_buffer_size = 2Mread_rnd_buffer_size = 2Mcharacter_set_server = utf8sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

5.开启服务准备，添加环境变量

#增加环境路径#vim   /etc/profile    PATH=$PATH:/usr/local/mysql/bin

6.初始化数据库

# cd /usr/local/mysql# ./scripts/mysql_install_db --user=mysql --datadir=/database/mydata --explicit_defaults_for_timestamp=1

7.复制启动脚本

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

8.设置启动脚本变量

#vim  /etc/rc.d/init.d/mysqld添加basedir=/use/local/mysqldatadir=/database/mydata

9.开启mysql服务

# service mysqld start            

10.使用套接字连接

# mysql -S /tmp/mysql.sock  

11.mysql设置密码

 mysqladmin  -h localhost -u  root  password  “密码”