Knowledgebase: Hosting
MySQL Database Admin
Posted by Clarke M on 03 April 2006 08:00 PM
There are a number of ways to work with your MySQL database. Here are some of the options.

From your website admin:
Website OS - Website Management - Database manager. http://hosting.smarthost.org/OS4/
This is documented in the Blue Book there in the top-right corner.

From your site:
PhpMyAdmin. http://www.phpmyadmin.net/home_page/
Customise the config.inc.php file:
$cfgPmaAbsoluteUri = 'http://www.yourdomain.com/yourpath/';
$cfgServers[$i]['host'] = 'megasqlservers.com'; // MySQL hostname
$cfgServers[$i]['auth_type'] = 'config';
$cfgServers[$i]['user'] = 'dbm.yourdomain.com; // MySQL user
$cfgServers[$i]['password'] = '******'; // MySQL password
You must specify the name of your database as the hosting server will not allow you to list all the databases.
$cfgServers[$i]['only_db'] = 'dbname_domain_com';
If you have more than one database the above variable will also take an array of database names. See example below:
$db_list=array ("dbname_domain_com","'anotherdb_domain_com'" ) ;
$cfgServers[$i]['only_db'] = $db_list; // If set to a db-name, only
* NOTE * Latest version of phpmyadmin will not work unless underscore '_' characters in db names are escaped.
for example:
OLD: dbm_mydev_net
New: dbm\_mydev\_net

Upload the PhpMyAdmin files to a folder on your site. Ensure that the folder name matches what you entered in the config file above. It is advisable to password protect this folder.

From your PC:
MySQL Control Center. (also known as MySQLCC) is a platform-independent GUI administration client for the MySQL database server. http://www.mysql.com/products/mysqlcc/index.html

This software can search for database servers on your network but to access a server on our hosting computer you should set it up manually.

To setup your database click on file - New

You must specify the name/s of your database/s . The hosting server will not let you browse.

You can right-click a database to edit its properties.
(504 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Help Desk Software by Kayako Fusion