Page History
...
No Format |
---|
/etc/my.cnf
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
auto-increment-increment = 100
auto-increment-offset = 1
# dir set
chown -R mysql:mysql /data/mysql |
계정 생성명령
No Format |
---|
create user 'user명'@'%' identified by '패스워드'; create user 'user명'@'localhost' identified by '패스워드'; flush privileges; create database DB명; grant all privileges on DB명.* to 'user명'@'%'; grant all privileges on DB명.* to 'user명'@'localhost'; |
...