How do I create a MySQL user and grant them permission to a certain database?

[VelMurugan]

How do I create a MySQL user and grant them permission to a certain database?

In Telnet/Shell type: "mysql"

This will load the mysql command line. Next type:

GRANT ALL PRIVILEGES ON [database].* TO [username]@[domain] IDENTIFIED BY '[password]';

(where "[database]" is the database you created earlier, [username] is the mysql username you want, [domain] is the domain you'll be connecting from (usually 'localhost') and [password] is the password you'd like to use. Be sure it's enclosed in 's.

For example:
GRANT ALL PRIVILEGES ON mydatabase.* TO bob@localhost IDENTIFIED BY 'fruitfly';

Source : esupport

[nandagopal]

Nice code explanation, it works fine ,

Post more tutorials