Did you FLUSH the permissions? (aka, reload the server, in phpMyAdmin) Matthew Walker Senior Software Engineer ePliant Marketing
-----Original Message----- From: Mark Roberts [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 14, 2002 5:31 PM To: [EMAIL PROTECTED] Subject: Question about grants/priviledges I created a database named: rcs I then granted access as such: grant all on rcs.* to rcs@localhost identified by 'password' with grant option; I then tried to run an sql file as such: ./mysql -h localhost -u rcs rcs -p < database_schema.sql Then I get the following error message: [robert@server73 bin]$ ./mysql -h localhost -u rcs rcs -p < database_schema.sql Enter password: ERROR 1045: Access denied for user: 'rcs@localhost' (Using passw ord: YES) Why would I be getting this error. I have gotten this before on other instances of trying to do the same thing and ended up just finding another way to do it. But, I would really like to solve it. Suggestions as to what might be wrong? Mark Roberts, Roberts Computing Systems eCommerce, Yeah, we do that! Graphics, Scripting, Databases, Shopping Carts mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.345 / Virus Database: 193 - Release Date: 4/9/2002 --------------------------------------------------------------------- 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
