How To Import and Export Databases and Reset a Root Password in MySQL

How to Import and Export Databases

Export

mysqldump -u [username] -p [database name] > [database name].sql

Import

CREATE DATABASE newdatabase;

mysql -u [username] -p newdatabase < [database name].sql

How to Reset a Root Password

Step One—Shut Down MySQL

 /etc/init.d/mysql stop

Step Two—Access MySQL Safe Mode

sudo mysqld_safe --skip-grant-tables &

mysql -u root mysql

Step Three—Set Up a New Password

update user set password=PASSWORD("newpassword") where User='root';

 FLUSH PRIVILEGES;