【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 mysql
Database: 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 proc
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqladmin Ver 8.41 Distrib 5.0.77, for Win32 on ia32
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.77-community-nt
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 9 min 54 sec
Threads: 1 Questions: 16 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.027
Uptime: 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 test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server 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 --
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 mysql
Database: 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 proc
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqladmin Ver 8.41 Distrib 5.0.77, for Win32 on ia32
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.77-community-nt
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 9 min 54 sec
Threads: 1 Questions: 16 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.027
Uptime: 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 test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server 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 --
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/519536/viewspace-584672/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysql xtrabackup在windows平臺的備份測試MySqlWindows
- 【實驗】【MySQL】MySQL 5.0 windows版本之初探MySqlWindows
- mysql壓力測試在青雲PCIE盤sysbench版本MySql
- 【Windows 64位】MySQL 8.0.21安裝教程+Navicat+MySQL連線測試WindowsMySql
- sysbench 測試MySQLMySql
- mysql測試shellMySql
- MySQL 加密的效能測試MySql加密
- mysql~關於mysql分割槽表的測試MySql
- 【Tpcc-mysql】Tpcc-mysql測試MySql
- MYSQL 寫效能測試MySql
- sysbench測試mysql oltpMySql
- MySQL基準測試MySql
- MySQL索引效能測試MySql索引
- 測試MySQL鎖的問題MySql
- 使用 sysbench 測試 MySQL 的效能MySql
- MYSQL程式碼顯示測試測試MySql
- mysql叢集壓力測試在京東雲盤:sysbench版本MySql
- mysql壓力測試在京東雲ssd雲盤sysbench版本MySql
- mysql效能測試工具之tpcc-mysql薦MySql
- mysql簡單效能測試MySql
- MYSQL壓縮表測試MySql
- MySQL行級鎖測試MySql
- 使用sysbench測試Mysql效能MySql
- MySQL 效能測試工具mysqlslapMySql
- [Mysql]效能測試指令碼MySql指令碼
- 測試 mysql 的最大連線數MySql
- 使用 sysbench 測試 MySQL 的效能(二)MySql
- mysql密碼忘記如何恢復(windows/liunx版本:mysql-8.0.27)MySql密碼Windows
- MYSQL 效能測試方法 - 基準測試(benchmarking)MySql
- MySQL製作具有千萬條測試資料的測試庫MySql
- MySQL是如何做容器測試的?MySql
- MySQL Profile在5.7的簡單測試MySql
- MySQL字元函式的壓力測試MySql字元函式
- 1. mysql的安裝與測試MySql
- mysql 8.0.17 分割槽特性測試MySql
- MySQL學習 - 基準測試MySql
- MySQL federated儲存引擎測試MySql儲存引擎
- 【MySQL】Tokudb安裝測試初探MySql