Mysql 5.7.18 소스 설치

[boost 1.5.9 설치]

mkdir /usr/local/boost

wget -P /usr/local/boost http://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz

cd /usr/local/boost/

tar zfvx boost_1_59_0.tar.gz;

 

[mysql 5.7 설치]

wget -P /root/src https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.18.tar.gz

cd /root/src/; tar zvxf mysql-5.7.18.tar.gz; cd /root/src/mysql-5.7.18

 

cmake -DCMAKE_INSTALL_PREFIX=/home/mysql -DWITH_INNOBASE_STORAGE_ENGINE=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DENABLED_LOCAL_INFILE=1 -DENABLE_DOWNLOADS=1 -DWITH_EXTRA_CHARSETS=all -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost

 

make -j `grep processor /proc/cpuinfo | wc -l`; make install

 

useradd -M -s /bin/false mysql

 

/home/mysql/bin/mysqld --initialize --user=mysql --datadir=/home/mysql/var

ㄴ 입력하고나서 아래 초기패스워드로 접속 후 패스워드 변경해줘야 한다.

*초기 패스워드*

[root@q381-1261 ~]# /home/mysql/bin/mysqld --initialize --user=mysql --datadir=/home/mysql/var

2020-08-26T16:39:19.958989+09:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

100 200

100 200

2020-08-26T16:39:21.352464+09:00 0 [Warning] InnoDB: New log files created, LSN=45790

2020-08-26T16:39:21.401264+09:00 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2020-08-26T16:39:21.479280+09:00 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 41843c21-e76f-11ea-9506-3cecef219280.

2020-08-26T16:39:21.489344+09:00 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2020-08-26T16:39:21.491481+09:00 1 [Note] A temporary password is generated for root@localhost: H;oaDZ=9uN/e

2020-08-26T16:39:22.450234+09:00 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.

2020-08-26T16:39:22.450257+09:00 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.

2020-08-26T16:39:22.450270+09:00 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.

2020-08-26T16:39:22.450280+09:00 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.

2020-08-26T16:39:22.450302+09:00 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.

 

 

chown -R mysql. /home/mysql/

 

vi /home/mysql/support-files/mysql.server

basedir=/home/mysql

datadir=/home/mysql/var

 

[mysql root 패스워드 변경]

ALTER USER 'root'@'localhost' IDENTIFIED BY 'e54a4a8e';

flush privileges;