Category: mySQL

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