Tag Archives: MariaDB

Set root password MariaDB

MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation.

After you install MariaDB you log in using the following command:

mysql -u root -p

You may notice that you don’t get prompted for a password. In order to correct this you will need to run the following :

Step 1

SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘yourPassword’);

Step 2

UPDATE mysql.user SET plugin = ‘ ‘ WHERE user = ‘root’ AND host = ‘localhost’

Step 3


Step 4


Step 5

Run mysql -u root -p You will now need your password to log in.

A full video tutorial can be found here:


How to install Joomla 3 on CentOs 7 /Redhat 7 Linux.

This tutorial shows you how to install Joomla 3 on CentOS 7 / Redhat 7 Linux (RHEL).It shows you first how to download, unzip and move the Joomla files to the correct directory for apache.


Next it shows you how to download and install php including the php-mysqli extension that is needed by Joomla. You will then see how to configure Apache to see the Joomla files.


Next you will then configure permissions and set up your Joomla Database in MYSQL (MariaDB) Finally you will install Joomla.



The commands that you need to follow along with this tutorial are:


Downloading, Unzipping and Moving Joomla:


sudo Wget https://downloads.joomla.org/cms/joomla3/3-8-3/Joomla_3-8-3-Stable-Full_Package.zip?format=zip
Sudo mkdir Joomla
Sudo mv Joomla_3-8-3-Stable-Full_Package.zip\?format\=zip Joomla
Cd Joomla
Sudo unzip Joomla_3-8-3-Stable-Full_Package.zip\?format\=zip Joomla
Sudo rm Joomla_3-8-3-Stable-Full_Package.zip\?format\=zip
Sudo mv Joomla /var/www/html


Installing PHP


Sudo yum install php
Sudo yum install php-mysqli


Configuring Apache and Permissions  


Sudo vi /etc/httpd/conf/httpd.conf
Sudo service httpd restart
Sudo chown apache:apache -R /var/www/html/Joomla
Sudo chcon -Rv –type=httpd_sys_rw_content_t /var/www/html

Configuring MYSQL / MariaDB


Mysql -u root -p
Create database joomla;
grant all on joomla.* to ‘darren’@’localhost’ identified by ‘password123’;