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?
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 “MySQL reset password for user account”
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?
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)?
ow 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?
setup MariaDB server on Linux. How do I enable slow query log in MariaDB server on Linux or Unix-like system?
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?