CentOS6.5系统搭建mysql服务器

环境：CentOS 6.5 x86_64-minimal

1 安装编译mysql的包

yum remove mysql-server mysql -y

yum -y install gcc gcc-c++ ncurses-devel zlib-devel bison cmake openssl-devel perl

2 创建mysql用户和目录

useradd mysql

mkdir -p /usr/local/mysql

mkdir -p /db/mysql/data

3 编译安装mysql

cd ~

wget -c http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.10.tar.gz

tar -xzvf mysql-5.6.10.tar.gz

cd mysql-5.6.10

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/db/mysql/data -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=3306

make && make install

4 配置MYSQL

 修改mysql目录的权限

chown -R mysql:mysql /usr/local/mysql/

chown -R mysql:mysql /db/mysql/data/

 初始化mysql

\cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

cd /usr/local/mysql

scripts/mysql_install_db --user=mysql --datadir=/db/mysql/data

添加环境变量

cd ~

echo "PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:\$PATH" >> /etc/profile

echo "export PATH" >> /etc/profile

source /etc/profile

设置MYSQL开机启动

\cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig mysqld on

启动mysql

service mysqld start

设置mysql密码

mysqladmin -u root password ‘123456‘

导入开发的库文件