Quick and small howto, how to create a new MySQL database with an associated username and password with full access to that database.
1 2 3 4 5 |
CREATE USER 'traxuser'@'localhost' IDENTIFIED BY 'traxpassword'; create database traxdb; GRANT ALL PRIVILEGES ON traxdb . * TO ' traxuser'@'localhost |