×

This article covers how to allow remote connections to a MySQL server. Hosting databases and web servers on a separate database server can improve security, hardware performance, and enable you to scale resources quickly.

One of the most frequently observed database bottlenecks encountered by large projects is high MySQL traffic. Sure, we could talk about moving to a bigger cloud instance size, faster cores, and better storage, but that’s too obvious and costly. Instead, we would like to focus on several tips that can reduce traffic with a bit of configuration.


Methods to reduce Internet traffic when connecting to the remote host:

  • Disable and/or optimize the high-load features of your application.
  • Use ProxySQL to enable connection pooling. This will prevent your application from overloading MySQL with a multitude of concurrent connections. Another nice feature of ProxySQL helps cache query results for a certain period of time.
  • Monitor your databases for performance bottlenecks.
  • Identify and optimize queries that cause high load. If you use dbForge Studio for MySQL, you get a specialized tool—Query Profiler—which helps you deal with this task easily.
  • Add missing indexes and eliminate redundant and unused ones.
  • Conduct a thorough check of your background operations. Some of them can be postponed, some may work just as effectively with limited resources (e.g. limited concurrencies for batch jobs), and some may be perfectly running on replicas.



This article covers step-by-step installation procedure of the MariaDB server on Rocky Linux 8. In fact, MariaDB was developed as a "drop-in" replacement for MySQL. As such, both software packages are functionally equivalent and interchangeable.

To enable MariaDB service to start on boot time and start the service using the following commands:

$ sudo systemctl enable mariadb
$ sudo systemctl start mariadb

To verify the running status of MariaDB, run the below command:

$ sudo systemctl status mariadb



This article covers how to install LAMP stack on Rocky Linux 8.4. You can now proceed to test or host your website and applications. A LAMP stack is a group of open-source software that is typically installed together to enable a server to host dynamic websites and web apps. This term is actually an acronym which represents the Linux operating system, with the Apache web server. The site data is stored in a MySQL database, and dynamic content is processed by PHP.


How to Install  and configure Apache Web Server ?

1. First, we will start by installing the Apache web server. To complete the installation, use the following command:

$ yum install httpd httpd-tools

2. Once the installation is complete, enable Apache (to start automatically upon system boot), start the web server and verify the status using the commands below:

$ systemctl enable httpd
$ systemctl start httpd
$ systemctl status httpd

3. To make your pages available to public, you will have to edit your firewall rules to allow HTTP and HTTPS requests on your web server by using the following commands:

$ firewall-cmd --permanent --zone=public --add-service=http 
$ firewall-cmd --permanent --zone=public --add-service=https 
$ firewall-cmd --reload
4. Verify that the web server is running and accessible by accessing your server’s IP address:
$ echo "Hello there, Apache webserver is now running" > /var/www/html/index.html

5. And restart tht Web Server to reflect the changes made:

$ systemctl restart httpd

From your browser,

http://IP_address


How to Install PHP on CentOS ?

1. To install PHP on your RHEL 8 use the command below:

$ yum install -y php-mysqlnd php-dom php-simplexml php-xml php-xmlreader php-curl php-exif php-ftp php-gd php-iconv  php-json php-mbstring php-posix php-sockets php-tokenizer

2. Now restart your web server so that Apache knows that it will be serving PHP requests as well:

$ systemctl restart httpd



This article covers the best cross-platform compatible data migration tools available in the market that not just ensure safe and secure data migration but also provide a seamless user experience. IRI NextForm tops our list due to its advanced functionalities along with a simple and easy user experience. DBConvert Studio is another great tool that offers cross-platform and cross-database compatibility and vast support for various formats and databases. 

Next in our list are the data migration tools offered by the information technology industry giants, i.e., data migration tools by AWS, IBM, and Microsoft. All the tools offer seamless data migration capability with slight features and compatibilities modifications that can change according to user preference, and so whatever platform is adopted by the user, according to their requirements, will ensure a seamless and autonomous data migration process.

Data migration is a need of every business, enterprise, and company. Sooner or later, every organization needs to tend to their database management services which always, or in most cases, involve data migrations. 



This article covers how to Install phpMyAdmin with Nginx on Ubuntu 18.04 system. When developing a website or web application, many users need the functionality of a database system like MySQL. However, interacting with the system solely from the MySQL command-line client requires familiarity with Structured Query Language — more commonly referred to as SQL — which can present a major hurdle for some users. phpMyAdmin was created to allow users to interact with MySQL through an intuitive web interface, running alongside a PHP development environment. 


How to Secure phpMyAdmin with Let's Encrypt SSL ?

