This is a ready reckoner for some of the commonly used commands for installation and maintenence of databases for wordpress:
Delete/Drop a database:
DROP DATABASE dbname;
Create a Database:
CREATE DATABASE dbname;
Create a user:
CREATE USER IF NOT EXISTS 'username'@'localhost' IDENTIFIED BY 'newpassword';
Grant privileges to user on database:
GRANT ALL ON dbname.* TO 'username'@'localhost'; FLUSH PRIVILEGES;
List database users:
use mysql; SELECT user FROM user;
Joel G Mathew, known in tech circles by the pseudonym Droidzone, is an opensource and programming enthusiast.
His favorite pastime is grappling with GNU compilers, discovering newer Linux secrets, writing scripts, hacking roms, and programs (nothing illegal), reading, blogging. and testing out the latest gadgets.
When away from the tech world, Dr Joel G. Mathew is a practising ENT Surgeon, busy with surgeries and clinical practise.