<p>【MySQL】测试Windows版本的MySQL服务器是否工作</p> <p><br /> 1.查看MySQL数据库中包含那些数据库<br /> C:&gt;C:&quot;Program Files&quot;MySQL&quot;MySQL Server 5.0&quot;binmysqlshow<br /> +--------------------+<br /> | Databases |<br /> +--------------------+<br /> | information_schema |<br /> | mysql |<br /> | test |<br /> +--------------------+</p> <p>2.查看mysql数据库中包含哪些表<br /> C:&gt;C:&quot;Program Files&quot;MySQL&quot;MySQL Server 5.0&quot;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:&gt;C:&quot;Program Files&quot;MySQL&quot;MySQL Server 5.0&quot;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.使用&ldquo;mysql test&rdquo;测试数据库是否可以访问<br /> C:&gt;C:&quot;Program Files&quot;MySQL&quot;MySQL Server 5.0&quot;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 &#39;help;&#39; or &#39;h&#39; for help. Type &#39;c&#39; to clear the buffer.</p> <p>mysql&gt;</p> <p>-- The End --<br /> </p>
返回顶部 留言