Bug #9169 Poblem to set root password
Submitted: 14 Mar 2005 16:02 Modified: 5 Apr 2005 5:15
Reporter: Julio Noce Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:4.1.8 OS:MacOS (MacOSX 10.3.8)
Assigned to: CPU Architecture:Any

[14 Mar 2005 16:02] Julio Noce
Description:
When the root password is set, I loose access to mysql.
In order to be able to connect to mysql, I have to remove the root password.
If I set the root password and I create other users, none of them have access to any mysql database. As soon as I remove the root password, everything works again.
It drove me crazy this behaviour.

I installed MYSQL in the directory HD/usr/local

I never had this problem before upgrading to MacOSX 10.3.8 and MySQL 4.1.8

How to repeat:
set root password and everything locks

Suggested fix:
no idea
[5 Apr 2005 5:09] Lachlan Mulcahy
Could not reproduce following these steps on Mac OSX 10.3.8 / MySQL 4.1.8.

shell> sudo su -
shell> passwd root
....set the root password
shell> exit
shell> sudo mysqladmin shutdown
shell> sudo mysqld_safe --user=mysql &
shell> mysql
[5 Apr 2005 5:15] Lachlan Mulcahy
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.
[5 Apr 2005 13:34] Julio Noce
To reproduce the error try to install the WebServerXKit.
I realized that: MySQL 4.1.8 installed by itself is ok. Installed via WebServerXKit, it originates the problem.