mysql시작하기

- MySQL 활성화

echo 'mysql_enable="YES"' >> /etc/rc.conf

- MySQL 설정

cp /usr/local/share/mysql/my-medium.cnf /etc/my.cnf

UTF-8로 설정

# vi /etc/my.cnf

--------------------------------------------------------------------------------

[client]

default-character-set=utf8

[mysqld]

character-set-client-handshake=FALSE

init_connect="SET collation_connection=utf8_general_ci"

init_connect="SET NAMES utf8"

#default-character-set=utf8 => MySQL 5.0이면 이 부분 추가

character-set-server=utf8

collation-server=utf8_general_ci

[mysqldump]

default-character-set=utf8

[mysql]

default-character-set=utf8

-----------------------------------------------------

- MySQL 시작

/usr/local/etc/rc.d/mysql-server start

- MySQL 루트 패스워드 지정

mysql> set password for 'root'@'localhost' = password('비밀번호');

mysql> grant all on *.* to root@localhost identified by '비밀번호';

mysql> UPDATE mysql.user SET Password = PASSWORD('비밀번호') WHERE User = 'root';

mysql> flush privileges;

- MySQL 루트 패스워드 지정 방법 2

/usr/local/bin/mysqladmin -u root password 비밀번호

- 외부 접속 가능

mysql> grant all privileges on *.* to root@"%" identified by '비밀번호' with grant option;

- 외부 접속 가능 방법 2

mysql -h localhost -u root -p

mysql> grant all privileges on *.* to 'root'@'%' identified by '비밀번호';

mysql> grant reload,process on *.* to root@localhost;

FLUSH PRIVILEGES;