Category: Databases

phpMyAdmin Tutorials

Working with databases in phpMyAdmin Watch this video on YouTube   How to manage a MySQL database with phpMyAdmin in cPanel Watch this video on YouTube   How to Delete fields from tables with phpMyAdmin Watch this video on YouTube   How to modify fields in tables using phpMyAdmin Watch this video on YouTube  

Continue reading…

How To Deactivate Faulty Plugins From The WordPress Database

  In this guide, we will walk you through the steps to deactivate plugins from within the WordPress database using phpMyAdmin. A faulty plugin may prevent your WordPress website from loading. Most of the time, disabling a particular plugin via the admin area will sort out the issue.  We can re-install that particular plugin later

Continue reading…

Renaming Database Tables via phpMyAdmin

In this article, we’ll show you how to rename database tables using 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 Steps

Continue reading…

How to Run SQL Queries in phpMyAdmin

This article demonstrates how to run SQL queries in phpMyAdmin. SQL queries are commands that are issued to the MySQL server to perform various functions. Used by advanced users, SQL queries can quickly make changes to your database simply by issuing the appropriate commands. You can execute a MySQL query towards a given database by

Continue reading…

Rename a Database in phpMyAdmin

In this article, we will show you how to rename a database using phpMyAdmin. A free and open-source program for managing MySQL databases is called phpMyAdmin. It is one of the most widely used web-based MySQL management tools for hosting companies. Users can communicate with their MySQL databases using phpMyAdmin, which is written in PHP.

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…