几条常用的Mysql命令
Thursday, 14. June 2007, 02:57:59
建库
create database `mydb` default character set utf8 collate utf8_general_ci;
grant all privileges on mydb.* to mydb_user@'localhost' identified by "mydb_pass";
grant all privileges on mydb.* to mydb_user@'%' identified by "mydb_pass";
设置密码
set password for 'root'@'localhost' = old_password('root_pass');
set password for 'mydb_user'@'localhost' = old_password('mydb_pass');
set password for 'mydb_user'@'%' = old_password('mydb_pass');
备份
# mysqldump --default-character-set=utf8 -uroot --all-databses > alldb_dump.sql
# mysqldump -u mydb_user -p mydb_pass --compact --default-character-set=utf8 mydb > mydb_dump.sql
恢复
# mysql -u root -p --default-character-set=utf8 < alldb_dump.sql
# mysql -u mydb_user -p --default-character-set=utf8 mydb < mydb_dump.sql
create database `mydb` default character set utf8 collate utf8_general_ci;
grant all privileges on mydb.* to mydb_user@'localhost' identified by "mydb_pass";
grant all privileges on mydb.* to mydb_user@'%' identified by "mydb_pass";
设置密码
set password for 'root'@'localhost' = old_password('root_pass');
set password for 'mydb_user'@'localhost' = old_password('mydb_pass');
set password for 'mydb_user'@'%' = old_password('mydb_pass');
备份
# mysqldump --default-character-set=utf8 -uroot --all-databses > alldb_dump.sql
# mysqldump -u mydb_user -p mydb_pass --compact --default-character-set=utf8 mydb > mydb_dump.sql
恢复
# mysql -u root -p --default-character-set=utf8 < alldb_dump.sql
# mysql -u mydb_user -p --default-character-set=utf8 mydb < mydb_dump.sql
WIDGETIZE