MySQL

Installing and Configuring MariaDB on CentOS 7

What is MariaDB?

MariaDB Server is another most popular open source database server in the world which is also made by developers of MySQL.
It is an enhanced replacement for MySQL that is mostly used because it is fast. For more information about MariaDB, you may see this LINK.

You need to be logged in to your CentOS 7 with root privileges (sudo su -) before proceeding with the installation.

Installing MariaDB
We will be using “yum” package manager in installing the MariaDB. To start, you may use the command below:

How to repair MySQL databases and tables using phpMyAdmin – cPanel

Sometimes, you may encounter issues on your MySQL databases. When it shows error messages regarding your database or tables, you can try to check and repair these problems using the phpMyAdmin tool.

First, you need to Login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)
Locate and click phpMyAdmin under the Databases section.

 

 

You will be redirected to the phpMyAdmin main screen that will show all your databases on the list.
To check or repair a database, select the database you wish to check on the list. The tables will then show up on the center part of the screen.

How to change MySQL root password – WHM

When there is a need to change your MySQL root password, then you can do this via WHM.
First, you need to be logged in to the WHM.
From the search bar on the top left of the screen, just type in mysql. (Don’t know how to login to WHM? Click here)

 

 

You will then see the “MySQL Root Password” option on the left pane. Click on it and the screen for MySQL Root Password will show up. You may now type in your preferred new password and just click on the Change Password button to proceed and save the new password.

How to import a MySQL Database using phpMyAdmin

When you backed up or exported a database into an SQL file, you can import it into your other hosting accounts MySQL database via phpMyAdmin. To start, you need to make sure you have your SQL, .zip or tar.gz file and you have created a new database (How to create a new database) where you will import the MySQL database into.

First login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)

You will be redirected to the phpMyAdmin page where you will see your databases on the left part of the screen. Click on the new database you created where you will import the existing SQL file.

How to access phpMyAdmin in cPanel

To access the phpMyAdmin from cPanel, simply log in to your cPanel account and click on the phpMyAdmin icon under the category Databases. (Don’t know how to login to your cPanel account? Click here)

You will be redirected to the phpMyAdmin page and see the following:

  • General Settings
  • Appearance Settings
  • Database Server Informations
  • Web Server Informations
  • phpMyAdmin Links

What you can do within the phpMyAdmin interface.

First, you need to create a database. (Click here to know more on how to create database.)

Viewing  your Databases

Creating Databases and Database Users for phpMyAdmin in cPanel

Creating Databases

To create new databases, you need login to your cPanel account. (Don’t know how to login to your cPanel account? Click here)

From the cPanel main screen, locate and click on the phpMyAdmin from the category Databases.

You will be redirected to the page to “Create New Database”. Type in the database name you wish to use and just click on “Create Database” button and you will receive a confirmation that you have added the new database. Click on the “Go Back” button to go back to the MySQL Databases screen.

How to create a database in cPanel

To create the database:

Go to “MySQL Databases”

 

  1. In the New Database field, type a name for the database.
  2. Click Create Database.
  3. Click Go Back.
    • The new database will appear in the Current Databases table.