Command to create/delete db, db user and assigning privileges and map them to cpanel.

Command to create db, db user and assigning privileges and map them to cpanel.

mysql> CREATE DATABASE dummy_man1;

mysql> CREATE USER dummy_man1;

root@cpanel [~]# /usr/local/cpanel/bin/dbmaptool dummy –type mysql –dbs ‘dummy_man1’;

root@cpanel [~]# /usr/local/cpanel/bin/dbmaptool dummy –type mysql –dbusers ‘dummy_man1’

mysql> grant all privileges on dummy_man1.* to dummy_man1@localhost identified by ‘test123$’;

mysql> flush privileges;

mysql> \q

——————————————
Command to delete a db, db user :

mysql> DROP DATABASE DatabaseName;

mysql> DROP USER DatabaseUserName;

mysql> \q