安装编译mysql5.5.53

一、编译安装cmake

wget https://cmake.org/files/v3.7/cmake-3.7.0.tar.gz
tar xf cmake-3.7.0.tar.gz
cd cmake-3.7.0 
./configure
gmake && gmake install

二、需要的依赖

yum install ncurses-devel -y

三、编译安装

wget http://mirrors.sohu.com/mysql/MySQL-5.5/mysql-5.5.53.tar.gz
tar xf mysql-5.5.53.tar.gz 
cd mysql-5.5.53

cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.53 \
-DMYSQL_DATADIR=/application/mysql-5.5.53/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.53/tmp/mysql.sock \
-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

四、配置mysql

添加用户

useradd -s /sbin/nologin mysql

初始化

ln -s /application/mysql5.5.53  /application/mysql
chown -R mysql.mysql /application/mysql/
/application/mysql/scripts/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data --user=mysql
cp my-small.cnf /etc/my.cnf 
cp mysql.server /etc/init.d/mysqld

mysql环境变量

echo 'PATH="/application/mysql/bin:$PATH"' >>/etc/profile
tail -1 /etc/profile
PATH="/application/mysql/bin:$PATH"
source /etc/profile
which mysql
/application/mysql/bin/mysql

启动数据库

/etc/ini.d/mysqld start

五、优化mysql

给mysql用户增加密码

mysqladmin -uroot password 123456

删除多余的数据库和用户

drop database test;
select user,host from mysql.user;
delete from mysql.user where user="" and host="";

六、授权数据库

grant all on name.* to name@'localhost' identified by '123456';