Skip to content

Instantly share code, notes, and snippets.

@isaaclw

isaaclw/mysql_add_user.sql

Last active February 11, 2020 14:14
Show Gist options
  • Save isaaclw/741d174f31c82f88a14daa2e9ad4cf77 to your computer and use it in GitHub Desktop.
Save isaaclw/741d174f31c82f88a14daa2e9ad4cf77 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL add user
Raw
mysql_add_user.sql
CREATE DATABASE matomo_db_name_here;
CREATE USER 'matomo'@'localhost' IDENTIFIED BY 'my-strong-password-here';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON matomo_db_name_here.* TO 'matomo'@'localhost';
flush privileges;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment