Sign Up / Log In
Need help?
1300 210 210
We're Australian!
#1 for domains & hosting
94% customer satisfaction
Trusted by over 1 million businesses
Expert, 24/7 customer support
90% of issues resolved within a day
Best value
We price match*
Online Support Web Hosting

How to manage MySQL Database

MySQL database allows you to organize data without hassle. In addition, it is necessary to run several web applications such as content management system (WordPress, Joomla, Drupal), bulletin boards and online shopping carts.

Its function is so crucial that managing databases is vital from time to time. At Crazy Domains, you can single-handedly manage your database within the Hosting Manager. In this article, we have compiled helpful articles and instructions so you could have full control over your databases.

Table of Contents

  1. Access MySQL Databases
  2. Create database and user
  3. Rename database and user
  4. Delete database and user
  5. Manage MySQL user privileges
  6. Change user password
  7. Modify databases
  8. Back up a database
  9. Restore a database

1. Access MySQL Databases

Before you can manage your database, you have to access it within the Hosting Manager. Once done, you can do almost everything – from creating, modifying, renaming and deleting databases.

Here are the steps to help you access the databases:

  1. Click Sign Up / Log In at the top of this page.
  2. Select Hosting Manager from the drop-down menu.
  3. Enter your username and password and click Log In.
  4. On the Home page, click Domains or the [ v ] arrow symbol on the right side, and then click Databases.
    You will be redirected to MySQL Databases page.

2. Create Database and User

It is evident that you have to create a database before you can organize online data. Likewise, an assigned user/s is necessary to access and modify the database. Without the other, neither can function.

Here are some detailed instructions to help you create a database and a new user:

3. Rename Database and User

To suit your preferences, you can rename your database and user. See simple instructions below to be guided.

Rename Database

  1. On MySQL Databases page, scroll down to Current Databases.
  2. Look for the database you wish to rename, and click the Rename button on its right side.
  3. Enter new database name on the appropriate field.
  4. Click Proceed.

Rename User

  1. On MySQL Databases page, scroll down to Current Users.
  2. Look for the user you wish to rename, and click the Rename button on its right side.
  3. Enter new user name on the appropriate field.
  4. Click Proceed.

4. Delete Database and User

You can easily delete MySQL database and user if you want to. However, please be informed that this action is irreversible. Make sure that your decision is final, better yet back up your database beforehand.

If you wish to delete a database, here’s a detailed article to help you:

If you wish to delete a user, follow the steps below:

  1. On MySQL Databases page, scroll down to Current Users.
  2. Look for the database you wish to delete, and click the Delete button on its right side.
  3. Click Delete User button.

5. Manage MySQL user privileges

Users have different privileges on your databases depending on what you set. It varies from reading, creating, editing, deleting to performing any action. You can manage user privileges to make sure that every user has authorized rights.

Here’s a detailed instruction to manage user privileges:

6. Change User Password

Changing your password regularly is imperative online. By doing so, you can limit the risk of hackers. Database being a collection of data should be a strong reason to convince you to do so. The least you want is to give hackers user privileges to your databases.

Important Note: The given instructions is also applicable if you lost your user password.

  1. On MySQL Databases page, scroll down to Current Users.
  2. Look for the user you wish to change password, and click the Change Password button on its right side.
  3. Enter new password on the appropriate field.

    If it's difficult to make a strong password, you can let the system create one for you by following these steps:

    1. Click the Password Generator button, next to the Strength meter.
    2. Tick the box for I have copied this password in a safe place.
    3. Click Use Password to automatically copy and paste the generated password in the required fields.
    4. Important Note: Make sure you have actually saved the generated password in a safe and easy to recall place.

  4. Click Change Password button.

7. Modify Databases

If you can’t access or connect to any of your databases, you can check for errors and fix it easily within the Hosting Manager. Here are detailed instructions to check and fix database errors:

8. Back up a database

Regular backup is an apparent rule for all your website files including databases. It’s very handy in unfavorable circumstances. Simply put backup as a duplicate to your files in case your data is lost or corrupted. Despite all the security you impose on your files, there’s nothing more secure than a backup on hand.

Here are some articles to help you backup files including databases:

9. Restore a MySQL database backup

When worse comes to worst, you can easily restore your MySQL database backup. Here are some articles to help you do so:

Congratulations! You just learned how to manage your databases.

Was this helpful? Yes No 82% of people found this helpful.
we're
online
Need Help? Chat Now