There are many databases available. MySQL is a one type of database server. MySQL is widely used and accepted database system. DreamHost offers unlimited MySQL database with their standard hosting plan. You can create unlimited user names and unlimited hostnames in MySQL server on your DreamHost account.
MySQL has become an essential part of any website setup. Today most of the open source application runs on LAMP setup. LAMP stands for “Linux-Apache-MySQL-PHP/Perl/Python”. You must have knowledge of MySQL database if you are hosting a website. In this article, I am going to show you how to manage MySQL database in your DreamHost account.
MySQL Database Management
Currently DreamHost offers MySQL version 5.6. Any new database will be created in MySQL 5.6. DreamHost still supports the older version of MySQL databases but I would suggest you to get all the databases upgraded to the latest version.
Here is a short video on how to manage MySQL database.
If you want to access all the MySQL databases on your DreamHost account then first login to DreamHost panel. Then click on Goodies link in the left side navigation panel. Now click on MySQL Databases link.
From this page, you can manage hostnames and database names. You can also manage user access from this page.
Creating MySQL Hostname
If you want to access the MySQL database then you first need to connect to the host on which MySQL server is running. Before you create any database, you need to create the host name. So you can connect to that database using the hostname. First create the MySQL hostname.
To create MySQL hostname, click on “Add New Hostname” button on MySQL database management page. Here you need to enter the host name. Now you can see a list of all hosted domains. Select the domain for which you want to use MySQL database server.
For example, if you want to create a database for mydomain.tld domain then select the mydomain.tld domain from the domains list. You can give any hostname you like. Generally, people use mysql as host name. So complete hostname becomes like mysql.mydomain.tld. I prefer to append 3-4 digits after the host name so that the MySQL hostname looks like mysql1982.ahappycustomer.dreamhosters.com.
Creating MySQL Database
Now that the hostname is created, you can start creating MySQL database. To create MySQL database, first visit the MySQL management page from the panel. At the bottom of the page, you will find a form to create a database.
To create the database, first give the database name and then select the host name which you just created. You also need to enter the details for username and password. This user will get full access of the database. Finally give the comment for the database. This comment is for reference purpose only. If you don’t want to give the comment then you can ignore this field but I would suggest that you give the sort description about database in the comment.
Finally click on “Add new database now!” button. Your database is created now.
Manage Database User
Now the database has been successfully created. In future, you might need to change the access permission of the user for the database. Go to MySQL management page from the panel. Here you can see a list of already created databases.
Click on the username of your database for which you want to change the permission. You will be taken to the next page.
On this page, you can set the permission for the user for the database. You can modify select, insert, update, delete, create, drop, index and alter permissions. You can also set allowed IP address from where a user can connect to the database. You also have an option to set new password on this page.
If you want to perform any operation on the database itself then you need to use phpMyAdmin. You can only create and delete databases and hostname from the DreamHost panel but to run the actual query in the database, you need use phpMyAdmin. Now how to use phpMyAdmin is completely a different topic.
You can access phpMyAdmin link from the DreamHost MySQL database page.
I hope you enjoy the article. Go and create your first database.