Skip to content

Advice

Cheatsheet

  1. Add new user and database to Mysql

    SQL
    1
2
3
4
    Create database ‘<database>’;
CREATE USER '<user>'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON <database>.* TO <user>@‘localhost';
FLUSH PRIVILEGES;