安装前系统准备
1.gcc-c++、ncurses包
# yum install gcc-c++ ncurses-devel
2.GNU make程序包。建议安装GNU make 3.75以上版本,下载地址http://www.gnu.org/software/make/
# yum install make
3.安装cmake,用来编译mysql,MySQL 5.5以后,源码安装需要使用CMake来编译。下载地址http://www.cmake.org
# tar -xvf cmake-3.2.0-.tar.gz
# mv cmake-3.2.0cmake# mv cmake/tmp/# cd/tmp/cmake/# ./bootstrap
# make
# make install
# cmake--version
4.bison程序包。下载地址 http://www.gnu.org/software/bison/
# tar -xvf bison-3.0.tar.gz
# mv bison-3.0bison
# mv bison/tmp
# cd/tmp/bison/# ./cofigure
# make
# make install
# bison--version
5.如果想运行test scripts,还需要安装perl
创建mysql用户:
# /usr/sbin/groupadd mysql
#/usr/sbin/useradd -g mysql mysql
编译安装:
# tar -xvf mysql-5.5.44.tar.gz
# cd mysql-5.5.44# cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \-DMYSQL_DATADIR=/var/mysql/data \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DEXTRA_CHARSETS=all \-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \-DWITH_MYISAM_STORAGE_ENGINE=1\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DENABLED_LOCAL_INFILE=1\-DMYSQL_TCP_PORT=3306\-DMYSQL_USER=mysql \-DSYSCONFDIR=/etc
# make
# make install
cmke参数补充说明:
#mysql安装的主目录,版本默认为/usr/local/mysql-DCMAKE_INSTALL_PREFIX=/usr/local/mysql
#mysql数据保存的路径,自定义-DMYSQL_DATADIR=/var/mysql/data
#mysql配置文件地址------The defaultmy.cnf option file directory-DSYSCONFDIR=/etc
#Compile storage engine xxx statically into server
#Storage engines are builtas plugins. You can build a plugin as a staticmodule (compiled into the server)
#or a dynamic module (builtas a dynamic library that must be installed into the server usingthe INSTALL
#PLUGIN statement or the--plugin-load option before it can be used). Some plugins might not support static#or dynamic building.-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_MYISAM_STORAGE_ENGINE=1#Unix socket file
#The Unix socket file path on which the server listensforsocket connections. This must be an absolute path
#name. Thedefault is /tmp/mysql.sock-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock
#数据库服务器TCP/IP连接的监听端口,默认为3306-DMYSQL_TCP_PORT=3306#Whether to enable LOCAL capabilityin the client library forLOAD DATA INFILE
#默认为关闭,这里开启-DENABLED_LOCAL_INFILE=1#数据库编码设置-DEXTRA_CHARSETS=all-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8-general_ci
一些相关设置
# mkdir -p /var/mysql/# mkdir-p /var/mysql/data/# mkdir-p /var/mysql/log/# chown-R mysql:mysql /var/mysql/
# cd support-files/
# cp my-medium.cnf /etc/my.cnf
(注意:my-large.cnf适用于1G内存左右的服务器,可以根据自己配置情况选用my-large.cnf 、my-medium.cnf或 my-huge.cnf 等不同配置)
#vi /etc/my.cnf(编辑此文件,查找并修改以下变量内容:)
basedir=/usr/local/mysql
datadir=/var/mysql/data
mysql 初始化:
# 利用mysql_install_db脚本生成新的MySQL授权表
$ cd/usr/local/mysql/support-files/usr/local/mysql/scripts/mysql_install_db \--defaults-file=/etc/my.cnf \--basedir=/usr/local/mysql \--datadir=/var/mysql/data \--user=mysql
将mysql添加到服务,并配置开机启动:
# cp mysql.server /etc/init.d/mysqld
# chmod+x /etc/init.d/mysqld
# chkconfig--add mysqld
# chkconfig--level 345 mysqld on
启动服务:
# service mysqld start