Database
Click on question to view answer.
How can I manage my databases- phpMyAdmin is one of the best online MySQL database tools, this is pre-installed in your control panel.
- What are my databases called?
- When you create a new database in your control panel MySQL section you may give them names of your choice.
Your account username will be prefixed to your chosen database name along with an underscore.
Databases will therefore follow the naming pattern below:
username_ChosenDatabaseName - What are my database users called?
- In order to use a MySQL database you must first create a MySQL user and assign this user to your database(s).
Upon creating new users you can choose the username and password but your account username will be prefixed to your chosen database username.
The password will remain as you choose.
Database users will therefore follow the naming pattern below:
username_ChosenDatabaseUsername. - Can you restore a database?
- If you need mySQL databases restored please follow the instructions below before opening a support ticket. However, like all backups, we highly suggest you have a backup yourself!
By following the instructions below, we can restore the database much quicker!
1) Delete the database but DO NOT delete the user that has access to the database. Please delete the database, don't just empty the contents of it.
2) Open a support ticket and include the following:
- Account Username
- Restore from daily, weekly, or monthly backup?
- MySQL database name that needs restored
- MySQL database username
- MySQL database password - How do I connect remotely to my database?
- To access a database on our server from a remote location (eg when using a database management application on your home computer) you need to do two things:
1. Connect properly
Setup the software to connect to our full server hostname (see welcome email for your server hostname) or your domain name using the port 3306.
2. Allow permission
Before a connection can be established you must allow access to the database from the IP address / hostname which your home computer (or the computer accessing the database remotely) uses. To find this out please click here. When you have found this, add it to the access list in the MySQL section of the account cPanel on our server.