一、安装方式
1、企业内部系统安装推荐yum安装,对数据库要求不高,并发不大,源码制作rpm,搭建rpm仓库,然后yum install xxx -y
2、常规方式编译安装MySql
5.1以前:./configure \ make, make isntall
5.5-5.6:
(1)、tar zxf mysql.5.6.gar.gz
(2)、cd mysql5.6
cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.6.45 \
-DMYSQL_DATADIR=/application/mysql-5.6.45/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.6.45/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
(3)、切换到 mysql5.6 目录中 执行 make && make install
(附:需要安装cmake gmake , gmake install
tar xf cmake-2.8.9.tar.gz(自己下载)
cd cmake-2.8.9
./configure
#CMake has bootstrapped. Now run gmake.
gmake
gmake install
)
(4)、依赖包安装:yum install ncurses-devel -y
(5)、创建用户和组
groupadd mysql
useradd mysql -s /sbin/nologin -M -g mysql