Basic MySQL administrative commands, for creation of users

[salmon2k]

Dear fellow readers,

Could someone please shed some light as for the basic user creation, user names displaying, user deletion for MySQL. Would someone please advise on a good FAQ for MySQL beginners?

Your help and feedback will be much appreciated.

Ivan
[email protected]

[Kieran]

Dear Ivan.

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-mysql-command-beginners-6212/

http://www.gieson.com/school/mysql/index.html

http://www.linuxarticles.org/2011/06/mysql-%E2%80%93-basic-commands-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/