mysql 5.5编译安装

一、系统环境

OS系统环境：CentOS release 6.1 Mysql版本：mysql-5.5.17.tar.gz

二、数据库安装

2.1新增mysql用户

[root@localhost ~]# groupadd mysql –g 502

[root@localhost ~]# useradd -r -g mysql mysql -u 502 系统环境配置：

[root@localhost ~]# yum install -y gcc gcc-c++ make ncurses-devel bison cmake libaio libaio-devel

2.2编译安装

[root@localhost ~]# mkdir /data/mysql

[root@localhost ~]#chown -R mysql:mysql /data/mysql [root@localhost ~]# tar zxvf mysql-5.5.17.tar.gz [root@localhost ~]# cd mysql-5.5.17 [root@localhost ~]# cmake . \\

-DCMAKE_INSTALL_PREFIX=/opt/mysql ===> 指定MySQL安装路径 -DMYSQL_DATADIR=/data/mysql ===> mysql数据保存的路径 -DWITH_DEBUG=0 ===> 关闭debug模式 -DDEFAULT_CHARSET=utf8 ===> 默认服务器字符集 -DWITH_EXTRA_CHARSETS=all ===> 额外的字符集 -DDEFAULT_COLLATION=utf8_general_ci ===> 服务器的排序规则。默认情况下，MySQL使用latin1_swedish_ci。使用SHOW COLLATION语句来确定每个字符集的排序规则。 -DENABLED_LOCAL_INFILE=1 ===> 允许从本地导入数据,load命令需要用到 -DWITH_INNOBASE_STORAGE_ENGINE=1 ===> 打开innodb引擎 -DWITH_PARTITION_STORAGE_ENGINE=1 ===> 打开partition引擎 [root@localhost ~]# make && make install

2.3创建MySQL授权表

[root@localhost ~]# cd /opt/mysql

[root@localhost ~]# chown -R root:mysql .

[root@localhost ~]# scripts/mysql_install_db --user=mysql --datadir=/data/mysql [root@localhost ~]# cp support-files/my-medium.cnf /etc/my.cnf

2.4配置mysql

[root@localhost ~]# cp support-files/mysql.server /etc/init.d/mysqld [root@localhost ~]# chmod +x /etc/init.d/mysqld

[root@localhost ~]# chkconfig --add mysqld

[root@localhost ~]# chkconfig --level 2345 mysqld on

[root@localhost ~]# echo \"export PATH=$PATH:/opt/mysql/bin\" >>/etc/profile [root@localhost ~]# source /etc/profile

2.5修改配置文件(my.cnf )

[mysqld_safe]

log-error=/log/mysql

pid-file=/var/run/mysqld/mysqld.pid

2.6启动mysql服务器

[root@localhost ~]# /etc/init.d/mysqld start

修改mysql中root用户的密码

[root@localhost ~]# mysqladmin –u root password “123456”

2.7查看mysql是否启用libaio

mysql> show variables like '%aio'; +---------------------------+----------+ | Variable_name | Value | +----------------------------+----------+ | innodb_use_native_aio | ON | +----------------------------+----------+