Skip to content

Instantly share code, notes, and snippets.

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.
Create MySQL database and give privileges
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