如何修改mysql默认端口号3306？

admin

1）把MySQL服务先停止；

2）修改my.ini如下内容：
CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
port=3306
...................
...................

# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306

把默认的3306端口最好修改为6位以上的端口。不容易被黑客攻击。

3）然后，重启MySQL服务。
这时MySQL的端口已经更改了。

4）在phpMyAdmin的config.inc.php文件中，修改：
$cfg['Servers'][$i]['port'] = '3306';

沧海一司

好文！