Cloud Hosting/MySQL Databases
What is MySQL?
MySQL (Officially pronounced "My-S-Q-L") is an open-sourced database management system. The name is an abbreviation for "Structured Query Language" and is now owned by Oracle. MySQL is a central component in LAMP stack servers (Linux, Apache, MySQL, PHP). Most CMS' like Wordpress and Joomla require the use of MySQL to manage the required databases.
Creating and Adding MySQL servers
- To create your first MySQL database, or even a new one, navigate to the Websites tab in your VPS manager. Find the website you wish to add your database to, and click the button under "MySQL Databases"
- You will then be required to enter:
- Username - To log in with
- A Database name - to differentiate it with others
- A Password at least 12 characters in length
- Once you have completed the creation, you should see it in your databases. Here you can change the password, and remove the database.
- To interact with the databases you have created, you will be using Php my admin. In your VPS Manager click on '"PhpMyAdmin" From here, it will redirect you to an https:// site that will prompt you that it is not secure. This is a self-assigned security certificate to ensure that your database passwords are not sent in plaintext. You will need to continue forward by clicking Advanced > Proceed (On Google Chrome)
- If you have an SSL certificate already installed on your website, you should not have this issue.
- Next you will be prompted for the login information you previously created with your new database.
- Here, you can manage your database tables, and passwords.
We recommend that you read over the official PhpMyAdmin documentation and consult it if you require in depth assistance
Password Resets for MySQL
You can change the mysql root password by logging in to the database directly from your Cloud Hosting server my using the command:
Next you will be dumped into the mysql command line. You can run the command "PASSWORD" to initiate a password reset
mysql> SET PASSWORD FOR root@localhost = PASSWORD('yourpassword');
Make sure to set the new password into phpmyadmin's config.inc.php too, at line
$cfg['Servers'][$i]['password'] = 'yourpassword';
Cloud Hosting Control Panel - https://xmission.com/account/
- Your Servers - VPS Manager
- Configure Resources - Your Server Resources
- Manage - Your Cloud Hosting Panel
- Wordpress Installation - How to install Wordpress to your website
- Domain Redirects - How to direct website traffic to another domain
- Nginx Proxy
- PHP Settings - How to add customer PHP settings
- PHPMyAdmin - How to access your Databases
- DNS - Add or Remove DNS
Additional Tasks and Information
- How Secure Web (SSL) Works
- Domain Transfer and Redemption
- Password Protecting a Directory With ".htaccess"
- Uploading Website content
- Two-Factor Authentication
- Logs and Troubleshooting Tips
- Command Line Login
- Creating Scheduled Jobs with Crons
- MySQL Import and Export
- Default Cloud Server PHP Info
- Host Files
- SSH Keys
- Unmanaged Server Security