Linux环境下编译安装mysql,从mysql5.5开始就需要使用cmake编译安装。
一、安装cmake
tar -zxvf cmake-2.8.11.2.tar.gz
cd cmake-2.8.11.2
./configure --prefix=/usr/local/cmake
make && make install
二、安装mysql 5.6.13
1.创建mysql服务使用的专用用户组和用户
groupadd mysql
useradd -g mysql mysql -s /usr/sbin/nologin
2.创建mysql安装目录和数据存储目录
mkdir -p /usr/local/mysql/data
3.解压安装mysql
tar -zxvf mysql-5.6.13.tar.gz
cd mysql-5.6.13
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql
make && make install
注意此处的-D是cmake软件的参数,之后才是对应的参数值,此处对应的参数值是CMAKE_INSTALL_PREFIX=/usr/local/mysql;查看帮助命令cmake . -LH
进入mysql的安装目录/usr/local/mysql,初始化数据库
scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --
user=mysql
拷贝配置文件
cp support-files/my-default.cnf /usr/local/mysql/my.cnf
更改mysql数据库所在的目录权限
chown -R mysql:mysql /usr/local/mysql
修改配置文件
vim /usr/local/mysql/my.cnf
在[mysqld]下加上以下内容:
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
log-error = /usr/local/mysql/mysql_error.log
pid-file = /usr/local/mysql/mysql.pid
user = mysql
tmpdir = /tmp
4.将mysql添加为系统服务
cd /usr/local/mysql/support-files/
cp ./mysql.server /etc/init.d/mysqld
5.设置mysql服务为自启动服务
chkconfig --add mysqld
chkconfig --level 345 mysqld on
评论已关闭!