Mysql: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 2: | Line 2: | ||
mysql -u username -p database_name < file.sql | mysql -u username -p database_name < file.sql | ||
<h3>Reset Password</h3> | |||
/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> | <h3>Mengatasi Error</h3> |
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