Nasser wrote: >it looks as though you have created the newsletter user with plain text password. mysql will >>> >compare the user password against the encrypted password and will fail.
Look at the password entry in the results below starting with 61fa.... If the password had been stored as plain text, it would show as 'testPass'. The only way I've been able to get an unencrypted password into this table (quite unintentionally, I assure you) is to update the table directly as in update user set password='testPass' where user = 'newsletter'; Of course, this was back when I was scratching my head over the same problem below... John Arnold Director, IT Web Strategies 2k3 Technologies 915.439.1660 ============================================= >Hello: > >As the root user, I created a new database and user account: >CREATE DATABASE newsletter; >GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass'; >FLUSH PRIVILEGES; > >I then tried to access the databse via the command-line client: >/usr/local/mysql/bin/mysql -u newsletter -ptestPass newsletter > >And I get this error: >ERROR 1045: Access denied for user: 'newsletter@localhost' (Using password: >YES) > >I checked that mysql has it set-up correctly in the user and db tables >by logging in as the root account. > >select * from user give me this line: >| % | newsletter | 61fa73f50740c213 | N | >N | N | N | N | N | N >| N | N | N | N | N | >N | N > >select * from db gives me this line: >| % | newsletter | newsletter | Y | Y >| Y | Y | Y | Y | N | Y >| Y | Y | > >Any ideas? Yes. See Chapter 4.3.5 of the mysql manual. "Note that we must issue GRANT statements for both monty@localhost and monty@"%". hth, Doug > >Thanks, > Neil. > >-- >Neil Aggarwal >JAMM Consulting, Inc. (972) 612-6056, http://www.JAMMConsulting.com >Custom Internet Development Websites, Ecommerce, Java, databases --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
