MySQL常用命令

启动服务器： mysqld_safe &

停止服务器： mysqladmin -u username -p password shutdown

登录：mysql -uusername -ppassword databasename

显示所有数据库：mysql>show databases;

创建数据库：mysql>create database databasename;

进入数据库：mysql>use databasename;

删除数据库：mysql>drop database databasename;

修改密码：

mysqladmin -u username password newpassword

数据库导出导入

导出：mysqldump -uusername -ppassword databasename > database.sql

导入：mysql -uusername -ppassword databasename < database.sql// 导入的目标数据库必须事先存在

批量执行SQL

You can also run mysql in batch mode. To do this, put the commands you want to run in a file, then tellmysql to read its input from the file:

shell> mysql < batch-file

If you are running mysql under Windows and have some special characters in the file that cause problems, you can do this:

C:\> mysql -e "source batch-file"

If you need to specify connection parameters on the command line, the command might look like this:

shell> mysql -h host -u user -p < batch-file
Enter password: ********