Skip to content

Instantly share code, notes, and snippets.

@piratecarrot

piratecarrot/gist:77ef8793c20e8ccc7f90cf900eaf8f6e

Created April 12, 2019 04:04
Show Gist options
  • Save piratecarrot/77ef8793c20e8ccc7f90cf900eaf8f6e to your computer and use it in GitHub Desktop.
Save piratecarrot/77ef8793c20e8ccc7f90cf900eaf8f6e to your computer and use it in GitHub Desktop.
Download ZIP
Create MySQL database and give privileges
Raw
gistfile1.txt
Login to the machine and run the following commands.
# sudo su
# mysql
You will now be within the MySQL client. Issue the following commands.
> CREATE DATABASE <DATABASE_NAME>;
> GRANT ALL PRIVILEGES ON <DATABASE_NAME>.* TO '<DATABASE_USERNAME>'@'localhost' IDENTIFIED BY '<DATABASE_PASSWORD>';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment