What is MySQL? #
What version of MySQL are you running? #
All new databases that are created run on MariaDB 10.0 (MySQL 5.5 Compatible).
If you have databases running an older version of MySQL and you want to upgrade, please submit a help desk ticket
How do you create a MySQL database? #
MySQL databases can be setup using the control panel under “Features”.
The cloud will add a number to the front of your created database name/username (e.g. 402464_dbcloud). Use this “numerical prefix_name” format for the database name/username when logging into phpMyAdmin or in any config file reference.
How do you access phpMyAdmin to manage a MySQL database? #
Database information in the cloud is stored in clusters and the cloud will append a number to the front of your created database name/username (e.g. 402464_dbcloud). Use this “numerical prefix_name” format for the database name/username when logging into phpMyAdmin.
When logging into phpMyAdmin, you’ll also need to select the correct MySQL cluster from the drop-down list. Here’s how to locate the correct MySQL cluster:
- Log into your control panel
- Click on the domain
- Click on the Features tab
- Under the Databases section, click on the database name
- Next to Hostname, note the first string of characters in the stabletransit.com address. For example, mysql50-11.wc1.dfw1.stabletransit.com. This first part is the MySQL cluster that you would choose from in the drop-down list when logging into phpMyAdmin
Check out the phpMyAdmin documentation for more info.
phpMyAdmin can be used to import .sql files up to 20MB in size. If you are trying to import an .sql file that is larger than 20MB, contact us through the Help Desk about how to import larger data files into the database.
How do I migrate a database into the Cloud using phpMyAdmin? #
What hostname should be used to call out a MySQL database from a script? #
The hostname for connecting to a database can be found by logging into the control panel. Also be sure to check that you are using the correct “database name”, “username” and “password”.
How much are additional MySQL databases and how do you add one? #
Additional MySQL databases are $1.00 each per month. If you need to add another MySQL database to one of your domains, please enter a support ticket through our Help Desk.
NOTE: The maximum amount of MySQL databases allowed per domain is 5.