Match word(s).

Home : Customer Support Center : FAQ Index

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';

Duplication without permission prohibited.

Script provided by SmartCGIs.com