MySQL is a type of database. There are many databases on the internet. MySQL is widely used and free database. Whenever you go, most of hosting providers offer MySQL database as their standard package. DreamHost also offers unlimited MySQL database. You can create unlimited MySQL usernames and hostnames on DreamHost.
Since MySQL is widely used and widely accepted database, most of the open source applications use MySQL. Most of open source applications run on LAMP (Linux Apache MySQL PHP) setup. It is now necessary that you have knowledge of MySQL database. In this article, we will see how to manage MySQL database at DreamHost.
MySQL Database Management
As of writing this, DreamHost offer MySQL version 5.6. You will find that even the older version of MySQL database will still work but I would suggest you to upgrade all the databases to the latest version.
If you want to learn more about the MySQL database then please watch the following video.
To access the MySQL databases, you first need to login to DreamHost panel using your username and password. Then click on Goodies section. You will see new options enabled. There click on MySQL databases link.
From here, you can manage MySQL hostnames, databases names and access privileges.
Creating MySQL Hostname
Before you start using MySQL database, you will need to connect to the MySQL server using hostname. That is why you need to create the hostname first in the MySQL server. Once the hostname is create, you can connect to MySQL server using that hostname.
Here you can see already created hostnames. If you have installed any open source application using one-click install then you will find the list of hostnames created. To create a new hostname, click on “Add New Hostname” button. Here enter the hostname and select the domain which is going to use the MySQL database.
I would suggest that you use same hostname as domain name for creating mysql database. Let’s say, you are going to use the MySQL database on example.com domain. So give the hostname you like and from domain selection, select example.com. If you give hostname as mysql1982 then your complete hostname for MySQL server will be mysql1982.example.com.
Creating MySQL Database
Once the hostname is created, the next thing is to create the MySQL database. To create MySQL database, first go to MySQL page. Then scroll down to the bottom of the page. Here you will see a form to create MySQL database. Just fill up the form and you are good to go.
First given the database name. Then select the hostname under which you want to create the database. If you want then you also have an option to create a new hostname here. Then select the username and password. This user will get the full access of the database. You also have an option to create the new user. Give the comment in the comment field. You need to provide some description about database. So that in future if you have multiple databases then you don’t get confused.
Then click on “Add new database now!” button. Your database will be created.
Manage Database User
The database, username and hostname are successfully created. Now it might happens that in future you may need to change the user permission for the database. To do that, first go to MySQL database page. Here you can see already created databases.
To change the user permissions, click on the username for which you want change the access. You will be taken to the user permission page.
Here you can set the permission for the user. You can modify select, insert, update, delete, create, drop, index and alter permissions. You can also restrict the user from where she/he can connect to the database. You can also change the password of the user from this page.
phpMyAdmin is a web portal which is used to manage the content of the MySQL database. If you want to insert any record, remove any record or change any record in the table of database then you can do so using phpMyAdmin. You can also run the custom query in the phpMyAdmin.
There is a whole lot of information on how to use phpMyAdmin. That requires a separate new article. You can access phpMyAdmin from the DreamHost MySQL page.
I hope you learn something new about MySQL databases.