MySQL 状態を確認してみる

ステータスの確認
****************************************************
mysql> status
−−−−−−--
mysql Ver 14.14 Distrib 5.1.38, for Win32 (ia32)

Connection id: 1
SSL: Not in use
Using delimiter: ;
Server version: 5.1.38-community MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Client characterset: sjis
Server characterset: sjis
TCP port: 3306
Uptime: 16 min 47 sec

Threads: 1 Questions: 6 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.5
−−−−−−--
****************************************************

既存のdbを確認してみる
****************************************************
mysql> show databases;
+−−−−−−−−−−+
| Database |
+−−−−−−−−−−+
| information_schema |
| dkuma |
| mysql |
| test |
+−−−−−−−−−−+
4 rows in set (0.20 sec)

※注意デフォルトだとdatabaseが２つ登録されています。
****************************************************

mysqlというdatabaseの中身を見てみる
****************************************************
mysql> use mysql;　　　　　　　　　　　⇒mysqlというdatabaseを使いますよということ
Database changed　　　　　　　　　　　⇒成功ならこの表示
mysql> show tables;　　　　　　　　　⇒テーブル名一覧を表示
+−−−−−−−−−−−−---+　　　　　　⇒ここからテーブル一覧
| Tables_in_mysql |
+−−−−−−−−−−−−---+
| columns_priv |
| db |
| event |
| func |
| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| ndb_binlog_index |
| plugin |
| proc |
| procs_priv |
| servers |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+−−−−−−−−−−−−---+
23 rows in set (0.28 sec)
****************************************************

userというテーブルの構造を見てみる
****************************************************
mysql> show columns from user;
+−−−−−−−−−−---+−−−−−−−−−−−−−−−−---+−−--+−−-+−−−−-+−−---+
| Field | Type | Null | Key | Default | Extra |
+−−−−−−−−−−---+−−−−−−−−−−−−−−−−---+−−--+−−-+−−−−-+−−---+
| Host | char(60) | NO | PRI | | |
| User | char(16) | NO | PRI | | |
| Password | char(41) | NO | | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
| Update_priv | enum('N','Y') | NO | | N | |
| Delete_priv | enum('N','Y') | NO | | N | |
| Create_priv | enum('N','Y') | NO | | N | |
| Drop_priv | enum('N','Y') | NO | | N | |
| Reload_priv | enum('N','Y') | NO | | N | |
| Shutdown_priv | enum('N','Y') | NO | | N | |
| Process_priv | enum('N','Y') | NO | | N | |
| File_priv | enum('N','Y') | NO | | N | |
| Grant_priv | enum('N','Y') | NO | | N | |
| References_priv | enum('N','Y') | NO | | N | |
| Index_priv | enum('N','Y') | NO | | N | |
| Alter_priv | enum('N','Y') | NO | | N | |
| Show_db_priv | enum('N','Y') | NO | | N | |
| Super_priv | enum('N','Y') | NO | | N | |
| Create_tmp_table_priv | enum('N','Y') | NO | | N | |
| Lock_tables_priv | enum('N','Y') | NO | | N | |
| Execute_priv | enum('N','Y') | NO | | N | |
| Repl_slave_priv | enum('N','Y') | NO | | N | |
| Repl_client_priv | enum('N','Y') | NO | | N | |
| Create_view_priv | enum('N','Y') | NO | | N | |
| Show_view_priv | enum('N','Y') | NO | | N | |
| Create_routine_priv | enum('N','Y') | NO | | N | |
| Alter_routine_priv | enum('N','Y') | NO | | N | |
| Create_user_priv | enum('N','Y') | NO | | N | |
| Event_priv | enum('N','Y') | NO | | N | |
| Trigger_priv | enum('N','Y') | NO | | N | |
| ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |
| ssl_cipher | blob | NO | | NULL | |
| x509_issuer | blob | NO | | NULL | |
| x509_subject | blob | NO | | NULL | |
| max_questions | int(11) unsigned | NO | | 0 | |
| max_updates | int(11) unsigned | NO | | 0 | |
| max_connections | int(11) unsigned | NO | | 0 | |
| max_user_connections | int(11) unsigned | NO | | 0 | |
+−−−−−−−−−−---+−−−−−−−−−−−−−−−−---+−−--+−−-+−−−−-+−−---+
39 rows in set (0.58 sec)
****************************************************

userテーブルの中身を見てみる
****************************************************
mysql> select * from user;
※注意長いので内容は割愛します
****************************************************