stone@backrush.com
http://backrush.com

(34)[stone]/ > mysql -u root -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2061 to server version: 3.23.47

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

>>> root 로 mysql database로 접근

mysql>
mysql>
mysql> show databases;
+----------+
| Database |
+----------+
| backrush |
| jakim |
| mageoli |
| mysql |
| test |
+----------+
5 rows in set (0.01 sec)

>> 존재 database 확인

mysql> create database DBDB;
Query OK, 1 row affected (0.05 sec)

>>사용자 database 생성


mysql> insert into user values ('localhost','user',password('user123'),'N','N','N','N','N','N','N','N','N','N','N','N','N','N');
Query OK, 1 row affected (0.03 sec)

>> user 테이블에 사용자 생성

mysql> insert into db values('localhost','DBDB','user','Y','Y','Y','Y','Y','Y
','Y','Y','Y','Y');
Query OK, 1 row affected (0.00 sec)

>> db 테이블에 유져권한 적용

mysql>
mysql> flush privileges;
Query OK, 0 rows affected (0.08 sec)

>> 현재 작업 리프레쉬

mysql>
mysql>