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