<p>【MySQL】测试Windows版本的MySQL服务器是否工作</p>
<p><br />
1.查看MySQL数据库中包含那些数据库<br />
C:>C:"Program Files"MySQL"MySQL Server 5.0"binmysqlshow<br />
+--------------------+<br />
| Databases |<br />
+--------------------+<br />
| information_schema |<br />
| mysql |<br />
| test |<br />
+--------------------+</p>
<p>2.查看mysql数据库中包含哪些表<br />
C:>C:"Program Files"MySQL"MySQL Server 5.0"binmysqlshow -u root -pmysql mysql<br />
Database: mysql<br />
+---------------------------+<br />
| Tables |<br />
+---------------------------+<br />
| columns_priv |<br />
| db |<br />
| func |<br />
| help_category |<br />
| help_keyword |<br />
| help_relation |<br />
| help_topic |<br />
| host |<br />
| proc |<br />
| procs_priv |<br />
| tables_priv |<br />
| time_zone |<br />
| time_zone_leap_second |<br />
| time_zone_name |<br />
| time_zone_transition |<br />
| time_zone_transition_type |<br />
| user |<br />
+---------------------------+</p>
<p>3.查看MySQL版本信息<br />
C:>C:"Program Files"MySQL"MySQL Server 5.0"binmysqladmin version status proc<br />
C:Program FilesMySQLMySQL Server 5.0binmysqladmin Ver 8.41 Distrib 5.0.77, for Win32 on ia32<br />
Copyright (C) 2000-2006 MySQL AB<br />
This software comes with ABSOLUTELY NO WARRANTY. This is free software,<br />
and you are welcome to modify and redistribute it under the GPL license</p>
<p>Server version 5.0.77-community-nt<br />
Protocol version 10<br />
Connection localhost via TCP/IP<br />
TCP port 3306<br />
Uptime: 9 min 54 sec</p>
<p>Threads: 1 Questions: 16 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.027<br />
Uptime: 594 Threads: 1 Questions: 16 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.027<br />
+----+------+----------------+----+---------+------+-------+------------------+<br />
| Id | User | Host | db | Command | Time | State | Info |<br />
+----+------+----------------+----+---------+------+-------+------------------+<br />
| 10 | ODBC | localhost:2442 | | Query | 0 | | show processlist |<br />
+----+------+----------------+----+---------+------+-------+------------------+</p>
<p>4.使用“mysql test”测试数据库是否可以访问<br />
C:>C:"Program Files"MySQL"MySQL Server 5.0"binmysql test<br />
Welcome to the MySQL monitor. Commands end with ; or g.<br />
Your MySQL connection id is 11<br />
Server version: 5.0.77-community-nt MySQL Community Edition (GPL)</p>
<p>Type 'help;' or 'h' for help. Type 'c' to clear the buffer.</p>
<p>mysql></p>
<p>-- The End --<br />
</p>