いりさ＠あべのです

遠藤さんありがとうございます。

On Fri, 26 Oct 2001 21:58:32 +0900
遠藤 俊裕 <endo_t@xxxxxxxxxx> wrote:

> # mysql mysql
> mysql> select * from host;
> mysql> select * from db;
> mysql> select * from user;
> 
> の結果は如何に？

以下のようになっています。（後半はちぎってますが…）

mysql> select * from host;
Empty set (0.00 sec)

mysql>select * from db;
+------+-------+------+-------------+-------------+-------------+----
| Host | Db    | User | Select_priv | Insert_priv | Update_priv | Del
+------+-------+------+-------------+-------------+-------------+----　・・・
| %    | test% |      | Y           | Y           | Y           | Y  
+------+-------+------+-------------+-------------+-------------+----
1 row in set (0.00 sec)

mysql> select * from user;
+-----------+-------+------------------+-------------+-------------+-
| Host      | User  | Password         | Select_priv | Insert_priv | 
+-----------+-------+------------------+-------------+-------------+-
| localhost | root  |                  | Y           | Y           | 
| %         |       |                  | N           | N           | 　・・・
| localhost |       |                  | Y           | Y           | 
| %         | root  |                  | Y           | Y           | 
| localhost | monty | 456b783e111ca233 | Y           | Y           | 
| %         | iris  | 456cb6c71a991c2e | Y           | Y           | 
+-----------+-------+------------------+-------------+-------------+-
6 rows in set (0.00 sec)