Before starting, you will need to install the Certbot client to download and install Let's Encrypt SSL.

1. First, add the Certbot repository with the following command:

$ add-apt-repository ppa:ahasenack/certbot-tlssni01-1875471

2. Next, update the repository and install the Certbot client using the following command:

$ apt-get update -y
$ apt-get install certbot python3-certbot-nginx -y

3. Once the Certbot has been installed, run the following command to download and install the Let's Encrypt SSL for your domain:

$ certbot --nginx -d phpmyadmin.domain.com



This article covers how to install LAMP stack on CentOS 7. LAMP is a stack of applications that work together on a web server to host a website. With that being said, each individual program serves a different purpose.

In LAMP: 

  • Linux serves as the server's operating system that handles all the commands on the machine.
  • Apache is a web server software that manages HTTP requests to deliver your website's content.
  • MySQL is a relational database management system (RDBMS) whose function is to maintain user's data on a server.
  • PHP is a scripting language for server-side communication.


To install Apache easily using CentOS's package manager, yum:

1. Run the command.

$ sudo yum install httpd

2. Once it installs, you can start Apache on your server.

$ sudo systemctl start httpd.service

3. You can do a spot check right away to verify that everything went as planned by visiting your server's public IP address in your web browser.

http://your_server_IP_address/


Important PHP Modules:

  • php-bcmath.x86_64 : A module for PHP applications for using the bcmath library.
  • php-cli.x86_64 : Command-line interface for PHP.
  • php-common.x86_64 : Common files for PHP.
  • php-dba.x86_64 : A database abstraction layer module for PHP applications.
  • php-devel.x86_64 : Files needed for building PHP extensions.
  • php-embedded.x86_64 : PHP library for embedding in applications.
  • php-enchant.x86_64 : Enchant spelling extension for PHP applications.
  • php-fpm.x86_64 : PHP FastCGI Process Manager.
  • php-gd.x86_64 : A module for PHP applications for using the gd graphics library.



This article covers how to install mysql 8.0 and Secure MySQL on Debian 9 server. MySQL, the world's most popular open-source relational database management system is not available in the default Debian's repositories. MariaDB is the default database system in Debian 10. 

The MySQL APT repository provides a simple and convenient way to install and update MySQL products with the latest software packages using Apt. The MySQL APT repository provides MySQL packages for the following Linux distros: Debian.


How to Uninstall MySQL from Debian?

To remove MySQL, Run the following commands:

$ sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
$ sudo apt-get autoremove -y
$ sudo apt-get autoclean
rm -rf /etc/mysql
sudo find / -iname 'mysql*' -exec rm -rf {} \;


How to secure MySQL ?

MySQL comes with a command we can use to perform a few security-related updates on our new install. Let's run it now:

$ mysql_secure_installation

This will ask you for the MySQL root password that you set during installation. Type it in and press ENTER. Then answer a series of yes or no prompts. 



This article covers how to install and Secure MariaDB on a CentOS 7 server. MariaDB is a fork of MySQL managed by the original MySQL developers. It's designed as a replacement for MySQL, uses some commands that reference mysql, and is the default package on CentOS 7.


To Install MariaDB 5.5 on CentOS 7:

1. Install the MariaDB package using the yum package manager: 

$ sudo yum install mariadb-server

2. Once the installation is complete, start the MariaDB service and enable it to start on boot using the following commands: 

$ sudo systemctl start mariadb 
$ sudo systemctl enable mariadb


To install MariaDB on CentOS 8:

1. Open the terminal application. Another option is to log in using the ssh command:

 ssh user@centos-8-server-ip

2. Install the MariaDB on CentOS 8 by running the command:

$ sudo yum install mariadb-server

3. Secure the MariaDB server in CentOS 8 by running the command:

$ sudo mysql_secure_installation

4. Finally test MariaDB installation by running the command:

$ mysql -u root -p


MariaDB vs MySQL:

Even though MariaDB is a fork of MySQL, these two database management systems are still quite different: 

MariaDB is fully GPL licensed while MySQL takes a dual-license approach.

MariaDB supports a lot of different storage engines. 

In many scenarios, MariaDB offers improved performance.



This article covers the PHP installation on Ubuntu 20.04 system.  Basically, popular Content Management platforms such as WordPress, Drupal, and Magento are based on PHP.


To Install PHP on Ubuntu 20.04:

1. Update your server.

$ apt-get update && apt-get upgrade

2. Install PHP on Ubuntu 20.04, just run the following command.

$ apt-get install php

3. To verify if PHP is installed, run the following command.

php -v


To Install PHP 7.4 modules (extensions):

Run the command below.

