Mysql的编译安装

一、安装编译工具及库文件

yum-y install gcc gcc-c++ make autoconf libtool-ltdl-devel gd-devel freetype-devel libxml2-devel libjpeg-devel libpng-devel openssl-devel curl-devel bison patch unzip libmcrypt-devel libmhash-devel ncurses-devel sudo bzip2 flex libaio-devel

二、安装cmake 编译器

cd /usr/local/src

wget http://www.cmake.org/files/v3.1/cmake-3.1.1.tar.gz

tar zxvf cmake-3.1.1.tar.gz

cd cmake-3.1.1

./bootstrap

make && make install

三、编译安装

添加用户

useradd -s /sbin/nologin mysql

建立所需目录

mkdir -p /data/mysql/data

chown -R mysql:mysql /data/mysql

cd /usr/local/src/

wgethttp://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.54.tar.gz

tar xzvf mysql-5.5.54.tar.gz

cd mysql-5.5.54

cmake -DMYSQL_USER=mysql -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.5 -DINSTALL_DATADIR=/data/mysql/data -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DDEFAULT_CHARSET=utf8  -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1

make && make install

chown -R mysql:mysql /usr/local/mysql5.5/

mv /usr/local/src/mysql-5.5.54/support-files/my-large.cnf /etc/my.cnf

mv /usr/local/src/mysql-5.5.54/support-files/mysql.server /etc/init.d/mysqld

chmod a+x /etc/init.d/mysqld

开启启动

chkconfig --level 345 mysqld on

设置环境变量

echo "export PATH=/usr/local/mysql5.5/bin/:$PATH" >> /etc/profile

source /etc/profile

 

/usr/local/mysql5.5/scripts/mysql_install_db --user=mysql --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql5.5 --datadir=/data/mysql/data

vim /etc/my.cnf

在[mysqld]下面加上

basedir=/usr/local/mysql5.5

datadir=/data/mysql/data

启动：

service mysqld start

 

创建mysql管理员

/usr/local/mysql5.5/bin/mysqladmin -u root password 'root'

连接数据库：

mysql -u root -proot