Mysql

From Server STB
Revision as of 05:34, 4 March 2024 by Admin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Import

mysql -u username -p database_name < file.sql

Reset Password

/etc/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
flush privileges;
quit
/etc/init.d/mysqld start

Mengatasi Error

Hostname blocked too many error flush-host

SET GLOBAL max_connect_errors = 10000000000;

atau

mysqladmin -p flush-hosts