Ubuntu下Mysql 常用指令及中文乱码问题

mysql -u username -p # 回车输入密码

mysql -u username -p passswd;

mysql -h address -u username -p # 回车输入密码

 mysql -h address -u username -p passswd;

mysql> use mysql;mysql> update user set password=PASSWORD(‘newpasswd') where user='username';mysql> flush privileges; #更新权限mysql> quit; #退出

mysql> grant select on database_name.* to user@address identified by ‘passwd'

mysql> grant select,insert,update,delete on . to root@localhost identified by 'mysql';or mysql> grant all privileges on . to root@localhost identified by 'mysql';mysql> flush privileges;

mysql> grant select,insert,update,delete on mydb.* to root@localhost identified by '';

mysql> delete from user where user='user_name' and host='address';mysql> flush privileges;mysql> drop database dbname; #删除用户的数据库

mysqldump -u user -p -A > backup_file_path

mysqldump -u user -p database_name_need_to_backup > backup_file_pathex00: export database mydbmysqldump -h localhost -u root -p mydb > ./mydb.sqlex01: export database mydb mytablemysqldump -h localhost -u root -p mydb mytable > ./mytable.sqlex02: export database mydb frameworkmysqldump -h localhost -u root -p mydb add-drop-table > ./mydb_stru.sql

mysqldump -u user -p -t database_name_need_to_backup > backup_file_path

mysqldump -u user -p -E database_name_need_to_backup > backup_file_path

mysqldump -u user -p -R database_name_need_to_backup > backup_file_path

mysql > source path_of_backup_file

mysql -u root p < path_of_backup_file

mysql> show databases;

mysql> use database_name;

mysql> show tables;

mysql> desc table_name;

 mysql> show columns from table_name;

mysql> create database database_name;

mysql> drop database database_name;

mysql> create table table_name( uid bigint(20) not null, uname varchar(20) not null);

mysql> drop table table_name;

mysql> insert into table_name(col1, col2) values(value1, value2);

mysql> update tablename set col1='value1', col2='value2' where wheredefinition;

mysql> select * from table_name where....... #(最复杂的语句)

mysql> delete from table_name where...

mysql> alert table table_name add column field1 date, add column field2 time ...

mysql> alert table table_name drop field1;

mysql> show columns from table_name;

mysql> select * from table_name limit 3; #每页只显示3行mysql> select * from table_name limit 3,4; #从查询结果的第三个开始，显示四项结果。 此处可很好的用来作分页处理。

mysql> select * from table_name order by field1, orderby field2; #多重排序

mysql> show variables like 'character%' ;

sudo vim /etc/mysql/my.cnf

character-set-server = utf8

/etc/init.d/mysql restart 或者 service mysql restart