-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Distortal Sent: Wednesday, July 16, 2003 1:50 AM To: [EMAIL PROTECTED] Subject: RE: [cobalt-developers] Creating MySQL Database from PHP
> How do I set permissions to access a database? ----- mysql> grant all on database.* to username@'ip address or hostname' identified by 'password'; We usually run something like this: create database database_name; grant all on database_name.* to [EMAIL PROTECTED] identified by 'password'; grant all on database_name.* to username@'192.168.0.%' identified by 'password'; The last statement lets the user connect to the database from any IP address on the 192.168.0 subnet (192.168.0.x.) Much more information is available at the MySQL website. Also, Paul Dubois' book "MySQL" has great information regarding GRANT statements and what you can do with them. HTH, Erica Douglass Lead Web Developer Simpli, Inc. Web Hosting http://www.simpli.biz -- Simpli is now offering dedicated RaQ4s and dedicated RaQ550s starting at $79/month... including a 100% Network Uptime Guarantee! Colocation and virtual hosting also available. See www.simpli.biz for details. -- _______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