apt-get install php-pear php-fpm php-dev php-zip php-curl php-xmlrpc php-gd php-mysql php-mbstring php-xml libapache2-mod-php

To check all the PHP modules available in Ubuntu, run:

$ apt-cache search --names-only ^php


How to install PHP 8.0 on Ubuntu 20.04 or 18.04 ?

1. First, update your Ubuntu server:

$ apt-get update && apt-get upgrade

2. Add the PHP repository (by Ondřej Surý):

$ apt-get install software-properties-common
$ add-apt-repository ppa:ondrej/php

3. And finally, update your package list:

$ apt-get update

4. Install PHP 8.0 with the following command:

$ apt-get install php8.0

5. To check if PHP 8.0 is installed on your server, run the following command:

$ php -v

6. Install PHP 8.0 modules (extensions)

You may need additional packages and modules depending on your applications. The most commonly used modules can be installed with the following command:

$ apt-get install libapache2-mod-php8.0 php8.0-fpm libapache2-mod-fcgid php8.0-curl php8.0-dev php8.0-gd php8.0-mbstring php8.0-zip php8.0-mysql php8.0-xml


How to change the PHP version you're using ?

If you have multiple PHP versions installed on your Ubuntu server, you can change what version is the default one.

1. To set PHP 7.4 as the default, run:

$ update-alternatives --set php /usr/bin/php7.4

2. To set PHP 8.0 as the default, run:

$ update-alternatives --set php /usr/bin/php8.0

3. You can verify what version of PHP you’re using with the following command:

$ php -v



This article covers how to install LEMP stack on CentOS 7. LEMP stands for the Linux operating system, with the ENginx web server (which replaces the Apache component of a LAMP stack). The site data is stored in a MySQL-based database, and dynamic content is processed by PHP.

A LEMP software stack is basically a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps.


To install Nginx on CentOS:

1. Add the CentOS 7 EPEL repository, run the following command:

$ sudo yum install epel-release

2. Now that the EPEL repository is installed on your server, install Nginx using the following yum command:

$ sudo yum install nginx

3. Once the installation is finished, start the Nginx service with:

$ sudo systemctl start nginx



This article covers how to install phpMyAdmin with Nginx on CentOS 7 system. phpMyAdmin helps to handle the database administration of MySQL, MariaDB and Drizzle servers over the web. It basically provides the intuitive web interface and supports most of the MySQL features to create and drop databases, create/drop/alter tables, delete/edit/add columns, execute any SQL statement and to manage indexes on columns.


To install phpMyAdmin, run the following commands:

# yum install epel-release
# yum install phpmyadmin


To restart nginx, mariadb and php-fpm services, run the following commands:

# systemctl restart mariadb.service
# systemctl restart nginx.service
# systemctl restart php-fpm.service



This article covers how to Install phpMyAdmin with Apache on CentOS 7 system. phpMyAdmin is a database utility used for managing MySQL databases through a graphical web-based interface. It can be configured to manage a local database (on the same system), or a remote database (over a network).


To Install EPEL Repository:

1. Get access to the EPEL repository – the Extra Packages for Enterprise Linux, by running the command.

$ sudo yum install -y epel-release

2. Once that operation finishes, it's a good idea to refresh and update the EPEL repository.

$ sudo yum –y update


To Install Apache Web Server:

1. Install Apache on CentOS use the command.

$ yum install httpd -y

2. Verify the status of Apache by running with the command.

$ systemctl status httpd


To install PHPMyAdmin on CentOS, enter the command:

$ sudo yum -y install phpmyadmin



This article covers how to install phpMyAdmin with Apache on Ubuntu 18.04 system. While many users need the functionality of a database management system like MySQL, they may not feel comfortable interacting with the system solely from the MySQL prompt. phpMyAdmin was created so that users can interact with MySQL through a web interface. 


Important php packages includes:

  • php-mbstring: A module for managing non-ASCII strings and convert strings to different encodings.
  • php-zip: This extension supports uploading .zip files to phpMyAdmin.
  • php-gd: Enables support for the GD Graphics Library.
  • php-json: Provides PHP with support for JSON serialization.
  • php-curl: Allows PHP to interact with different kinds of servers using different protocols.



This article covers step by step process to Install and Configure phpMyAdmin with Apache on Debian 9 system. The phpMyAdmin utility is a graphical database management tool. By installing phpMyAdmin, you no longer need to use a default command-line interface to manage your databases.


To install wget:

1. Access your terminal window, and update your software package lists using the following command:

$ sudo apt update

2. The wget utility allows you to download files directly from the terminal window. Enter the following command to install the wget tool:

$ sudo apt install wget -y


