MySQL-5.5.48源码安装

1.安装MySQL基础及依赖软件

yum install ncurses-devel libaio-devel -y

2.安装gmake编译软件

mkdir /server/tools -p
cd /server/tools/
wget http://www.cmake.org/files/v3.2/cmake-3.2.3.tar.gz
tar -zxvf cmake-3.2.3.tar.gz
cd cmake-3.2.3
./configure
gmake
gmake install

3.创建MySQL用户及组

useradd -s /sbin/nologin -M mysql

4.编译MySQL三部曲

cd /server/tools
#http://dev.mysql.com/downloads/mirrors.html
wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.48.tar.gz
#wget http://cdn.mysql.com/archives/mysql-5.5/mysql-5.5.48.tar.gz
tar -zxvf mysql-5.5.48.tar.gz
cd mysql-5.5.48
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.5.48 \
-DMYSQL_DATADIR=/usr/local/mysql-5.5.48/data \
-DMYSQL_UNIX_ADDR=/usr/local/mysql-5.5.48/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0
make && make install

5.创建MySQL软链接

ln -s /usr/local/mysql-5.5.48 /usr/local/mysql

6.初始化MySQL数据库

/usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --user=mysql
\cp /usr/local/mysql/support-files/my-huge.cnf /etc/my.cnf 
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

7.MySQL环境变量

echo 'PATH="/usr/local/mysql/bin:$PATH"' >> /etc/profile
source /etc/profile

8.启动MySQL数据库及开启启动

/etc/init.d/mysqld start
chkconfig mysqld on

9.MySQL数据目录权限配置

chown -R mysql.mysql /usr/local/mysql/data
chmod -R 1777 /tmp

10.检查MySQL数据库安装

/etc/init.d/iptables stop
chkconfig iptables off
/etc/init.d/mysqld stop
/etc/init.d/mysqld start
netstat -lnutp|grep 3306

 

mysql> grant all on shop.* to 'shop'@'192.168.2.%' identified by '123456' with grant option; //增加用户并允许用户授权其他用户权限
 Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;  //刷新权限