首页 > 数据库技术 > 详细

mysql-5.5.46源码编译安装

时间:2015-10-05 09:15:13      阅读:262      评论:0      收藏:0      [点我收藏+]

1.安装准备

 

cat /etc/redhat-release

uname -r

yum install ncurses-devel cmake automake autoconf make gcc gcc-c++ bison -y

mkdir /application/data -p

groupadd mysql

useradd -g mysql  -s  /sbin/nologin -M mysql

 

2.源码安装

cd  tools

tar xf mysql-5.5.46.tar.gz

cmake .-DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.46 \

-DMYSQL_DATADIR=/application/data \

-DMYSQL_UNIX_ADDR=/application/mysql-5.5.46/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_MYISAM_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 && makeinstall

3.Mysql初始化及配置

 

ln -s /application/mysql-5.5.46/ /application/mysql

cp support-files/my-small.cnf /etc/my.cnf

cd  /application

chown -R mysql.mysql data

chmod -R 1777 /tmp/

cd /application/mysql/scripts/

./mysql_install_db --basedir=/application/mysql --datadir=/application/data --user=mysql

 

4.加入开机启动

 

cp /root/tools/mysql-5.5.46/support-files/mysql.server /etc/init.d/mysqld

chmod +x /etc/init.d/mysqld  

chkconfig --add mysqld

chkconfig mysqld on

chkconfig mysqld --list

/etc/init.d/mysqld start

netstat -tunlp|grep mysqld

lsof -i:3306

 

5.设置Mysql环境变量

echo "PATH=/application/mysql/bin/:$PATH" >> /etc/profile

source /etc/profile

which mysql

mysql-5.5.46源码编译安装

原文:http://www.cnblogs.com/linuxzkq/p/4855340.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!