mysqldump -u root -p test_db > test_db.sql

# 導(dǎo)出所有數(shù)據(jù)庫
mysqldump -u root -p –all-databases > mysql_all.sql 

mysqldump -u root -p test_db test1 > test_test1.sql

mysqldump -u root -p -d --add-drop-table test_db > test.sql 

mysql -u root -p

mysql>source wcnc_db.sql 

mysqldump -u username -p dbname < filename.sql 

mysql -u username -p -D dbname < filename.sql 

mysql -uroot -p //進(jìn)入mysql控制臺(tái)  
mysql -uroot -p password //進(jìn)入mysql控制臺(tái)  
mysql -p //進(jìn)入mysql控制臺(tái) 

# 第一種
quit
# 第二種
exit

mysql> create database [數(shù)據(jù)庫名]; 

mysql> show databases; 

mysql> drop database [數(shù)據(jù)庫名]; 

mysql> use [數(shù)據(jù)庫名]; 

mysql> select database(); 

mysql> show tables;

mysql> show variables like '%char%';

mysql> create table [表名] (
	id varchar(20),
	name varchar(20)
); 

mysql> desc test;  
mysql> show columns from test;  
mysql> describe test;  
mysql> show create table test;  

mysql> drop table [表名]; 

mysql> insert into [表名] values ("001","張三"); 

# 查看表test中所有數(shù)據(jù)
mysql> select * from test; 

# 查找test表中id=001內(nèi)容
mysql > select * from test where id=001; 

# 查找test表中已id為0開頭的內(nèi)容
mysql > select * from test where id like "0%"; 

# 查看表test中前2行數(shù)據(jù)
mysql> select * from test order by id limit 0,2; 
# 或者
mysql> select * from test limit 0,2;

mysql> delete from test where id=001;

mysql> update test set name='admin' where id=002;

# 修改test表中name字段的長度
mysql> alter table test modify column name varchar(30);

# 在表test中添加了一個(gè)字段passtest，類型為int(4)，默認(rèn)值為0
mysql> alter table test add passtest int(4) default '0';

# 在表test名字更改為test1
mysql> rename table test to test1;

mysql> use mysql;  
mysql> update mysql.user set password='新密碼' where user='用戶名';  
mysql> flush privileges;  
mysql> set password for 用戶名@localhost=password('你的密碼');  
mysql> flush privileges; 

# 增加一個(gè)test用戶，密碼為1234
mysql> insert into mysql.user(Host,User,Password) values("localhost","test",password("1234"));  
mysql> flush privileges;

# 刪除test用戶
mysql> delete from user where user='test' and host='localhost';  
mysql> flush privileges;

# 授權(quán)test用戶擁有test_db庫的所有權(quán)限
grant all on test_db.* to test@localhost identified by '123456';

# 授權(quán)test用戶擁有test_db庫的select,update權(quán)限
grant select,update on test_db.* to test@localhost;

# 加讀鎖
mysql> flush tables with read lock;

# 解鎖
mysql> unlock tables;

mysql > select user();

service mysqld stop  
/usr/local/mysql/bin/mysqld_safe –user=mysql –skip-grant-tables &  

mysql> use mysql;  
mysql> update user set password=password('123456') where user='root';  
mysql> flush privileges;

# 查看當(dāng)前使用的存儲(chǔ)引擎
mysql > show engines;

# 查看mysql默認(rèn)存儲(chǔ)引擎
mysql> show variables like '%storage_engine%';

# 查看mysql系統(tǒng)版本
mysql> select version();

# 查看mysql庫里所有表
mysql>show tables from mysql;

# 查看Mysql端口
mysql>show variables like 'port';

# 查看mysql庫user表中user、host信息
mysql> select user,host from mysql.user;