| Oracle/MySQL 관련 게시판 |
|---|
| 2002/08/05(17:13) from 210.117.182.162 | |
| 작성자 : 강줄기 (jkkang65@hanmail.net) | 조회수 : 3024 , 줄수 : 133 |
| Re: [MySQL] db, user 생성 example |
|---|
|
# mysql -u root -p mysql Enter password: mysql> create database mydb; Query OK, 1 row affected (0.01 sec) mysql> show databases; +----------+ | Database | +----------+ | mydb | | mysql | | test | +----------+ 3 rows in set (0.00 sec) mysql> show tables from mysql; +-----------------+ | Tables_in_mysql | +-----------------+ | columns_priv | | db | | func | | host | | tables_priv | | user | +-----------------+ 6 rows in set (0.00 sec) mysql> grant all privileges on mydb.* to jkkang@"%" identified by 'jkkang' with grant option; Query OK, 0 rows affected (0.01 sec) mysql> select * from db; +------+---------+--------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-- ---------------+------------+------------+ | Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | R eferences_priv | Index_priv | Alter_priv | +------+---------+--------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-- ---------------+------------+------------+ | % | test | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | % | test\_% | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | % | mydb | jkkang | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +------+---------+--------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-- ---------------+------------+------------+ 3 rows in set (0.00 sec) mysql> select * from user; +-----------+--------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+- ------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-----------+--------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+- ------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ | localhost | root | 30f30a1207b0de9f | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | su405 | root | 30f30a1207b0de9f | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | % | jkkang | 669cfd00185a2d17 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | +-----------+--------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+- ------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ 3 rows in set (0.00 sec) mysql> mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> create table person ( id int not null auto_increment, name varchar(15), email varchar(20), phone varchar(15), primary key (id)); Query OK, 0 rows affected (0.02 sec) mysql> show tables; +----------------+ | Tables_in_mydb | +----------------+ | person | +----------------+ 1 row in set (0.00 sec) mysql> show columns from person; +-------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name | varchar(15) | YES | | NULL | | | email | varchar(20) | YES | | NULL | | | phone | varchar(15) | YES | | NULL | | +-------+-------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec) mysql> insert into person values -> (NULL,'강줄기','jkkang65@hanmail.net','011-898-5371'); Query OK, 1 row affected (0.01 sec) mysql> select * from person; +----+--------+----------------------+--------------+ | id | name | email | phone | +----+--------+----------------------+--------------+ | 1 | 강줄기 | jkkang65@hanmail.net | 011-898-5371 | +----+--------+----------------------+--------------+ 1 row in set (0.00 sec) |
|
|