Create MySQL User And Grant Privileges
Revision as of 19:06, 8 March 2023 by Adam.birds (talk | contribs) (Created page with "To create a MySQL user and grant privileges run the below commands: <pre> CREATE USER 'username'@'localhost' IDENTIFIED BY 'SuperSecurePassword'; </pre> <pre> GRANT ALL PRIV...")
To create a MySQL user and grant privileges run the below commands:
CREATE USER 'username'@'localhost' IDENTIFIED BY 'SuperSecurePassword';
GRANT ALL PRIVILEGES ON databasename . * TO 'username'@'localhost';
FLUSH PRIVILEGES;
