mysql 5.5.48_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; //刷新权限