How to view: Information to be entered in direct connection mode: user name, password, service name (these three points are the same as in client mode). IP, port number.
Network, invasion and deletion) Find the oracle installation directory, locate the %oracle home% db 1 install directory, and use a clipboard or notepad to view the portlistini file. Manual setup is done with the help of NET Manager. You can find it in the menu.
The default listening port of the database, through which applications connect and communicate with Oracle data, and view methods. As follows: 1 First, you need to bring up the DOS interface, enter cmd in the computer search box, and press enter. Of course, you can also use the shortcut window key R key to directly call out the cmd after the run box and press enter.
service emrepoxdb has 1 instance(s).instance emrepo， status ready， has 1 handler(s) for this service...the command completed successfully switched to the oracle user to execute lsnrctl status The bold is which line of the port number.
Oracle's default port number is 1521 Oracle Enterprise Manager is a web site, which needs to be manually configured or used to build a database with DBCA.
1. View the MySQL configuration file and view it in the service. By looking at the mysql configuration file, find the port line in the configuration file, and the port number is the value of this line. View in Service: On Windows, you can view the port number of MySQL in the service list.
2. The default service port of MySQL database is 3306. By default, MySQL uses the TCP IP protocol to listen for client connection requests on port 3306. This port number is the official recommended port number of MySQL and is one of the most commonly used port numbers.
3. Then enter the command line of mysql -u root -p in the DOS interface, and the version number and other content in the accompanying picture appear to indicate that the mysql service has been connected.
4. The default port of MySQL is 3306. When installing MySQL, if no port number is specified, MySQL will use the default port number 3306. This is because by default, MySQL uses port 3306 to communicate with external clients. If you're using the default port number, you don't need to specify the port number in the connection string.
5. Use the nestat command to check the status of port 3306: netstat -an |grep 3306 tcp 0 0 (server local IP address): 3306 00.0.0:* listen From the result, it can be seen that port 3306 is only listening on (the local IP address of the server), so the access of other IP addresses is denied.