MySQL入门教程

操作系统：CentOS 6.7
MySQL版本：5.6.30

1.前期准备
2.系统配置
3.CMake编译配置
4.make && make install
5.后期配置和测试
Reference

1.前期准备

首先需要CMake，可以yum直接安装：yum install cmake也可以官网 https://cmake.org/ 下载源码编译。
我这里选择了官网下载最新版本cmake-3.5.2.tar.gz。

# tar -zxvf cmake-3.5.2.tar.gz && cd cmake-3.5.2# ./configure部分输出略。-- Build files have been written to: /soft/cmake-3.5.2---------------------------------------------CMake has bootstrapped.Now run gmake.# gmake # make install

2.系统配置

添加组和用户：groupadd mysqluseradd -g mysql mysqlvi /etc/security/limits.conf 文件末尾添加：mysql softnproc 2047mysql hardnproc 16384mysql softnofile1024mysql hardnofile65536

3.CMake编译配置

解压源码包：tar zxvf mysql-5.6.30.tar.gz && cd mysql-5.6.30CMake编译配置

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DENABLED_LOCAL_INFILE=ON -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DCOMPILATION_COMMENT="JSS for mysqltest" -DWITH_READLINE=ON -DSYSCONFDIR=/data/mysqldata/3306 -DMYSQL_UNIX_ADDR=/data/mysqldata/3306/mysql.sock

遇到以下错误，

-- Could NOT find Curses （missing:CURSES_LIBRARY CURSES_INCLUDE_PATH） CMake Error at cmake/readline.cmake:85 （MESSAGE）:Curses library not found.Please install appropriate package,remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on RedHat and derivates it is ncurses-devel.Call Stack （most recent call first）:cmake/readline.cmake:128 （FIND_CURSES）cmake/readline.cmake:202 （MYSQL_USE_BUNDLED_EDITLINE）CMakeLists.txt:421 （MYSQL_CHECK_EDITLINE）-- Configuring incomplete, errors occurred！See also "/soft/mysql-5.6.30/CMakeFiles/CMakeOutput.log".See also "/soft/mysql-5.6.30/CMakeFiles/CMakeError.log".[root@JY-DB mysql-5.6.30]#

yum安装提示缺失的包：yum install ncurses-devel重新删除配置文件：rm -rf CMakeCache.txt然后重新CMake工具编译：

CMake Warning:Manually-specified variables were not used by the project:WITH_READLINE-- Build files have been written to: /soft/mysql-5.6.30[root@JY-DB mysql-5.6.30]#

4.make && make install

[root@JY-DB mysql-5.6.30]# make && make install大量输出略。这个时间会比较长，也跟机器性能有关。

5.后期配置和测试

5.1 打包MySQL二进制版本：

[root@JY-DB data]# tar zcvf mysql-5.6.30.tar.gz /usr/local/mysql/

5.2 修改MySQL软件所在目录拥有者：

chown -R mysql.mysql /usr/local/mysql

5.3 修改mysql用户环境变量：

vi ~/.bash_profileexport LANG=zh_CN.GB18030export PATH=/usr/local/mysql/bin:$PATH

5.4 创建数据库服务：

# mkdir -p /data/mysqldata/{3306/{data,tmp,binlog},backup,scripts}# chown -R mysql.mysql /data/mysqldata# su - mysql$ more /usr/local/mysql/support-files/my-default.cnf $ vi /data/mysqldata/3306/my.cnf

my.cnf配置文件内容如下：

[client]port = 3306socket = /data/mysqldata/3306/mysql.sock#The MySQL Server[mysqld]port = 3306user = mysqlsocket = /data/mysqldata/3306/mysql.sockpid-file = /data/mysqldata/3306/mysql.pidbasedir = /usr/local/mysqldatadir = /data/mysqldata/3306/datatmpdir = /data/mysqldata/3306/tmpopen_files_limit = 10240explicit_defaults_for_timestampsql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES#Buffermax_allowed_packet = 256Mmax_heap_table_size = 256Mnet_buffer_length = 8ksort_buffer_size = 2Mjoin_buffer_size = 4Mread_buffer_size = 2Mread_rnd_buffer_size = 16M#Loglog-bin = /data/mysqldata/3306/binlog/mysql-binbinlog_cache_size = 32Mmax_binlog_cache_size = 512Mmax_binlog_size = 512Mbinlog_format = mixedlog_output = FILElog-error = ../mysql-error.logslow_query_log = 1slow_query_log_file = ../slow_query.loggeneral_log = 0general_log_file = ../general_query.logexpire-logs-days = 14#InnoDBinnodb_data_file_path = ibdata1:2048M:autoextendinnodb_log_file_size = 256Minnodb_log_files_in_group = 3innodb_buffer_pool_size = 1024M[mysql]no-auto-rehashprompt = （u@h）[d]>\_default-character-set = gbk

初始化MySQL数据库：$ /usr/local/mysql/scripts/mysql_install_db --datadir=/data/mysqldata/3306/data --basedir=/usr/local/mysql

5.5 启动数据库服务：

mysqld_safe --defaults-file=/data/mysqldata/3306/my.cnf &测试连接并查看MySQL进程和端口监听状态：netstat -lnt | grep 3306ps -ef | grep bin/mysql | grep -v grep实际操作过程如下：

[root@JY-DB ~]# su - mysql[mysql@JY-DB ~]$ mysqlWelcome to the MySQL monitor.Commands end with ; or g.Your MySQL connection id is 1Server version: 5.6.30-log JSS for mysqltestCopyright （c） 2000, 2016, 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.（root@localhost）[（none）]> exitBye[mysql@JY-DB ~]$ netstat -lnt |grep 3306tcp00 :::3306 :::*LISTEN[mysql@JY-DB ~]$[mysql@JY-DB ~]$ ps -ef | grep bin/mysql | grep -v grepmysql 673617530 11:24 pts/000:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysqldata/3306/my.cnfmysql 720267360 11:24 pts/000:00:00 /usr/local/mysql/bin/mysqld --defaults-file=/data/mysqldata/3306/my.cnf --basedir=/usr/local/mysql --datadir=/data/mysqldata/3306/data --plugin-dir=/usr/local/mysql/lib/plugin --log-error=/data/mysqldata/3306/data/../mysql-error.log --open-files-limit=10240 --pid-file=/data/mysqldata/3306/mysql.pid --socket=/data/mysqldata/3306/mysql.sock --port=3306

Reference

李丙洋. 涂抹MySQL. 水利水电出版社, 2014. PDF 下载见 http://www.linuxidc.com/Linux/2016-06/132479.htm
dev.mysql.com

更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2016-06/132477p2.htm

【内容导航】
第1页：MySQL源码安装	第2页：MySQL二进制版本快速部署
第3页：MySQL配置安全性、易用性	第4页：MySQL主从配置

Oracle数据库验证IMP导入元数据是否会覆盖历史表数据MySQL数据库迁移相关资讯 MySQL入门教程 MySQL源码安装

MySQL源码安装、配置、初始化及启（今 07:47）
MySQL源码编译安装（ 5.5 、5.6 共（03月30日）
30分钟带你快速入门MySQL教程（02月03日）

MySQL 5.6.29源码编译安装记录（04月27日）
CentOS 6.6下MySQL 5.6 源码编译安（03月30日）
MySQL 源码scr.rpm安装的一点注意（10/18/2014 21:02:39）

本文评论查看全部评论（0）