[MYSQL] CREATE GRANT PRIVILEGE MYSQL 8.X - fourslickz/notes GitHub Wiki

1. Create the user

CREATE USER 'newuser'@'%' IDENTIFIED BY 'newpassword';

2. Grant specific privileges (e.g., SELECT, INSERT, UPDATE)

GRANT SELECT, INSERT, UPDATE ON my_database.* TO 'newuser'@'%' with grant option;

3. Apply privileges

FLUSH PRIVILEGES;