Configure phpMyAdmin to work with existing MySQL installation
I’ve recently begun working on a website that will require a mixture of technologies:
- PHP
- Flash
- Flash Media Server
In order to get started, I needed to set up a local environment that mirrors my client’s production server. Instead of trying to manually download, install, and configure all the various technologies needed to get PHP running on my laptop, I opted to try out some ‘packaged’ solutions. Here are the two options I explored:
I originally tried WAMP, but after a few days the Apache server wouldn’t start. I don’t know if I did something to break it. Unfortunately, I ended up having to uninstall it. I tried re-installing but still had no luck. Thus, I decided to try out XAMPP. I’m pleased to announce that XAMPP has been great!
NOTE: Because I already had MYSQL installed on my machine I had to edit the ‘config.inc.php’ file to make sure phpMyAdmin would be able to connect to MySQL. The file you need to edit is located here:
<XAMPPInstallationDirectory>\phpmyadmin\config.inc.php
Once you open this file find the following settings: (should be lines 20 & 21)
$cfg['Servers'][$i]['user'] = ‘root’;
$cfg['Servers'][$i]['password'] = ‘password’;
You can replace the values ‘root’ and ‘password’ to reflect the existing username and password you want to use to connect to MySQL.