MariaDB HowTo - Linux / Unix Q & A from nixCraft

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

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

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

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

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

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

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)?

How to set up MariaDB Master-Slave replication with SSL on Ubuntu Linux

in Debian / Ubuntu, Linux, MySQL last updated July 26, 2017

How do I setup Master-slave data replication using MariaDB server on Ubuntu Linux 16.04 LTS server? How do I encrypt replication traffic so that the data get encrypted in transit, protecting my data and users from snooping?

How to set and enable MariaDB slow query log

in BASH Shell, CentOS, Debian / Ubuntu, FreeBSD, Linux, MySQL, RedHat and Friends, Suse, UNIX last updated March 29, 2017

I setup MariaDB server on Linux. How do I enable slow query log in MariaDB server on Linux or Unix-like system?

How to install and configure MariaDB Galera as master to master replication cluster on Ubuntu 16.04 LTS

in CentOS, Debian / Ubuntu, Linux, MySQL, RedHat and Friends, Suse last updated March 6, 2017

How do I install and configure MariaDB Galera master to master cluster on Ubuntu Linux 16.04 LTS server to get both read and write scalability?

How to delete or remove a MySQL/MariaDB user account on Linux or Unix

in Linux, MySQL, UNIX last updated February 16, 2017

I created a MySQL / MariaDB user account using this page. Now, I have deleted my wordpress blog and I want to delete that user account including database too. How do I delete or remove a MySQL or MariaDB user account on Linux or Unix-like system using mysql command line option?