Support - Administering MySQL

When using a MySQL database, Adhost by default will setup access to your database from your website using:

IP address of the Adhost web server where your domain resides.
Database name is the name of your domain unless otherwise specified by you.
Username/password: typically this is your ftp username/password unless otherwise specified by you.

There are 2 ways to manage your MySQL databases, depending on the configuration of the server:

Using either MySQL Control Center or MySQL Administrator
A web tool called phpMyAdmin. We recommend you do not install this tool for your web site as Adhost already has this tool installed on several servers using secured connections. Please contact support@adhost.com for the URL.

If you decide to use MySQL Control Center or MySQL Admin, the IP address of your local machine (i.e. your work or home computer) will need to be granted access to the Adhost server where your MySQL database is located. You can click on ‘Allow My IP Address’ to submit your ip address and read more about this security measure.

What you need to know before you submit the ‘Allow My IP Address’ form?

The domain name, database name, username and password.

Why don’t I need to submit the ‘Allow My IP Address’ form to use phpMyAdmin?

When we initially set up your mySQL database, we granted access from your web server to the database. We allowed your domain (which resolves to the IP of your web server) access to that database.

PhpMyAdmin is an application that is installed into a subdirectory that is password protected (in other words, do not allow anonymous access to this app) on your web server. Therefore, access is already granted by default.

Please email support@adhost.com if you have any additional questions.