Category: Databases

How to rename a database in phpMyAdmin

In this article, we will show you how to rename a database via phpMyAdmin. phpMyAdmin is a free and opensource application for MySQL database management. It is one of the most popular web-based MySQL management tools for web hosting services.  Written in PHP, phpMyAdmin gives users the ability to interact with their MySQL databases. Quick

Continue reading…

How to Install MariaDB/MySQL on CentOS 7

In this guide we’ll go through the steps for installing the latest version of MariaDB on CentOS 7. All Commands – without sudo yum update -y echo -e “[mariadb]\nname=MariaDB Repository\nbaseurl=http://yum.mariadb.org/10.3/centos7-amd64\ngpgcheck=1\ngpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB” | tee /etc/yum.repos.d/MariaDB.repo yum install mariadb-server mariadb-client -y systemctl start mariadb systemctl enable mariadb mysql_secure_installation All Commands – with sudo sudo yum update -y sudo

Continue reading…

How to Install MySQL on CentOS 7

This guide will outlined how to install MySQL on CentOS 7. MySQL is a widely used database management platform used by various applications. Many applications such as WordPress, Joomla and others rely on MySQL databases to function. MySQL however, must be installed with a few different steps since it’s no longer the default in the

Continue reading…

How to Create MySQL Databases and Users Via the Command Line

This article explains how to create a new MySQL database and user using the command line. If MySQL is not installed yet, follow our guide to install MySQL on CentOS 7 first. Quick Steps:  Login to the Database Server as the root user.   Create a new user with the command “CREATE DATABASE databasename;“  Select the

Continue reading…

How to change a WordPress URL using phpMyAdmin

This guide will show you how to manually change a WordPress URL by using phpMyAdmin & cPanel to update your domain or WordPress installation path. Sometimes it may be necessary to manually change the URL for your WordPress site directly in the database. For example, if you have the main domain on your cPanel account

Continue reading…

Managing databases via SSH command line

Managing databases via the SSH command line is sometimes necessary & can be faster than using the phpMyAdmin web interface. If you do not currently have SSH access on your hosting account, you will need to request it via our support department as we do not enable SSH by default for security reasons. When using

Continue reading…

Import / Export a mySQL database using cPanel & phpMyAdmin

This tutorial assumes that you have already created a database. If you have not, you will need to do so first. To import a database into an existing database (.sql file) in cPanel using phpmyadmin follow the steps below. Log into your cPanel account Locate the “phpMyAdmin” icon found under the “Databases” section After phpMyAdmin

Continue reading…

How to Create and Delete a MySQL User in cPanel

This tutorial will explain how to create a MySQL database user in cPanel. Once created, you’ll want to assign it to a database. Quick Steps: Log into cPanel & locate the MySQL Databases icon Scroll down and locate the MySQL Users heading Enter a username in the field provided Enter a password twice into the

Continue reading…

How to Create and Delete a MySQL Database in cPanel

This guide will show you how to create and delete a MySQL database in your cPanel hosting account. Quick Steps to create a MySQL database: Login to cPanel. Locate and click on the “MySQL Databases” icon in the “Databases” category. Under the “Create a New Database” heading, enter a name for your database. Click the

Continue reading…