To install Apache on Debian:

1. Open a terminal window, and install Apache by entering the following command:

$ sudo apt install apache2 -y

2. Enter the following command to make sure the Apache service is running:

$ systemctl status apache2

In the output, you should see a green status that says active (running).


To Install PHP on Debian 10:

1. Install core PHP packages and Apache and MySQL plugins with the following command:

$ sudo apt install php php-cgi php-mysqli php-pear php-mbstring php-gettext libapache2-mod-php php-common php-phpseclib php-mysql -y

2. Once the installation process is complete, verify that PHP has been installed:

$ php --version

The system displays the current version of PHP, along with the date of the release.



This article covers how to install MariaDB on Ubuntu 18.04 server. Also, you will learn how to secure and connect to MariaDB server. MariaDB is an open-source relational database management system, commonly used as an alternative for MySQL as the database portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. Basically, It is intended to be a drop-in replacement for MySQL.


How to Install MariaDB ?

1. To install it, update the package index on your server with apt:

$ sudo apt update

2, Then install the package:

$ sudo apt install mariadb-server



This article covers how to install and secure a MySQL server on a CentOS 7 server. MySQL is one of the most widely used database management systems for websites and server applications.


To start the MySQL server daemon with the following command:

$ sudo systemctl start mysqld

systemctl doesn't display the outcome of all service management commands, so to be sure we succeeded, we'll use the following command:

$ sudo systemctl status mysqld

To configure MySQL, run the following command:

$ sudo mysql_secure_installation

To Current MySQL Version, run the command:

$ mysql -u root -p


Terms used in Managing MySQL User Permissions:

  • SELECT – users can read through the database using the select command.
  • CREATE – they can generate new tables.
  • DROP – allows users to remove tables.
  • DELETE – users can take out rows from tables.
  • INSERT – lets users add in rows into tables.
  • UPDATE – enable them to update the rows.
  • GRANT OPTION – they can grant or remove the privileges of other users.



This article covers how to install MariaDB version on a Debian 10 server, and verify that it is running and has a safe initial configuration.


How To Install MariaDB on Debian 10 ?

1. To install MariaDB, update the package index on your server with apt:

$ sudo apt update

2. Then install the package:

$ sudo apt install mariadb-server

3. To Configure MariaDB, Run the security script:

$ sudo mysql_secure_installation



This article covers how to install LAMP on Debian server along with PHPMyAdmin to manage your database. LAMP stands for Linux OS, with Apache web server, Data store in a MySql or MariaDB database, and dynamic content is processed by PHP.


To install Apache on Debian:

1. Run the following command:

$ apt-get install apache2

2. To restart your web server by typing the following command:

$ service apache2 restart



This article covers how to setup Drupal on Debian Linux System.

Drupal is a powerful CMS that allows you to design stunning websites and blogs with simple tools and drag and drop features in a matter of a few hours.
It offers flexibility in terms of customization of your site to meet your desired results.
You can easily get started with free templates before advancing to premium templates that have more features.

To Configure Apache 2.4:
1. Enable Apache's rewrite module. This module is necessary since Drupal 8 enables Clean URLs by default;

$ sudo a2enmod rewrite

2. Specify the rewrite conditions for your Drupal site’s document root in Apache's configuration file using the text editor of your choice.
If you installed and configured your Apache server using LAMP stack on Debian 10 guide, the configuration file for your site is located at /etc/apache2/sites-available/example.com.conf.
File: /etc/apache2/sites-available/example.com.conf:

<Directory /var/www/html/example.com/public_html>
        Options Indexes FollowSymLinks
        AllowOverride All
        Require all granted
          RewriteEngine on
          RewriteBase /
          RewriteCond %{REQUEST_FILENAME} !-f
          RewriteCond %{REQUEST_FILENAME} !-d
          RewriteRule ^(.*)$ index.php?q=$1 [L,QSA]
</Directory>

3. Change the ownership of your site's document root from root to www-data. This allows you to install modules and themes, and to update Drupal, without being prompted for FTP credentials.

$ sudo chown -R www-data:www-data /var/www/html/example.com

4. Restart Apache so all changes are applied.

$ sudo systemctl restart apache2



This article covers how to install MariaDB on Ubuntu 20.04 LTS system. Also you will learn how to secure it by configuring some security options and then, in the end, we have tested the connection to MariaDB. The #Ubuntu server should have a non-root administrative user and a firewall configured with UFW.

By following the above simple steps, you can easily setup MariaDB on your ubuntu system. 

For more information, visit MariaDB's official documentation .

MariaDB is one of the most widely used and open-source database management systems. 

