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:
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.
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.