Bugzilla will be upgraded to version 5.0 on a still to be determined date in the near future. The original upgrade date has been delayed.
Bug 124772 - cannot connect to db server after setting passwd
cannot connect to db server after setting passwd
Product: Fedora
Classification: Fedora
Component: mysql (Show other bugs)
i386 Linux
medium Severity high
: ---
: ---
Assigned To: Tom Lane
Depends On:
  Show dependency treegraph
Reported: 2004-05-29 16:44 EDT by Mark Frazer
Modified: 2013-07-02 23:01 EDT (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2004-10-06 13:53:32 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Mark Frazer 2004-05-29 16:44:42 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.1) Gecko/20020827

Description of problem:
Start with a fresh fedora core 2 install.

$ mysql -u root mysql

mysql> update user set password='foo' where user='root';
Query OK, 2 rows affected (0.01 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> quit

[root@bits root]# mysql -u root -p mysql
Enter password: 
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

where the password entered was foo

I do not have this problem on Fedora Core 1.


Version-Release number of selected component (if applicable):

How reproducible:

Steps to Reproduce:
see description

Expected Results:  The root mysql user should have logged into the

Additional info:
Comment 1 Flavio Cardone 2004-06-22 03:48:52 EDT
Bug also happens to me - exactly as described
Comment 2 Mark Frazer 2004-06-22 08:51:11 EDT
I ended up just getting the latest mysql rpm's from mysql.  They
installed fine over FC2

[root@bits root]# rpm -qa | grep -i mysql
[root@bits root]# 
Comment 3 Tom Lane 2004-10-06 13:53:32 EDT
AFAICS this is not a bug, but pilot error.  The MySQL documentation
says that if you want to set the password via a direct UPDATE, you
should do it like this:

UPDATE user SET Password=PASSWORD('new_password')
    WHERE user='root';

and when I do it like that it works fine.  I presume the PASSWORD()
function is needed to munge the password into encrypted form.
Comment 4 Mark Frazer 2004-10-06 14:04:59 EDT
Ok, I guess that the mysql used in FC1 and MySQL 4 RPMS from mysql.org
have a different password interface the the FC2 mysql rpms.

I will offer this as a footnote to the bugzilla documentation.
Comment 5 Mark Frazer 2004-10-06 14:10:20 EDT
Ah, the bugzilla docs are fine.  Who knows where I decided this was
the proper syntax...  <sigh>

Sorry for the misfire.

Note You need to log in before you can comment on or make changes to this bug.