Remote MYSQL Adminstration Using PHPMyadmin
To administrate the MYSQL server from a remote location we can use the PHPMyadmin installed On a XAMPP or WAMP Server.
On The Xampp or wamp Installation Directory\phpmyadmin\config.inc.php
set the following changes in config file .
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Servers'][$i]['host'] = 'mytestmysqlserver'; // Mysql Server Name
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
After changing these settings restart the server and access the Phpmyadmin using the default url .
for example mywebserver/phpmyadmin .
It will ask a user name and password .give the username and password you set during the installation of MYSQL server.
After entering valid login details you will get the tables listed from the mysql server..
