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.
GRANT ALL PRIVILEGES ON mydatabase.* TO bob@localhost IDENTIFIED BY 'fruitfly';
© Duplication without permission prohibited.
Script provided by SmartCGIs.com