勉強用DB領域の作成

MySQLはローカルマシンにインスコ済なので、
勉強用領域を作成する。
その時のメモ。

c:\>mysql -u root -p

Enter password: ******

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 6 to server version: 4.1.9-nt

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

mysql> create database nekodb;

Query OK, 1 row affected (0.07 sec)

mysql> grant usage on *.* to nekokak@localhost identified by '********';

Query OK, 0 rows affected (0.16 sec)

mysql> grant all on nekodb.* to nekokak@localhost;

Query OK, 0 rows affected (0.01 sec)

mysql> quit

以上で勉強用DB領域、勉強用ユーザ設定完了
作成したnekokakユーザでログインしてみてテーブル作成できればOK

 C:\>mysql -u nekokak -p nekodb

 Enter password: ********

 Welcome to the MySQL monitor.  Commands end with ; or \g.

 Your MySQL connection id is 11 to server version: 4.1.9-nt

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

 mysql> create table dummy (name varchar(20));

 Query OK, 0 rows affected (0.20 sec)

 mysql> show tables;

 +------------------+

 | Tables_in_nekodb |

 +------------------+

 | dummy            |

 +------------------+

 1 row in set (0.03 sec)

 mysql> drop table dummy;

 Query OK, 0 rows affected (0.09 sec)

 mysql> show tables;

 Empty set (0.00 sec)

 mysql> quit

以上。