I have installed the latest XAMPP with MySQL version 14.14 Distrib 5.6.21, the problem is in my computer, I already have a MySQL database installed by other program that I am using.
So I configure the XAMPP MySQL port to 3307 (default is 3306) inside the my.ini file. However, now my localhost/phpmyadmin seems to read the database installed by the other program, not the one in XAMPP, and also when I test using some PHP files, it shows that I am connected to the database even though XAMPP is turned off (XAMPP MySQL also disconnected ).
How do I change the setting of my phpmyadmin and localhost to connect to the mysql port 3307 ?
I am a newbie in these matters and don't really understand how all these port and database works very clearly. Any comments are welcomed. Hope that anyone could educate me a little on these matters. Thx in advance
解决方案
Goto xampp>phpMyAdmin Directory.
Find the config.inc.php file.
Now change this line:
$cfg['Servers'][$i]['host'] = '127.0.0.1';
To
$cfg['Servers'][$i]['host'] = '127.0.0.1:3307';