lysender/mysql-create-user.md

Created May 23, 2025 09:00

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/lysender/dc2eafc021ef7fe6c8650c52b2344479.js"></script>
Save lysender/dc2eafc021ef7fe6c8650c52b2344479 to your computer and use it in GitHub Desktop.

Download ZIP

MySQL - create all around user for dev purposes

Raw

mysql-create-user.md

Create an all around user for MySQL for dev purposes.

CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password';
CREATE USER 'admin'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;