Skip to content

Instantly share code, notes, and snippets.

@deevis

deevis/create_mysql_db_and_user.sql

Last active June 4, 2023 01:40
Show Gist options
  • Save deevis/f45d695f96f15293063d7e0620677661 to your computer and use it in GitHub Desktop.
Save deevis/f45d695f96f15293063d7e0620677661 to your computer and use it in GitHub Desktop.
Download ZIP
New MySQL (MariaDB) Schema/User
Raw
create_mysql_db_and_user.sql
create database prisoners;
CREATE USER 'prisoners'@'%' IDENTIFIED BY '???????????';
GRANT ALL PRIVILEGES ON prisoners.* TO 'prisoners'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment