ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES)
I'm having a problem similar to the one mentioned in the list message http://lists.mysql.com/mysql/165952 * I built, installed, and run MySQL 4.0.18 o gcc 2.95.3 on Solaris 9 * I created a user abcd and used MyPHPAdmin to give this user a password xxyyzzaa * I can login using the command-line 'mysql -u abcd' * I cannot login using the command-line ' mysql -u abcd -pxxyyzzaa' o ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) * As root I have executed 'USE mysql; SELECT USER,PASSWORD FROM USER' and have verified the password field for 'abcd' was instantiated. Can anyone inform me how to cause MySQL to use passwords? Thank you. -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness, http://www.softwoehr.com # serenity, and the peace of God. - Mark Twain
Re: Problem Installing MySQL Max
Lou Olsten wrote: I haven't figured out where to get the libstdc++ That's part of gcc usually found in /usr/local/lib or in the lib dir under the gcc installation dir. -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness, http://www.softwoehr.com # serenity, and the peace of God. - Mark Twain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES) SOLVED
I figured this out. It's the ANY setup in Privileges. Being set to allow ANY user to login without password, MySQL interestingly interprets that as even known users with passwords MUST log in without passwords. My two solutions were either to delete the ANY privileges or to create a second account for [EMAIL PROTECTED] with a password required to supplement the [EMAIL PROTECTED] with a password required. -- Jack J. Woehr# [F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness, http://www.softwoehr.com # serenity, and the peace of God. - Mark Twain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]