GRANT Privileges

Giriş

Bazı haklar şöyle

SUPER, PROCESS, REPLICATION SLAVE, RELOAD, SELECT, SHUTDOWN

ALL PRIVILEGES ON

WITH GRANT OPTION ile verilirse yeni kullanıcı da başkasına hak verebilir.

Örnek

Şöyle yaparız

CREATE DATABASE myDB
CREATE USER ‘myUser’@’%’ IDENTIFIED BY ‘myPassword’; 
GRANT ALL PRIVILEGES ON myDB.* TO 'myUser'@'%';

ALL ON

Örnek - *.* Altındaki tüm Tablolar

Şöyle yaparız

mysql> CREATE USER vtuser@'%' IDENTIFIED BY 'pass';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL ON *.* TO vtuser@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)

SYSTEM_USER ON

Açıklaması şöyle

... SYSTEM_USER privilege, which is required to drop procedures created by other users in MySQL 8.0.23. 

Örnek

Şöyle yaparız

> GRANT SYSTEM_USER ON . TO 'user'@'host';

# check the current privileges of the user
> SHOW GRANTS FOR 'user'@'host';

SHUTDOWN

Örnek

Şöyle yaparız

mysql> GRANT SHUTDOWN ON *.* TO 'multi_admin'@'localhost' IDENTIFIED BY 'multipass';
mysql> FLUSH PRIVILEGES; -- Effective immediately