BlueHost MySQL Database Tutorial

Average Rating:

bluehost-milestoneEver since it was founded in 2003, BlueHost has continuously been living up to what its ultimate goal is, which is to provide unparalleled web hosting experience to their clients. In order to achieve this goal, they continue to incorporate remarkable and useful hosting features, tools and services for their clients to easily create and manage their website(s), as well as to efficiently store and retrieve important files and data.

With BlueHost’s MySQL database, you can be certain that your website’s data are safe and secure.

What Is a MySQL Database?

A database is quite simply a collection of data. For example, your computer serves as a database for documents and files you’ve stored and saved. Meanwhile, a database program is a type of computer software that’s designed to handle large amounts of data. However, instead of just randomly storing and dumping your data all over the place, a database program efficiently stores them in such a way that you can easily retrieve or recover them. This is where MySQL comes into the picture.

MySQL

There are a lot of web-based programs that need to store and retrieve data on a regular basis. This includes blogs, content management systems (CMS), and image galleries. A blog software, for instance, needs to store articles and retrieve them when a visitor goes to your site. The same goes for image galleries where information about the photos are stored in the database. But instead of implementing their own system of data storage and retrieval, these software use specialized database programs.

A lot of database software support a computer language called “SQL”, which is especially designed for such a purpose. SQL is used by those who want the database software to handle the work of managing data by sending instructions to it. There are plenty of databases out there that support SQL, including MySQL.

MySQL is, in fact, a popular brand of database software that runs on websites. You probably see it being advertised in the list of web hosts, as well as on the system requirements for some web software like in blogs and CMS.

 

Why Do I Need MySQL?

At this point, what you need to remember is whether your web hosting provider has the database software your web application needs. Usually, popular blogging and CMS software come with MySQL. In fact, almost all commercial web hosting providers have MySQL as one of the most essential parts of their hosting plans, so you probably don’t have to worry about this.

As mentioned earlier, if you’re using a blogging or CMS platform such as WordPress or Drupal, you need to place your blog or website on a web host that provides you with a MySQL database because it will be used to store all your content, web pages, as well as visitors’ comments.

 

How Can I Create a MySQL Database?

Fortunately, BlueHost is one of those web hosting companies that offers a user-friendly interface that allows you to create your own MySQL database in quick and simple steps. Here’s what you need to do:

 

  1. Log in to the cPanel.

 

  1. Under the Databases category, search for the MySQL Databases icon and click it.

DB

  1. From there, you will see the New Database field where you have to type in a name for the database.

New

 

Afterwards, click on Create Database.

 

  1. Click on Go Back to check whether the new database has already appeared in your Current Databases table.

 

How Can I Delete a MySQL Database?

Deleting a MySQL database is just as easy as creating one. All you need to do is to go to the Current Databases section and from there, you can click on Delete Database link.

 

How Can I Create a Database User?

Once you create a database, you need to assign a user, as well as the privileges you want to add on to that newly created database. Here’s what you need to do when creating a database user:

  1. From the control panel, go to the MySQL Users section of the MySQL Databases

 

  1. Enter a username under the Add New User Your username must contain a maximum of 7 letters.

 

  1. From the Password field, enter your preferred password. Re-type it under the Password (Again)

Add New

 

  1. Once you’re done, click Create User.

 

Once you’ve created a database user, you will have to define its privileges. These privileges will determine the user’s functions and interaction with the database. For example, one of the privileges for the user is to be able to add and delete information. It depends on what specific privileges you include for that particular user.

How Can I Delete a Database User?

To delete a database user, simply navigate to the Current Users section, and then click the red “X” icon next to the user you wish to delete. It’s that simple!

Leave a Reply

Your email address will not be published. Required fields are marked *