Category Archives: mysql

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

Posted in Databases, mysql | Tagged , | Leave a comment

How to check MariaDB version

“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 … Continue reading

Posted in CentOS, Computer Science, Databases, linux, mariadb, mysql | Leave a comment

How to Install WordPress on Nginx on CentOS 7

Hi there, This tutorial will show you how to install WordPress using Nginx on CentOS 7. You will need the following commands to follow along with this tutorial. First we’ll need to install additional repos that include php71 and then … Continue reading

Posted in CentOS, Databases, learning, linux, mysql, nginx, web server | Tagged , , , , , | 6 Comments

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

Posted in CentOS, Databases, learning, linux, mysql | Tagged , , , , , , , , , , | Leave a comment

How To Install WordPress On Centos 7

This video shows you how to Install WordPress on Centos 7. The commands that you need to follow along with the tutorial are:   Installing PHP. sudo yum install php sudo yum install php-mysqli   Setting up the Database. Mysql … Continue reading

Posted in CentOS, Databases, learning, linux, mysql | 2 Comments

How To Install Own Cloud on CentOS 7

This video shows how to install Own Cloud on Centos. Own Cloud is simailr to dropbox but you install it on your own server which gives you full control over your data. There are several prerequisites needed to follow along … Continue reading

Posted in CentOS, Cloud, Databases, encryption, learning, linux, mysql | 4 Comments

SOLVED: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

This video shows how to correct the error:   ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes   The commands that you will need to run to correct the error are:   SET GLOBAL … Continue reading

Posted in CentOS, Computer Science, Databases, learning, linux, mysql | Leave a comment

Moodle, how to convert InnoDB tables to Barracuda.

I recently installed Moodle 3.0, everything was going to plan until I noticed that Moodle was giving me the warning below:   “Your database has tables using Antelope as the file format. You are recommended to convert the tables to … Continue reading

Posted in Databases, Moodle, mysql | Leave a comment