Linux下MySQL编译安装及初始化

环境

操作系统：CentoOS 6.7 x64
御马安装包：/opt/mysql-5.6.29.tar.gz
MySQL安装目录：/opt/yliyun/mysql

第一步 安装编译所需依赖

yum -y install wget bison gcc gcc-c++ autoconf automake zlib* libxml* ncurses-devel libtool-ltdl-devel* cmake make

第二步 解压

cd opt
tar zxf mysql-5.6.29.tar.gz

第三步 编译安装

cd opt/mysql-5.6.29cmake . \
-DCMAKE_INSTALL_PREFIX=/opt/yliyun/mysql \
-DMYSQL_DATADIR=/opt/yliyun/mysql/data \
-DINSTALL_LIBDIR=/opt/yliyun/mysql/lib \
-DINSTALL_PLUGINDIR=/opt/yliyun/mysql/plugin \
-DMYSQL_UNIX_ADDR=/opt/yliyun/mysql/data/mysql.sock \
-DSYSCONFDIR=/opt/yliyun/mysql/etc \
-DMYSQL_USER=root \
-DMYSQL_TCP_PORT=3306 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 makemake install

第四步 初始化数据库

cd opt/yliyun/mysql
scripts/mysql_install_db --user=root --datadir=/opt/yliyun/mysql/data

第五步 默认配置文件my.cnf

mkdir -pv opt/yliyun/mysql/etc
cp -f opt/yliyun/mysql/support-files/my-default.cnf opt/yliyun/mysql/etc/my.cnf

修改 opt/yliyun/mysql/etc/my.cnf内容，部分修改如下：

[mysqld]
 innodb_buffer_pool_size = 128M
 log_bin=mysql-bin
 expire-logs-days=30
 binlog-do-db=yliyun binlog-do-db=yliyun_log binlog-ignore-db=test
 basedir = opt/yliyun/mysql
 datadir = opt/yliyun/mysql/data
 port = 3306
 server_id = 1
 socket = opt/yliyun/mysql/data/mysql.sock user = root
 join_buffer_size = 128Msort_buffer_size = 2M
 read_rnd_buffer_size = 2M 
 key_buffer_size = 16M
 max_allowed_packet = 8M
 table_open_cache = 64
 skip-name-resolve

innodb_file_per_table = 1
 innodb_log_file_size = 16M
 innodb_log_buffer_size = 4M
 slow_query_log_file = opt/yliyun/mysql/logs/slowquery.log
 slow_query_log = 1
 long_query_time = 1sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqld_safe]log-error=/opt/yliyun/mysql/logs/mysql-error.log

第六步 配置开机启动

mkdir -pv /var/lock/subsys/mysql
cp -f /opt/yliyun/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld

修改/etc/rc.d/init.d/mysqld中如下内容：

basedir=/opt/yliyun/mysqldatadir=$basedir/datamysqld_pid_file_path="$datadir/mysql.pid"

配置开机启动

chmod 755 /etc/rc.d/init.d/mysqld
chkconfig --add mysqldservice mysqld start

第七步 设置root管理员密码

/opt/yliyun/mysql/bin/mysqladmin -u root password "root密码"

第八步 删除空密码账户

mysql/bin/mysql -uroot -p -e "use mysql; delete from user where password='';"

注：分享此文章积赞15个，合天就会送大家20个合式币，还会随机抽取一名幸运者，奉上   小米LED随身灯一个。要发截屏给小编，空口无凭嘛，每人每天一次机会！