Tutorials: MySQL

How to Install Drupal on Ubuntu 18.04

This tutorial will show you how to install Drupal on an Ubuntu 18.04 computer. As of writing this article, the latest version of Drupal is 8.7.7. 1. Update your Ubuntu computer. $ sudo apt update 2. Install the LAMP stack. Refer to the tutorial How to Install Linux, Apache, MySQL, PHP (LAMP) Stack on Ubuntu 18.04. 3. Create a database and a database user for Drupal – and grant user… Read more

How to Install Joomla on Ubuntu 18.04

This tutorial will show you how to install Joomla on a Ubuntu 18.04 computer. As of writing this article, the latest version of Joomla is 3.9.11. 1. Update your Ubuntu system. $ sudo apt update 2. Install the LAMP stack. Refer to the tutorial How to Install Linux, Apache, MySQL, PHP (LAMP) Stack on Ubuntu 18.04. 3. Go to the Joomla website download page and copy the URL for Joomla’s… Read more

How to Install Drupal 8 on a Web Host Step By Step

Drupal is an open-source Content Management System used in building websites. It is the third widely-used CMS on the internet after WordPress and Joomla. It is particularly popular among advanced users because of its loading speed, flexibility, scalability and security features. Unlike other CMS’s, however, it is excluded by default from the software bundles on the front page of cPanel. This tutorial will teach you how to install Drupal 8… Read more

Importing Large SQL File into MySQL Database in Ubuntu 18.04

You were importing a large SQL file into a MySQL database and you encountered this error: You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit. Fret not. Here is the list of steps to accomplish the task: 1. Open the file php.ini in the directory /etc/php/7.2/apache2. $ sudo gedit /etc/php/7.2/apache2/php.ini 2. Look for the following lines and change… Read more

How to Create a New MySQL Database Using cPanel

MySQL is an open-source relational database management system. It is often bundled with other software to run websites and web applications. It is installed with the Apache HTTP server and the PHP language in software stacks like LAMP (Linux, Apache, MySQL and PHP) and WAMP (Windows, Apache, MySQL and PHP). It is used by Content Management Systems like WordPress, Joomla and Drupal. 1. Log in to the cPanel of your… Read more

How to Install Linux, Apache, MySQL, PHP (LAMP) Stack on Ubuntu 18.04

The LAMP stack is a group of four open-source software used in building dynamic websites and web applications. The acronym stands for the Linux operating system, the Apache web server, the MySQL database, and the PHP programming language. In this tutorial, we will install LAMP on an Ubuntu 18.04 computer. 1. Update and upgrade your Ubuntu system $ sudo apt update $ sudo apt upgrade 2. Install Apache and confirm… Read more

How to Migrate a WordPress Site to Another Host Using cPanel

Migrating a website from one host to another is a headache whether you know what to do or not. You may want to move your website to another host because it has grown too big over the years and has been receiving too much traffic lately that your present hosting service cannot handle. Whatever your reason is for the hosting transfer, the following steps will make it smooth and easy…. Read more

How to Install WordPress on Ubuntu 18.04 Step By Step

The use of Content Management System (CMS) has drastically changed the way content is published on the internet and allowed for the mushrooming of a lot of websites. Websites built with WordPress (a CMS) account for the majority of websites online that run using CMS. Because the history of WordPress is rooted on blogging, it makes content publishing relatively easy and straightforward. By installing WordPress with LAMP (Linux, Apache, MySQL,… Read more