MySQL common statements

1. Add a user
Grant all privileges on *. * To 'root' @ '%' identified by 'Password' with grant option;
Flush privileges;

2. remote connection
Use MySQL;
Update user set host = '%' where user = 'root ';

 

3.

Mysql-u root MySQL Mysql> Update user SET Password = PASSWORD ('newpwd ') -> Where user = 'root '; Mysql> flush privileges; // This sentence is required to take effect

4.

Index creation:
Mysql> alter table table name add index (field );
Mysql> alter table table name add primary key (field );
Mysql> show columns from table name;
Except index:
Mysql> alter table Table Name drop index field;
Mysql> alter table Table Name drop primary key field;
Mysql> show columns from table name; 5. Back up MySQL \ bin> mysqldump-u root-proot orapp> back. SQL