如何将mysql的默认端口从3306更改为3360

2021-11-20 00:00:00 port sql database mysql

我想修改 MySQL 服务器的默认端口号，目前是 3306，我想修改为 3360.

I want to change the default port number of MySQL server presently it is 3306. I want to change it to 3360.

我试过了:

-- port=3360

但是事情对我不起作用.请提供查询以更改端口而不是任何配置.我正在使用 Windows 8 64 位.

But things are not working for me. Please provide query to change port not any configuration. I am using Windows 8 64 bit.

推荐答案

您需要编辑您的 my.cnf 文件并确保您的端口设置如下:

You need to edit your my.cnf file and make sure you have the port set as in the following line:

port = 3360

然后重新启动您的 MySQL 服务，您应该就可以开始了.由于 port 不是动态变量(qv 此处查看 MySQL 文档，其中显示了所有系统变量的表格.

Then restart your MySQL service and you should be good to go. There is no query you can run to make this change because the port is not a dynamic variable (q.v. here for MySQL documentation showing a table of all system variables).

相关文章