Mysql

From Server STB
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