Here are some very basic commands that you will find useful for managing MySQL users and DB from the mysql CLI.
To create a user :
-------------------
CREATE USER 'test'@'localhost' IDENTIFIED BY 'password';
-------------------
To create a Database :
-------------------
create database testdb;
-------------------
To display users :
-------------------
SELECT user FROM mysql.user;
-------------------
To delete user and DB or Table :
-------------------
DELETE FROM user where user='test';
FLUSH PRIVILEGES;
-------------------
drop database testdb;
drop table testtable;
-------------------
Please refer the following thread from our forum and others for more detailed commands.
http://forums.eukhost.com/f19/basic-...eginners-6212/
http://www.gieson.com/school/mysql/index.html
http://www.linuxarticles.org/2011/06...mands-to-know/
http://www.pantz.org/software/mysql/mysqlcommands.html
The following sites have comman FAQ and references which might interest you.

https://wikis.oracle.com/display/mysql/MySQL+FAQ
http://www.mysql.com/industry/faq/
http://www.mysqlfaqs.net/
Leave a comment: