- 论坛徽章:
- 0
|
MySQL我常用的命令
作者:周立峰
创建数据库
1.#mysql -u root -p
2.mysql> CREATE DATABASE mydb;
创建用户
mysql> GRANT ALL PRIVILEGES ON mydb.* to lfzhou
[email=lfzhou@localhost]@localhost[/email]
-> IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.01 sec)
修改口令:
shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
mysql> FLUSH PRIVILEGES;
给用户授权:
grant all on mydb.* to
[email=NewUserName@HostName]NewUserName@HostName[/email]
identified by "password" ;
grant usage on *.* to
[email=NewUserName@HostName]NewUserName@HostName[/email]
identified by "password";
grant select,insert,update on mydb.* to
[email=NewUserName@HostName]NewUserName@HostName[/email]
identified by "password";
grant update,delete on mydb.TestTable to
[email=NewUserName@HostName]NewUserName@HostName[/email]
identified by "password";
如何备份Mysql数据库
1.mysqldump -u[user] -p[password] [databasename] > [dump_name]
在将 dump_name 这个档案复制到另一台计算机上,另一台计算机上先进入mysql建立一个 database 再执行下列指令:
mysql -u[user] -p[password] [database_name]
恢复损坏的数据表
myisamchk --recover --quick tablename
看当前数据库版本:
mysql> SHOW VARIABLES;
看当前状态
mysql> SHOW STATUS;
mysql> SHOW PROCESSLIST;
mysql> SHOW GRANTS FOR
[email=root@localhost]root@localhost[/email]
;
看创建表的声明语句
mysql> SHOW CREATE TABLE t\G
mysql> SHOW CREATE TABLE d_kw_domain\G
mysql> show privileges;(This command is implemented in MySQL 4.1.0.)
忘了MySQL的管理员密码
1. mysqld_safe --skip-grant-tables&
2. mysql -uroot mysql
3. UPDATE user SET Password=PASSWORD('zhoulifeng') where user='root';
4. mysql> FLUSH PRIVILEGES;
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u2/86974/showart_1744151.html |
|