Cloud Hosting/MySQL Databases

From XMission Wiki
Jump to: navigation, search

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"

MySQL1.png

  • You will then be required to enter:
  1. Username - To log in with
  2. A Database name - to differentiate it with others
  3. A Password at least 12 characters in length

MySQL2.png

  • Once you have completed the creation, you should see it in your databases. Here you can change the password, and remove the database.

MySQL3.png

PhpMyAdmin

  • 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.

Phpmyadminproceed.png

  • Next you will be prompted for the login information you previously created with your new database.

Phplogin.png

  • Here, you can manage your database tables, and passwords.

Guides

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:

root@yourserver:~# mysql

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';

Archives.png


Cloud Hosting Control Panel - https://xmission.com/account/


Additional Tasks and Information