Dup Goto 📝

User_Management

PT2/db/mysql/admin/basic 07-31 13:46:46
To Pop
9 lines, 35 words, 281 chars Monday 2023-07-31 13:46:46
SELECT user FROM mysql.user;        # list users
SELECT user, host FROM mysql.user;

ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here'; # change password

CREATE DATABASE mrflibble;
GRANT ALL ON mrflibble.* TO `mrflibble`@`%` IDENTIFIED BY 'hexvision';