Mysql: Difference between revisions

From Server STB
Jump to navigation Jump to search
No edit summary
No edit summary
Line 4: Line 4:


<h3>Mengatasi Error</h3>
<h3>Mengatasi Error</h3>
Mengatasi Error hostname blocked too many error flush-host
Hostname blocked too many error flush-host
  SET GLOBAL max_connect_errors = 10000000000;
  SET GLOBAL max_connect_errors = 10000000000;
atau
atau
  mysqladmin -p flush-hosts
  mysqladmin -p flush-hosts

Revision as of 05:29, 4 March 2024

Import

mysql -u username -p database_name < file.sql

Mengatasi Error

Hostname blocked too many error flush-host

SET GLOBAL max_connect_errors = 10000000000;

atau

mysqladmin -p flush-hosts