What is the MySQL Database Manager?

Answer by: Stuart Pierce, Aplus.Net Knowledge Base Support

The MySQL Database Manager icon in the Control Panel connects you to the phpMyAdmin tool. PhpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. It can create and drop databases, create / drop / edit tables, delete / edit / add fields, execute any SQL statement, manage keys on fields, manage privileges, and export data into various formats.

The phpMyAdmin database administration tool is available for the Unix Based plans only (Personal Unix, Business Class Unix, Pro Unix, eCommerce Unix). It is located on your shared hosting server. The URL should be http://hosting-server/phpmyadmin. You will have to login into the phpmyadmin tool using your MySQL database username and database password in order to manage your MySQL database.

Note: Replace hosting-server with the IP address or the hostname of the server which hosts your web space.

Important: You have to use the hostname or the IP address of the Aplus.Net server itself. You cannot access the phpMyAdmin database administration tool by using your own domain name as phpMyAdmin is not installed in your personal web space.

If you do not know the hostname or the IP address of your shared hosting server, please contact our Customer Support team by phone at 1 888 301 2516 (toll free) or 1 858 410 6900 for international callers. You can contact Customer Support by email at support@aplus.net, please include your registration number so we can locate your account.

Alternatively, you can access the phpMyAdmin tool through the MySQL Database Manager icon in the Control Panel. Here’s how:

Start by logging into the Aplus.Net Control Panel at http://cp.aplus.net using your Registration Number and Customer Password.
Select Web Hosting from the top navigation bar.
Next, select Hosted Domains and click on Manage Hosted Domains.
Now, select the hosted domain that you’d like to manage.
Click the MySQL Database Manager icon.
Click the manage database link associated with the exact MySQL database you’d like to manage.

You will be redirected to the administering interface of the phpmyadmin database manager. On the left-hand side you will see the name of the database, and the tables you currently have.

Important: The “test” database available in your MySQL Database Management tool is shared between all users on your shared hosting server. This database is not assigned to your personal hosting plan. The data stored in that database is not secured and can be emptied at any time. Please, do not use that database to store your actual data.