웹 개발 정보

 cd /home/server/

 tar -zxvf cmake-3.6.1.tar

 cd cmake-3.6.1

 ./bootstrap  

 make

 make install

 cd /home/server/

 tar -zxvf boost_1_59_0.tar

 cd boot_1_59_0

 ./boots

 ./b2 install

 cd /home/server/

 tar -zxvf mysql-5.7.24.tar

 cd /home/server/mysql-5.7.24

 cmake 

-DCMAKE_INSTALL_PREFIX=/home/server/mysql5.7 \

-DWITH_EXTRA_CHARSETS=all \

-DMYSQL_DATADIR=/home/server/mysql5.7/data \

-DENABLED_LOCAL_INFILE=1 \

-DDOWNLOAD_BOOST=1 \

-DWITH_BOOST=../boost_1_59_0 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DWITH_FEDERATED_STORAGE_ENGINE=1 \

-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DENABLED_LOCAL_INFILE=1 \

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \

-DSYSCONFDIR=/etc \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_EXTRA_CHARSETS=all

 cd /home/server/mysql-5.7.24

 make

 make install

 chown -R mysql.mysql /home/server/mysql-5.7

 cd  /home/server/mysql-5.7/bin

 ./mysqld --initialize --user=mysql --basedir=/home/server/mysql-5.7/ --datadir=/home/server/mysql-5.7/data

2018-12-27T07:56:27.913833Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2018-12-27T07:56:29.196662Z 0 [Warning] InnoDB: New log files created, LSN=45790

2018-12-27T07:56:29.520164Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.

2018-12-27T07:56:29.699679Z 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: eb3a375b-09ac-11e9-8094-782bcb0552a8.

2018-12-27T07:56:29.747774Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2018-12-27T07:56:29.759912Z 1 [Note] A temporary password is generated for root@localhost: 2Dnhu6+d;)HU < 임시비밀번호 

OR 

cat /var/log/mysqld.log | grep 'temporary password'

2018-12-27T07:56:29.759912Z 1 [Note] A temporary password is generated for root@localhost: 2Dnhu6+d;)HU < 임시비밀번호 

 cd /etc/

 vi my.cnf

[mysqld]

datadir=/home/server/mysql-5.7/data

socket=/var/lib/mysql/mysql.sock

user=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

 cd /home/server/mysql-5.7/support-files

 vi mysql.server

 ...

 basedir=/home/server/mysql-5.7

 datadir=/home/server/mysql-5.7/data

 ...

 cp /home/server/mysql-5.7/support-files/mysql.server /etc/init.d/mysqld

 chmod 755 /etc/init.d/mysql.d 

 cd /etc/init.d

 ./mysqld start

 cd /home/server/mysql-5.7/bin

 ./mysql  -u root -p

 SET PASSWORD = PASSWORD('your_new_password');

  cd /etc/init.d

 ./mysqld start

Starting MySQL.2018-12-27T08:02:26.158618Z mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists.

The server quit without updating PID file (/home/server/mys[실패]/data/pushtest2.pid).

cd /var/lib 

 mkdir mysql 

 chown mysql:mysql mysql

 cp /etc/init.d

 ./mysqld start --skip-grant-tables &

 /var/mysql/mysql.soct 파일 생성 확인 

 ./mysqld start 재시작(파일이 생성되어 있으면)