MySQL Database Management on Hosting

Tworzenie bazy danych zostało pokazane w poradniku How to create a database using MySQL Database Wizard? This method is recommended due to its complexity. Here we will show you how to manage databases and users of databases that already exist.

Note: After changing names or passwords, you should update this data in the CMS, otherwise your website will stop working!

Where do you manage the databases? 

  1. Log in to Your cPanel account.
  2. Under Databases, click "MySQL Databases". From here you will be able to perform the operations described below.

MySQL Database Management - 1

Create New Database

In this section we can create a new database.

MySQL Database Management - 2

  • New database - provide new database name,
  • Press "Create Database", to add database.

Modify Databases

Here you have two options:

MySQL Database Management - 3

  • Check database - select the database you wish to check and press "Check database".,
  • Repair database - if the table in the database has been marked as corrupted (for example, by checking above), then select the database from the list and press "Repair database".

Current Databases

Here we have a table that shows all the databases, from here you can do the following things:

MySQL Database Management - 4

  • Privileged Users - pressing "user name" moves to the page with the selection of this user's privileges for the database, pressing "trash icon" withdraws user privileges for this database,
  • Actions - click "Rename" to change database name, "Delete" will remove database (user stays).

Add New User

Here you can create a user:

MySQL Database Management - 5

  • Username - provide username,
  • Password - the longer, the better!
  • Password (Again) - type same password as in field above.

Add User to Database

When you have a database and a user, this is where you can give the user privileges to the database.

MySQL Database Management - 6

  • User - choose user from list,
  • Database - select the database for which you want to grant the user privileges from the list,
  • After click "Add" you will be redirected to the privilege selection screen.

Current Users

In this table you can see the previously added users you can manage.

MySQL Database Management - 7

  • Change password - changing the password for the database user,
  • Rename - database user name change,
  • Delete - deleting the user (the assigned base stays).
  • 4 Users Found This Useful
Was this answer helpful?

Related Articles

What DNS server addresses do we have?

At Thecamels we have two DNS servers that work in a cluster to ensure continuous service in case...

Why do I get 500 - Internal Server Error?

When you upload  website to the server and then open it, error "500 - Internal Server Error" can...

How do I fix a session cleaning error in PrestaShop?

In order to fix the problem, please contact us via Client Area. Problem occurs due to incorrect...

How to edit host file in system

Hosts file role, is to translate friendly domain names into their numerical equivalents, i.e. IP...

Why my hosting account has been blocked?

An account may be suspended for several reasons, which are listed below:  No payment for...