yum -y install gcc gcc-c++ autoconf automake zlib* fiex* libxml* ncurses-devel
yum -y install libmcrypt* libtool-ltdl-devel* make cmake
useradd -M -s /sbin/nologin mysql
tar zxvf mysql-5.6.10.tar.gz
cd mysql-5.6.10
cmake .
make && make install
chown -R mysql.mysql /usr/local/mysql
cd /usr/local/mysql/scripts
./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mydata
cd /usr/local/mysql/support-files
cp mysql.server /etc/rc.d/init.d/mysql
cp my-default.cnf /etc/my.cnf
chkconfig --add mysql
chkconfig mysql on
service mysql start
---------------------------------------------------
vim /etc/my.cnf
添加一行
federated ,以下相关engines变为YES,plugins变为ACTIVE,这个是跨机器访问数据库的引擎
mysql> show plugins;