Grant – Revoke – Programowanie

Przydzielanie, sprawdzanie i wycofywanie uprawnień

CREATE USER bob@'165.129.76.20' IDENTIFIED BY 'superpassword';

GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON myDb.* TO bob@'165.129.76.20'

SHOW GRANTS FOR bob@'165.129.76.20';

REVOKE ALL PRIVILEGES ON myDb.* FROM bob@'165.129.76.20';

Lista wszystkich użytkowników w systemie

SELECT user, Host FROM mysql.user;

DROP USER alice@'%';

DROP USER bob@'165.129.76.20';

Sprawdzenie hasła

# SHOW GRANTS FOR bob@'165.129.76.20';

GRANT USAGE ON *.* TO 'bob'@'165.129.76.20' IDENTIFIED BY PASSWORD '*3E26301B12AE2B8906D9F09785359751700930E8'

# SELECT PASSWORD('superpassword');
+-------------------------------------------+
| PASSWORD('superpassword')                |
+-------------------------------------------+
| *3E26301B12AE2B8906D9F09785359751700930E8 |
+-------------------------------------------+

Zmiana hasła

SET PASSWORD FOR 'bob'@'%' = PASSWORD('newpass');


# SET PASSWORD FOR bob@'165.129.76.20' = '*3E26301B12AE2B8906D9F09785359751700930E8'; # FLUSH PRIVILEGES;