MySQL Admin on XAMPP

Introduction

XAMPP is a very cool package that integrates Apache, MYSQL and PHP all at once without you going into the hassle of the individual installation configuration of PHP, Apache and MYSQL. There are some issues though for those who are used to using the MySQL Admin in administering the MYSQL Database. When you install XAMPP the MySQL Admin gui is not included in the installation. Although most of the time you can use the PhpMyAdmin with your database, there are times where in you need more refined administration of the database through MySqlAdmin. In order for the MySqlAdmin to work with the XAMPP configuration you need to do the following.

Procedures:

1. Download the MySql GUI Tools from http://dev.mysql.com/downloads/gui-tools/5.0.html
   Find the appropriate GUI based on your system. With my installation I have the Windows x86. Save and install the program.
2. To install the MySql GUI Tool you need to install using the custom installation. Then place its directory under the directory of XAMPP mysql installation. In my case the XAMPP mysql is in D:\xampp\mysql. So for the installation of the MySql GUI Tools I had to use: D:\xampp\mysql\MySQL Tools for 5.0
   The purpose of this installation is to help MySqlAdmin to locate the MySql Database without you tampering the configuration file.
3. Start your MySqlAdmin from the All Programs Menu and just enter the information needed to start the MySQL Database. User: root. For the password there should be no password if you haven't changed anything in http://localhost/security/index.php

For more information contact jnoel@cartizgis.com

Url: http://www.cartizgis.com