Mysql 5.7 소스설치

1.필수패키지 설치

# yum install gcc* ncurses-devel cmake

2.계정추가

# groupadd -g 400 mysql

# useradd -u400 -g400 -d /usr/local/mysql -s /bin/false mysql

3.설치

# tar xvfz mysql-5.7.14.tar.gz

# cd mysql-5.7.14

# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DSYSCONFDIR=/etc -DDEFAULT_CHARSET=utf8 -DMYSQL_TCP_PORT=3306 -DWITH_EXTRA_CHARSETS=all -DDEFAULT_COLLATION=utf8_general_ci

# mv boost_1_59_0 /usr/local/include/boost

# cd /usr/local/include/boost/boost_1_59_0

# ./bootstrap.sh

# ./b2 install

4.설정

# cp -arp support-files/my-default.cnf /etc/my.cnf

# cp -arp support-files/mysql.server /etc/init.d/mysqld

# /usr/local/mysql/bin/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql

# chown -R mysql.mysql /usr/local/mysql

# chmod 711 /usr/local/mysql

# chmod 700 /usr/local/mysql/data

# chmod 751 /usr/local/mysql/bin

# chmod 750 /usr/local/mysql/bin/*

# chmod 755 /usr/local/mysql/bin/mysql

# chmod 755 /usr/local/mysql/bin/mysqldump

# chmod 700 /etc/init.d/mysqld

# chkconfig –add mysqld

# chkconfig mysqld on

# /etc/init.d/mysqld start

5. 시작 후 패스워드 변경

# cat /root/.mysql_secret

패스워드 변경

# mysqladmin -u root -p password