[MySQL] MYSQL설치관련

https://salix97.tistory.com/141

 

 

MySQL에서 로그인 안 될 때

내가 쓴 방법

 # killall mysqld

 # mysqld_safe  --skip-grant-tables &

이 두개를 썼더니 로그인 되었다.

 

https://babytiger.tistory.com/entry/mysql%EC%97%90-%EB%A1%9C%EA%B7%B8%EC%9D%B8%EC%9D%B4-%EC%95%88-%EB%90%A0-%EA%B2%BD%EC%9A%B0

mysql에 로그인이 안 될 경우

엿먹었던 자료

https://bluexmas.tistory.com/631

엿먹었던 자료 2 - 8.0.X버젼

https://bluexmas.tistory.com/869

CENTOS라 못한 자료

https://xinet.kr/?p=2149

 

제일 강력한 참고자료

http://gnujava.com/board/article_view.jsp?board_no=16&article_no=1893

 

mysql Reference참조 자료

https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html

https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html

 

mysql Compile옵션

https://sysadm.kr/m/26?category=576252

 

MySQL컴파일시 준 옵션
sudo cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
-DSYSCONFDIR=/usr/local/mysql \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_USER=mysql \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS=all \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DDOWNLOAD_BOOST=0 -DWITH_BOOST=./boost

 

 

sudo systemctl status mysqld.service
sudo systemctl stop mysqld.service

 

sudo useradd -g mysql -s /bin/bash -m mysql

 

 

 

 

이유해석

sudo cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
=> base directory

-DMYSQL_DATADIR=/usr/local/mysql/data \
=> mysql data directory

-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
=> 소켓 파일 위치 => 실제 통신할 때 만들어진다.

-DSYSCONFDIR=/usr/local/mysql \
=> The default my.cnf option file directory.

-DMYSQL_TCP_PORT=3306 \
=> The port number on which the server listens for TCP/IP connections. The default is 3306.
server와 TCP/IP로 통신한다. 하나의 서버처럼 동작중이다.

-DDEFAULT_CHARSET=utf8 \
-DMYSQL_USER=mysql \



-DENABLED_LOCAL_INFILE=1 \