Mysql: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
mysql -u username -p database_name < file.sql | mysql -u username -p database_name < file.sql | ||
<h3> | <h3>Reset Password</h3> | ||
Mengatasi Error | |||
/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 | |||
<h3>Mengatasi Error</h3> | |||
Hostname blocked too many error flush-host | |||
SET GLOBAL max_connect_errors = 10000000000; | SET GLOBAL max_connect_errors = 10000000000; | ||
atau | |||
mysqladmin -p flush-hosts | mysqladmin -p flush-hosts | ||
Latest revision as of 05:34, 4 March 2024
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