Adam.birds: Created page with "To create a MySQL user and grant privileges run the below commands:

 CREATE USER 'username'@'localhost' IDENTIFIED BY 'SuperSecurePassword';

 GRANT ALL PRIV..."

2023-03-08T19:06:42Z

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..."

New page

To create a MySQL user and grant privileges run the below commands:

<pre>
CREATE USER 'username'@'localhost' IDENTIFIED BY 'SuperSecurePassword';
</pre>

<pre>
GRANT ALL PRIVILEGES ON databasename . * TO 'username'@'localhost';
</pre>

<pre>
FLUSH PRIVILEGES;
</pre>

[[Category:MySQL]]
[[Category:Linux]]
[[Category:Contents]]

Create MySQL User And Grant Privileges - Revision history

Adam.birds: Created page with "To create a MySQL user and grant privileges run the below commands:
CREATE USER 'username'@'localhost' IDENTIFIED BY 'SuperSecurePassword';

GRANT ALL PRIV..."