How to dump/restore MySQL Databases

Export A MySQL Database:

mysqldump -u username -ppassword database_name > FILE.sql

Import A MySQL Database:

mysql -u username -ppassword database_name < FILE.sql

Use the --all-databases option to back up all the MySQL databases:

mysqldump -u root -p --all-databases > all_databases.sql

Update version:

https://phoenixnap.com/kb/how-to-backup-restore-a-mysql-database

Change Wordpress Password

USE database_wp;
UPDATE wp_users SET user_pass = MD5('newpassword123') WHERE user_login = 'admin';
EXIT;

mysql -u root -p database_wp < database_wp.sql