MariaDB HowTo - Linux / Unix Q & A from nixCraft

How To Install MariaDB on CentOS 8

last updated October 1, 2019 in CentOS, Linux

I am a new to MariaDB server and CentOS 8 sysadmin. How do I install MariaDB on CentOS 8 Linux server using the yum command?

OpenBSD install MariaDB database server

last updated October 1, 2019 in MySQL, OpenBSD, UNIX

How do I install MariaDB database servers on OpenBSD Unix operating systems?

How To Install Linux, Apache, MySQL, PHP (LAMP) stack On RHEL 8

last updated December 14, 2018 in Apache, Linux, MySQL, PHP, RedHat and Friends

How do I set up a LAMP stack on RHEL 8 cloud server or VPS or bare metal server? How can I install Linux, Apache, MySQL/MariaDB, PHP (LAMP) stack On RHEL (Red Hat Enterprise Linux) 8?

How To Install MariaDB on RHEL 8

last updated October 1, 2019 in Linux, RedHat and Friends

I am a new MariaDB user and RHEL 8 system adminstrator. How do I install MariaDB on RHEL 8 server using the yum command?

Fix Host ‘IP’ is blocked because of many connection errors on MySQL/MariaDB

last updated November 15, 2017 in CentOS, Debian / Ubuntu, FreeBSD, Linux, MySQL, Suse, Troubleshooting, UNIX

I am trying to login to my mysql/mysqld server using the following Unix command:
$ mysql -u foo -h 172.16.5.100 -p dbnmame
But greeted with the following error on screen:
ERROR 1129 (HY000): Host ‘172.16.5.100’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’
How do I fix this problem on a Linux or Unix-like system?

How to test PHP 7 and WordPress MySQL/MariaDB Database connectivity using a PHP script

last updated August 15, 2017 in Linux, MySQL, PHP, UNIX

I wanted to test if my PHP 7 and MySQL/MariaDB for WordPress are working. If not I wanted to see some error on screen or for my monitoring system. How to write a script for a quick PHP MySQL DB connection test for WordPress or any other database and send an email or text when site is down?

How To Install Linux, Apache, MySQL, PHP (LAMP) Stack on Debian 9 Stretch

last updated September 24, 2017 in Apache, Debian / Ubuntu, Linux, MySQL, Package Management, PHP

I am a new user of Debian 9 operating system. Can you tell me how to setup and install LAMP stack on a Debian 9 (Stretch)?