Shulou(Shulou.com)06/01 Report--

How to change the default port number of mysql? In view of this problem, this article gives the corresponding analysis and answers, hoping to help more friends who want to solve this problem to find a more simple and feasible way.

MySQL is a relational database management system in which relational databases store data in different tables instead of all data in one large warehouse, which increases speed and flexibility. The default port number for mysql is 3306.

Modify method:

It's usually in the installation directory, so if it's no longer available, look under c:\ windows, c:\ windows\ system32 or use windows's search function to find my.ini.

Modify the following two areas: [client]

Port=3306

[mysqld]

# The TCP/IP Port the MySQL Server will listen onport=3306

Note: the service will not work until it is modified.

Default port number for other databases:

1. The default port of mysql is 3306, which can be modified by editing the .my.cnf file in the user directory.

2. The default port number of SQL server is 1433.

3. The default port number of Oracle is 1521.

4. The default port number of DB2 is 50000

5. The default port number of PostgreSQL is 5432.

This is the end of the method of changing the default port number of mysql. I hope the above content can be helpful to you and you can learn more. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.