⑴ 如何可確認sql Server 1433埠是否開啟
用cmd,進入命令行模式
telnet: 127.0.0.1 1433
或者 netstat -ant
檢測當前偵聽的埠。
或者，進sql的管理界面，查網路埠配置，tcp哪裡設置埠，此外namepipe必須enable
或者，進控制面板找到管理工具，進去，用odbc，連一下sql的1433口，
或者，用埠掃描工具掃描本機所有埠……
⑵ mysql怎麼查看埠號,和服務名
如果在cmd命令窗口中使用netstat查看各個程序佔用埠
如果進入mysql 使用show variables like 'port';
使用？或help查看幫助
mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
1 row in set (0.00 sec)
mysql> ?
For information about MySQL procts and services, visit:
http://www.mysql.com/
For developer information, including the MySQL Reference Manual, visit:
http://dev.mysql.com/
To buy MySQL Enterprise support, training, or other procts, visit:
https://shop.mysql.com/
List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (\?) Synonym for `help'.
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
ego (\G) Send command to mysql server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
help (\h) Display this help.
notee (\t) Don't write into outfile.
print (\p) Print current command.
prompt (\R) Change your mysql prompt.
quit (\q) Quit mysql.
rehash (\#) Rebuild completion hash.
source (\.) Execute an SQL script file. Takes a file name as an argument.
status (\s) Get status information from the server.
tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
use (\u) Use another database. Takes database name as argument.
charset (\C) Switch to another charset. Might be needed for processing binlog
with multi-byte charsets.
warnings (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.
For server side help, type 'help contents'
mysql>
⑶ 如何查看 sql server 2005 埠號
默認的埠號是1433.
打開sql2005的SQL
Server
Configuration
Manager
-->展開網路配置
-->點擊MYSQLSERVER協議
-->雙擊TCP/IP
-->選擇IP地址就能看到埠號了。
⑷ 如何查看自己資料庫的埠號
可以通過tnsnames.ora文件讀取資料庫的信息。
可以看到類似如下的內容：abc =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.219.5)(PORT = 1521)))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)))
HOST= 就是主機地址（如果是寫的主機名，可以查看/etc/hosts文件中查看主機名對應的IP地址）
POST= 就是資料庫開放的埠