Thank you so much! That worked. *big sigh of relief*
Erica > -----Original Message----- > From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 01, 2001 12:48 PM > To: Erica Douglass > Subject: RE: User Permissions Issue (Easy questions?) > > > > Hi, > > > > I am working with an internal database. We add a user using the > > following statements: > > > > create database name_of_database; > > > > GRANT alter, create, delete, drop, insert, select, update, index ON > > name_of_database TO username@localhost identified by > "password" with > > grant option; > > > > GRANT alter, create, delete, drop, insert, select, update, index ON > > name_of_database TO username@%.ourdomain.com identified by > "password" > > with grant option; > > > > flush privileges; > > > > First of all, the second statement gives an error message. > What is the > > correct syntax for adding user@%.ourdomain.com? > > > > Also, when logging in as the newly created user, I can't create any > > tables under the newly created database. If I go into > phpMyAdmin and > > give a "create" permission to the new user, that user gets > it on all > > databases, which I don't want. > > I didn't take the time to check this thoroughly, but try these: > > 1) Make sure you put quotation marks around both the username > and the host, e.g. > > "username"@"%.ourdomain.com" > > 2) The mistake might be in the fact that you specify > "name_of_database" rather than "name_of_database.*", i.e. > using the dot-star combination. > > Although you have clearly read the manual, the following > might give you some pointers as well: > http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_0> _0 > > Finally, > the "flush privileges" that you do is > unnecessary. This is only necessary when you fiddle with the > grant tables directly; GRANT and REVOKE automatically flush > the privileges. > > / Carsten > -- > Carsten H. Pedersen > keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- 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