如何将mysql的默认端口从3306更改为3360 [英] How to change the default port of mysql from 3306 to 3360

问题描述

我想将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

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).

这篇关于如何将mysql的默认端口从3306更改为3360的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！