Hi have you looked at GRANT
http://www.mysql.com/doc/en/GRANT.html I think it is what you are looking for Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 ----------------------------------------------- -----Original Message----- From: Chris Walcott [mailto:cwalcott@;macromedia.com] Sent: 14 November 2002 19:25 To: Mysql-L (E-mail) Subject: assigning a user/passwd to a database How do I set a username/passwd to a specific database for authentication? I know how to create users but I can't find anything in the docs about how to password protect a database that is publicly available. I'm using mysql with ColdFusion and one of the things you are aupposed to supply when binding a database to CF is a username and password - chris --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php