wamp修改mysql端口号,在WAMP中更改MySQL端口号后，PHPMyAdmin页面错误

I have IIS installed with an existing MySQL version on my server computer. Now I want to install WAMP to host magento sites.

After I installed WAMP and changed the apache port from 80 to 8090, all the magento sites siting on wamp server works fine. But all my IIS php sites cannot connect to the old MySQL database.

So I was requested to change the port of the new MySQL in WAMP.

I changed the my.ini file with the new port number 3307, then I restarted wamp service. The server icon is green, but when I visit the phpMyAdmin page, I got an error message saying "#1045 - Access denied for user 'root'@'localhost' (using password: NO)".

I searched on goolge and changed the config.inc.php file with port = 3307, restarted service again. But I still got the same error.

Is there anything else needs to be changed to get it working on the phpMyAdmin page? Thanks in advance.

解决方案

A couple of things you can try.

Have you refreshed your Browser Cache ( CTRL + F5 )

Did you change the correct section of my.ini

Locate this section of my.ini and chnage the port number there

# The MySQL server

[wampmysqld]

port = 3307

Also locate this section

# The following options will be passed to all MySQL clients

[client]

port = 3307

and change the port there as well.

Restart MySQL and now phpMyAdmin should have a server to talk to. Also if you use the command line access to mysql it will also be looking at the correct server.