MySQL related tutorial/FAQ

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?

MySQL reset password for user account

last updated January 16, 2018 in Linux, MySQL, UNIX

I am a new Linux system user. How do I reset a password for a user account named jerry using mysql command line option?
Continue reading

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?

nixCraft

nixCraft

MySQL

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

MySQL reset password for user account

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

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

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

How to set and enable MariaDB slow query log

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