[CentOS 7] MySQL 5.7.20 컴파일 설치 :: 마이자몽

이전에 MySQL 패키지 설치하는 것을 했다.

이번에는 MySQL 소스 컴파일 설치하는 것을 할거다.

둘중 어느 방법으로 설치해서 사용해도 상관 없지만... 설치한 프로그램들을 계정내에 한 폴더에서 관리하기 위해 컴파일 설치를 할것이다.

https://downloads.mysql.com/archives/

MySQL Communitiy Server 클릭

필자는 5.7.20버전을 설치한다.

다운로드 링크 주소를 복사한다.

wget으로 설치파일을 받고 풀어준다.

[jamong@localhost ~]$ cd dev_util
[jamong@localhost dev_util]$ mkdir mysql
[jamong@localhost dev_util]$ cd mysql/
[jamong@localhost mysql]$ wget https://downloads.mysql.com/archives/get/file/mysql-5.7.20.tar.gz
[jamong@localhost mysql]$ tar xvfz mysql-5.7.20.tar.gz

MySQL 컴파일 설치를 위한 라이브러리를 설치하고 풀어준다.

[jamong@localhost mysql]$ wget http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
[jamong@localhost mysql]$ tar xvfz boost_1_59_0.tar.gz

컴파일 설치를 위한 패키지도 설치한다.

[jamong@localhost mysql]$ sudo yum install cmake ncurses ncurses-devel

이제 컴파일 설치를 한고 my.cnf파일을 수정한다.

[jamong@localhost mysql]$ cd mysql-5.7.20/
[jamong@localhost mysql-5.7.20]$ cmake \
-DCMAKE_INSTALL_PREFIX=/home/jamong/dev_util/mysql \
-DWITH_EXTRA_CHARSETS=all \
-DMYSQL_DATADIR=/home/jamong/dev_util/mysql/mysql_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=/tmp/mysql.sock \
-DSYSCONFDIR=/etc \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS=all
[jamong@localhost mysql-5.7.20]$ make
[jamong@localhost mysql-5.7.20]$ make install
[jamong@localhost mysql-5.7.20]$ make clean

[jamong@localhost mysql-5.7.20]$ sudo vi /etc/my.cnf

my.cnf 파일

[client]
default-character-set = utf8
port = 3306
socket = /tmp/mysql.sock
default-character-set = utf8
 
 
[mysqld]
socket=/tmp/mysql.sock
datadir=/home/jamong/dev_util/mysql/mysql_data
basedir = /home/jamong/dev_util/mysql
user = jamong
bind-address = 0.0.0.0
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
 
skip-name-resolve
 
max_connections = 1000
max_connect_errors = 1000
wait_timeout= 60
 
explicit_defaults_for_timestamp
 
symbolic-links=0
 
log-error=/home/jamong/dev_util/mysql/mysql_data/mysqld.log
pid-file=/tmp/mysqld.pid
 
character-set-client-handshake=FALSE
init_connect = SET collation_connection = utf8_general_ci
init_connect = SET NAMES utf8
character-set-server = utf8
collation-server = utf8_general_ci
 
symbolic-links=0
 
default-storage-engine = myisam
key_buffer_size = 32M
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1

mysql을 설치한다.

[jamong@localhost etc]$ cd /home/jamong/dev_util/mysql/bin
[jamong@localhost bin]$ ./mysql_install_db --user=jamong --datadir=/home/jamong/dev_util/mysql/mysql_data

이제 mysql server를 바로 실행할수 있도록 설정하고 실행한다.

[jamong@localhost bin]$ cd /home/jamong/dev_util/mysql/support-files
[jamong@localhost support-files]$ sudo cp mysql.server /usr/bin
[jamong@localhost support-files]$ mysql.server start
Starting MySQL. SUCCESS!

mysql 명령도 복사해준다.

[jamong@localhost support-files]$ cd /home/jamong/dev_util/mysql/bin
[jamong@localhost bin]$ sudo cp mysql /usr/bin

이제 로그인해서 사용하면 되는데, root의 비밀번호를 모른다.

root 비밀번호를 설정한다.

mysql_secure_installation을 실행해주면 .mysql_secret 파일이 생성되면서 초기 비밀번호를 만들어준다.

이후 비밀번호 재설정 할꺼냐고 물어본다.

전부 Yes로 답해주고  비밀번호 강도는 적당히 1을 선택해준다.

(숫자, 소문자, 대문자, 8자이상의 조합)

[jamong@localhost bin]$ ./mysql_secure_installation
mysql_secure_installation: [ERROR] unknown variable 'default-character-set=utf8'
 
Securing the MySQL server deployment.
 
Connecting to MySQL server using password in '/home/jamong/.mysql_secret'
 
VALIDATE PASSWORD PLUGIN can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD plugin?
 
Press y|Y for Yes, any other key for No: yes
 
There are three levels of password validation policy:
 
LOW    Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary                  file
 
Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 1
Using existing password for root.
 
Estimated strength of the password: 100
Change the password for root ? ((Press y|Y for Yes, any other key for No) : yes
 
New password:
 
Re-enter new password:
 
Estimated strength of the password: 100
Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : yes
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.
 
Remove anonymous users? (Press y|Y for Yes, any other key for No) : yes
Success.
 
 
Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.
 
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : yes
Success.
 
By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.
 
 
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : yes
 - Dropping test database...
Success.
 
 - Removing privileges on test database...
Success.
 
Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.
 
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : yes
Success.

설정한 비밀번호로 mysql 접속을 해보자.

쿼리를 치니까.... 비밀번호를 바꿔주라고나온다....

그냥 위에서 비밀번호 바꾸지 않는다고 하고 No로해도 상관없을것같다.

하지만, 초기비밀번호는 오타확률이 높기 때문에 그냥 바꿔주고 한번 더 바꿔주는 것도 나쁘지 않는듯 하다.

[jamong@localhost ~]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.20
 
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> SET PASSWORD = PASSWORD('비밀번호');
Query OK, 0 rows affected, 1 warning (0.01 sec)
 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

끝.