mysql create user

mysql create user

1 -- 檢視系統使用者 2 select Host,User,Password from mysql.user; 3  4 -- 建立一個遠端使用者  5 create user test identified by '123456';

6  7 -- 分配許可權  8 grant all privileges on *.* to 'test'@'%'identified by '123456' with grant option;
9 10 -- 重新整理mysql使用者許可權11 flush privileges ;
12 13 -- 修改指定使用者密碼 14 update mysql.user set password=password('新密碼') where User="test" and Host="localhost";
15 16 -- 刪除使用者 17 delete from user where User='test' and Host='localhost';

-- 檢視mysql支援字符集show variables like "% character %";

-- 建立資料庫並指定編碼create database app_relation character set utf8;

-- 修改資料庫編碼alter database app_relation character set utf8;

CREATE DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE DATABASE 的語法：
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
[create_specification [, create_specification] ...]
create_specification:
[DEFAULT] CHARACTER SET charset_name
| [DEFAULT] COLLATE collation_name

更改資料庫的字元編碼
ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci