MySQL database tips

 

how to create database
mysqladmin -u root -p create joomla

how to delete user assigned for a particular database*
DELETE FROM user WHERE User='Dude3' AND Host='localhost';

how to delete permisission for particular db
DELETE FROM user WHERE User='Dude3' AND Host='localhost';

how to grant all ( permission)  to a certain database for a particular user to use this DB
 GRANT ALL ON joomla.* to 'joomla'@'localhost' IDENTIFIED BY '';

delete databse
DROP DATABASE dbname

--