入门MySQL数据库导入与导出及重置root密码

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

CREATE DATABASE newdatabase; 

mysql -u [username] -p newdatabase With that, your chosen database has been imported into your destination database in MySQL.  
How to Reset a Root Password
When you first install MySQL, you have to set up your root password. However, should you forget it at any point, you can still recover it.  
Step One—Shut Down MySQL
In terminal, stop the MySQL process
 /etc/init.d/mysql stop
Step Two—Access MySQL Safe Mode
In safe mode, you will be able to make changes within the MySQL system with a root password alone, without the need for MySQL root password.
sudo mysqld_safe --skip-grant-tables & Once safe mode has started up, log into MySQL and when prompted, use your standard root password.
mysql -u root mysql
Step Three—Set Up a New Password
Finally, set up the new MySQL root password by typing the command below. Replace "newpassword" with the password of your choice.
update user set password=PASSWORD("newpassword") where User='root'; Be sure to reload everything:
 FLUSH PRIVILEGES; and you now have a new root password.
By Etel Sverdlov

 /etc/init.d/mysql stop

sudo mysqld_safe --skip-grant-tables & 

mysql -u root mysql

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

 FLUSH PRIVILEGES;