Tổng hợp Mysql

1. permission user

- CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
          thay localhost bởi %: host another
- FLUSH PRIVILEGES;
- GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’; : thêm quuyền
          + type: ALL PRIVILEGES, CREATE, DROP, DELETE, INSERT, SELECT, UPDATE, GRANT OPTION
  + db name, table name: * : tất cả db, tất cả table
- REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost’; :  xóa quyền
- DROP USER ‘demo’@‘localhost’; : xóa user
* Note: thêm quyền cơ bản cho user:
GRANT CREATE ON dbname.* TO 'username'@'%';
GRANT DROP ON dbname.* TO 'username'@'%';
GRANT DELETE ON dbname.* TO 'username'@'%';
GRANT INSERT ON dbname.* TO 'username'@'%';
GRANT SELECT ON dbname.* TO 'username'@'%';
GRANT UPDATE ON dbname.* TO 'username'@'%';

2. dump import

mysqldump -h127.0.0.1 -uroot -p --no-data=false --no-create-info=false --extended-insert=true --complete-insert=false --skip-tz-utc --force --add-drop-table=false --comments=false --create-options=true --dump-date=false --lock-tables=false --add-locks=false --compact=false --disable-keys=false dbname | gzip > dbfile.sql.gz

import:

mysql -u root -p --default-character-set=utf8 dbname < dbfile.sql

option

--where="colum > 1"
--no-create-info : only data
--no-data : only struct
--extended-insert=true : gop cac cau lenh insert vao lam 1
--complete-insert: add column in insert
--skip-tz-utc : ignore time zone set
--set-charset=false
--ignore-table=database.table1

3. Change password mysql:

 mysqladmin -u root password NEWPASSWORD
OR
update user set password=PASSWORD("NEWPASSWORD") where User='root';
flush privileges;

4. Tạo db với charset

create database dbname CHARACTER SET utf8 COLLATE utf8_unicode_ci;