Error changing the mysql port on xampp

0

Because I need to use MySQL Workbench for college, I left port 3306 pro server for Workbench and switched to XAMPP for 3307 as the guy Suman Kotagiri said in this forum link

When I started the MySQL module in XAMPP I thought I might make a mistake, but no, it turned green and said its status was 'running'. But when I click admin, this window appears in phpmyadmin:

There are not many questions exactly about it so it's a little vague about what might be happening. Is it possible to be experiencing some workbench conflict with XAMPP anyway? I turned off the server through MySQL Notifier because I thought it would be a problem to have two servers connected at the same time but it did not help me 100% to get it right.

    
asked by anonymous 19.06.2018 / 00:07

1 answer

0

You have change the PHPMyAdmin connection setting .

To do this, go to the folder where PHPMyAdmin is located and find the file config.inc.php , then you will have a $cfg['Servers'][$i]['port'] configuration that you will have to change to point to the new port, 3307 .

It should be able to connect to the other service you have running on 3306 , but this would be if the access data were the same, which may not be the case here.

You can also have more than one configured server (such as Workbench) in this configuration file, so you can even create more connection settings to use the same tool and manage both database services.

Just out of curiosity, is there any specific reason to have 2 services? You are not required to use the Workbench.

    
19.06.2018 / 00:45