MariaDB is considered as a replacement for #MySQL and has much more features and capabilities that you cannot find in MySQL.


To install #MariaDB on Debian:

1. Update your package index using apt;

$ sudo apt update

2. Install the mariadb-server package using apt. The package also pulls in related tools to interact with MariaDB;

$ sudo apt install mariadb-server

3. Run the included mysql_secure_installation security script to restrict access to the server;

$ sudo mysql_secure_installation



This article covers how to resolve the above maiadb problem "Job for mariadb.service failed because the control process exited with error code" which may arise during the installation of #MariaDB on #CentOS 8.

The /var/lib/mysql directory is not empty when MariaDB is installed, it contains e.g. the 'mysql' database and some other files. 

Recreating the folder, even with correct permissions, will not help you. 

Either MariaDB has not been successfully installed or the directory was removed. Reinstall MariaDB to get a working basic database system back.

Also, you can give access /var/log/mysql/* to mysql by running the command:

sudo chown mysql:mysql /var/log/mysql/*


MariaDB offers more and better storage engines, NoSQL support, provided by Cassandra, allows you to run SQL and NoSQL in a single database system. 

MariaDB also supports TokuDB, which can handle big data for large organizations and corporate users.


To view mysql error logs:

1. edit /etc/my.cnf [mysqld] log=/tmp/mysql.log.

2. restart the computer or the mysqld service service mysqld restart.

3. open phpmyadmin/any application that uses mysql/mysql console and run a query.

4. cat /tmp/mysql.log ( you should see the query )



This article will guide you on how to install MariaDB on your CentOS 8 system. Now you can create new databases and grant privileges to other database users. Also, you can add users and create new databases for web or desktop applications which will be written in PHP, Python, and so on.

In MariaDB replication is faster whereas in MySQL replication is slower. 

MariaDB is Open Source whereas MySQL uses some proprietary code in its Enterprise Edition. 

MariaDB doesn't support Data Masking and Dynamic column while MySQL supports it. Comparatively MariaDB is faster than MySQL.


To uninstall MariaDB and install mysql:

1. Purge mariadb sudo apt purge mariadb-* Remove all databases ('Yes' answer)

2. Purge mysql sudo apt purge mysql-*

3. Remove folders: sudo rm -r /usr/share/mysql/ sudo rm -r /etc/mysql/ sudo rm -r /lib/systemd/system/mysql.service.

4. Now you can try to install oracle mysql: sudo apt install mysql-server.



This article will guide you on the different methods to conveniently install and start the MariaDB service on a Debian 10 system. Also, we dealt with how to easily remove MariaDB from your Debian 10 system. 

In MariaDB replication is faster whereas in MySQL replication is slower. 

MariaDB is Open Source whereas MySQL uses some proprietary code in its Enterprise Edition. 

MariaDB doesn't support Data Masking and Dynamic column while MySQL supports it. Comparatively MariaDB is faster than MySQL.

Since MariaDB is a fork of MySQL, the database structure and indexes of MariaDB are the same as #MySQL. 

This allows you to switch from MySQL to MariaDB without having to alter your applications since the data and data structures will not need to change. Data and table definition files are compatible.


To install #MariaDB on #Debian , follow these steps:

1. First update the apt packages index by typing: sudo apt update.

2. Once the packages list is updated, install MariaDB by running the following command: sudo apt install mariadb-server.

3. The MariaDB service will start automatically.



This article will guide you on steps to install #MariaDB on the #Linux operating system. 

MariaDB offers more and better storage engines. NoSQL support, provided by Cassandra, allows you to run SQL and NoSQL in a single database system. MariaDB also supports TokuDB, which can handle big data for large organizations and corporate users.

As a columnar database, MariaDB ColumnStore stores table data in columns rather than rows. Data partitioning by columns is also called Vertical Partitioning.

MariaDB is a drop in place replacement for #MySQL, but you can also install it alongside MySQL. 

To install MariaDB on #Ubuntu 18.04, follow these steps:

1. Update packages index. sudo apt update.

2. Once the packages list is updated, install MariaDB by issuing the following command: sudo apt install mariadb-server.

3. The MariaDB service will start automatically.



This article will guide you on the different commands to list all installed rpm packages on CentOS, RHEL (Red Hat Enterprise Linux), SUSE/OpenSUSE and other rpm based distros using rpm and dnf/yum command that print a list of all installed packages on your distro.



This article will guide you on how to run commands as root user using nonuser, su, and sudo utilities.



MariaDB is a very popular Database management system which is open source. It is well know as being stable and in this context , we will analyze how to get it running on your CentOS 7 Linux machine.




More Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on IbmiMedia.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com