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…

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 -y systemctl start mariadb systemctl

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…