mysql5.0 测试_【MySQL】测试Windows版本的MySQL服务器是否工作

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

-- The End --