ftp://mirror.switch.ch/mirror/mysql/Downloads/
国内 http://mirrors.sohu.com/mysql/


yum install rpm-build gperf ncurses-devel cmake  libaio-devel
rpm -ivh MySQL-5.6.30-1.el6.src.rpm

cd ./rpmbuild/SPECS/
rpmbuild -bb mysql.spec --define='runselftest 0'
cd ../RPMS/x86_64/  里面是编译好的rpm包

源码安装
wget http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.34.tar.gz

yum -y install make gcc-c++ cmake bison-devel  ncurses-devel
groupadd mysql
useradd -g mysql mysql

cmake \
-DCMAKE_INSTALL_PREFIX=/data/mysql/ \
-DMYSQL_DATADIR=/data/mysql/data \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci

make && make install

cp cp support-files/my-default.cnf /etc/my.cnf
##config file edit
vim /etc/my.cnf
skip-name-resolve=1

cp support-files/mysql.server /etc/init.d/mysql
chmod 755 /etc/init.d/mysql

chown mysql.mysql /data/mysql/ -R
##init mysql datadir
chmod 755 scripts/mysql_install_db
scripts/mysql_install_db --user=mysql --basedir=/data/mysql/ --datadir=/data/mysql/data/

/etc/init.d/mysql start

运行sql  /data/mysql/bin/mysql
delete from mysql.user where user="";  删除匿名用户
set password=PASSWORD('pass');      设置登录密码
FLUSH PRIVILEGES;

results matching ""

    No results matching ""