New MYSQL user & password

Posted on by

<suck-eggs> but I never remember the syntax.

mysql> CREATE USER ‘dvwa’@’localhost’ IDENTIFIED BY ‘p@ssw0rd’;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE DATABASE dvwa;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON dvwa.* TO ‘dvwa’@’localhost’;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)