Location : PHP Hosting - Web Hosting Knowledge Base - PHP MySQL Tutorial

Manage MySQL Database

After a MySQL database is created, you will need to setup the database schema by creating tables, field columns within tables, indexes etc., you may have not noticed this since most of the programs has included this process in the installation setup routine, at most you are needed to create the database before executing the installation script and specify the database name, MySQL user name that has been granted access and the password associated with the username.

In any case you need to access the database schema, there are three ways that you can use to manage MySQL database created :-

Shell Access

If you are familiar with Linux shell commands and MySQL shell commands and wish to manage your MySQL database through shell, you can request to enable SSH access for your hosting account by submitting a ticket helpdesk.dotservant.com. If you are not familiar with managing MySQL database through shell, you can choose to use the following popular web based MySQL database management tool


phpMyAdmin is a popular web based MySQL database management tool written in PHP that allow you to create database schema, browse, edit and delete records, create key indexes etc. through a web browser. To use phpMyAdmin, login to you hosting account control panel, select SQL Database option to bring up the database management screen, scroll down to the lower section of the screen and click on the phpMyAdmin link, a new browser windows will be opened with the phpMyAdmin program loaded. To exit phpMyAdmin after finish your work, just close the browser window to return to website hosting account control panel.

Setup Remote Access

MySQL database created are default to only allow local server access, which means any connection request from remote IP address to a local MySQL database will be denied, this is a security precaution to minimize the danger of sensitive data in database being made known to unauthorized people. If you have application deploy at a remote server that needed to access data in this local MySQL database, you can grant access for this remote IP address or hostname to the database. In the database management screen, scroll down to the bottom of the screen and enter the remote IP address or hostname in the Access Hosts section, note that wildcard '%' is allowed but it is advisable to use it with caution.

If you have a database management tool installed at a remote server, and wish to use that tool to manage your databases created in this local server, you can setup remote access to allow the remote server to connect to the local MySQL server, identify the remote server IP address and enter it in the Access Hosts list.