insert tbl into db mysql -h localhost -u user -pPass db_kampus < db_kampus.sql dump table structure mysqldump --add-drop-table -d -h localhost -u user -pPass userdb > userdb.sql Reset Passwd sudo systemctl stop mysql sudo mysqld_safe --skip-grant-tables & mysql -u root alt 1 ALTER USER 'root'@'%' IDENTIFIED BY 'Pass'; GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON *.* TO 'root'; FLUSH PRIVILEGES; alt 2 UPDATE mysql.user SET authentication_string = PASSWORD('Pass') WHERE User = 'root' AND Host = 'localhost'; FLUSH PRIVILEGES; mysqladmin -u root -p shutdown sudo systemctl start mariadb resolve error ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) systemctl stop mysql sudo usermod -d /var/lib/mysql/ mysql systemctl start mysql resolve ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' systemctl status mysql if inactive systemctl start mysql