flush privileges;
1.修改ROOT密碼:
alter user 'root'@'localhost' identified by '123';
2.取消密碼複雜要求:
set global validate_password_policy=0;
3.檢視密碼長度:
select @@validate_password_length;
4.檢視mysql目前有哪些使用者:
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
4.1檢視使用者權限.
show grants from user;
5.鎖表:
flush tables with read lock;
6.解表:
unlock tables;
7.檢視鎖表時間
show variables like '%timeout%';
8.建立使用者方式:
grant all privileges on 庫名.* to admin@'%' identified by '123456'; (授權庫)
CREATE USER 'username'@'host' IDENTIFIED BY 'password'; (單建立使用者)
9.建立主從賬号(在主資料庫建立)
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%' IDENTIFIED BY 'password';
9.1.主庫查詢目前master的bin-log
show matser status;
10.從庫連接配接主庫方式:
CHANGE MASTER TO
MASTER_HOST='主庫IP',
MASTER_PORT=3306,
MASTER_USER='repl',
MASTER_PASSWORD='主庫建立的密碼',
MASTER_LOG_FILE='mysql-bin.000002',
MASTER_LOG_POS=154;
11.啟用mysql賬号遠端連接配接
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "youpassword" WITH GRANT OPTION;
12.收回賬号權限
revoke select on dbname.* from username;
revoke all privileges on dbname[.tbname] from username;
privileges包括:
alter:修改資料庫的表
create:建立新的資料庫或表
delete:删除表資料
drop:删除資料庫/表
index:建立/删除索引
insert:添加表資料
select:查詢表資料
update:更新表資料
all:允許任何操作
usage:隻允許登入
13. 建立mysql庫
create database mobile DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
14.删除使用者
15.删除庫:
drop database dbname;
本文轉自 一招拜師 51CTO部落格,原文連結:http://blog.51cto.com/sadoc/1965227