MySQL quick setup reference

MySQL quick setup reference

$ mysql -u root -p
> CREATE DATABASE some_db;
> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'clear-text-password';
> GRANT ALL PRIVILEGES ON some_db.* TO 'newuser'@'localhost';
> FLUSH PRIVILEGES;
> quit

Note: before going to production, it's always a good idea to run:

$ sudo mysql_secure_installation

This will make you review some less secure MySQL default setings