1. mysql 검색
sudo apt-cache search mysql-server
2. mysql 설치
sudo apt-get install mysql-server-5.6
3. db설정및 권한부여
mysql -u root -p
//default db 변경
use mysql;
//권한부여
GRANT ALL PRIVILEGES ON *.* to 'root'@'%' IDENTIFIED BY '내 mysql 비밀번호';
//즉시 반영
flush privileges;
//mysql 빠져나가기
quit
4. my.cnf 설정파일 변경
sudi nano /etc/mysql/my.cnf
bind-address = 127.0.0.1을 주석처리
5. mysql Server 재시작
sudo service mysql restart
6. 한글설정
sudo nano /etc/mysql/my.cnf
각 부분에 추가하시면 됩니다.
[client]
default-character-set=utf8
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
default-character-set=utf8
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
character-set-server=utf8
collation-server=utf8_general_ci
init_connect = set collation_connection = utf8_general_ci
init_connect = set names utf8
[mysqldump]
default-character-set=utf8
[mysql]
default-character-set=utf8
7. innodb 설정
sudo nano /etc/mysql/my.cnf
밑부분에 추가
innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50