Category: mySQL

Clean and Optimize a WordPress Database

In this KB Article, we discuss the importance of keeping your WordPress database(s) optimized and clean. The WordPress database stores everything that you need for your website and many things that you don’t. What can affect database performance? The frequent addition, deletion and moving data in the database that WordPress uses can make it inefficient.

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 applications 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…

How To Install phpMyAdmin on CentOS 7

In this tutorial, we will go through the steps to installing and configuring phpMyAdmin in CentOS 7. All commands – without sudo yum update -y yum install epel-release -y yum install phpmyadmin -y All commands – with sudo sudo yum update -y sudo yum install epel-release -y sudo yum install phpmyadmin -y Introduction phpMyAdmin is

Continue reading…

How to Install NGINX, MySQL, PHP v7 (LEMP) Stack on CentOS 7

In this guide we go through the steps for building the LEMP stack on CentOS 7. All Commands – without sudo yum update -y yum install epel-release -y yum install nginx -y systemctl start nginx systemctl enable nginx firewall-cmd – permanent – add-service=http firewall-cmd – permanent – add-service=https firewall-cmd – reload yum install mariadb-server mariadb

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 Install LAMP (Linux, Apache, MySQL, PHP) on CentOS 7

In this guide we will walk through the steps for installing and configuring LAMP stack on a CentOS 7 VPS. All commands – without sudo yum update yum install httpd -y systemctl start httpd systemctl enable httpd yum install mariadb-server mariadb -y systemctl start mariadb systemctl enable mariadb systemctl mysql_secure_installation yum install epel-release yum-utils -y

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…