This is how to create a MySQL database, username and password from the command line:
1: Login to MySQL ( you will need an account )
user@yourhost ~ mysql -u mysql_user -p
2: Create Database
mysql > create database db_name;
3: Create User
mysql > create user db_user;
4: Grant privileges and assigning password
mysql > grant all on db_name.* to 'db_user'@'localhost' identified by 'db_password';
If you don't want to grants all privileges and you want to limit privileges to select, insert, and delete :
mysql > grant select, insert, delete on db_name.* to 'db_user'@'localhost' identified by 'db_password';
5: If you want to delete the user (in case you made a mistake)
GRANT USAGE ON *.* TO 'db_user'@'localhost'; DROP USER 'db_user'@'localhost';
And the database
DROP DATABASE db_name;