Linux Programmer | RHCE | RHCSA

Search This Blog

Wednesday, 21 November 2018

blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'.

Getting this kind of error while connecting with the database,

blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
Solution:
Go to shell of the database server(Where sql database is located) and enter below command,

$ mysqladmin -uusername -ppassword flush-hosts;

No comments:

Post a Comment

Restrict SSH and Allow with SFTP

Create SFTP user:  ``` sudo useradd -M -s /sbin/nologin sftpuser sudo passwd sftpuser ``` Add below lines into, /etc/ssh/sshd_config ``` Mat...