Match word(s).

 Support -> F.A.Q Index
 

Frequently Asked Questions

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


Review our Terms & Conditions & privacy policy
© Copyright 2002 Cyber Solution ®,  All rights reserved.


Script provided by SmartCGIs.com