Bug #10257 Connecting to MySql

• Submitted: 29 Apr 2005 7:09
• Modified: 29 Apr 2005 15:00
• Reporter: Adam Darmanin
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1 (latest)
• OS: Windows (win XP)
• CPU Architecture: Any

[29 Apr 2005 7:09] Adam Darmanin

Description:
Hello I have a slightproblem connecting to mysql (using root account).  Everything works fine at first, installation and configuration (mine is running on a standalone computer).  When I connect the first time it works, but after I reset or turn off the computer and return back to work on mysql, it doesn't take mypassword anymore.

What is more strange is that when I go to the configuration and change password (by entering the old one, and confirming the new one) it works and connects back again. Only to repeat the above problem when the  machine is turned off.  And solved again when I repeat the change password problem.

Could anyone please tell me how to solve this problem.  I just want one password and to connect everytime I log in, not to pass through the config settings to change password each time.

Thanks Adam

How to repeat:
On mine it repeats everytime I reset the system or turnoff and try to log in again.  I dont know how to possible repeat it with another system.

[29 Apr 2005 15:00] MySQL Verification Team

Sorry I was unable to repeat the behavior reported. Below show you
how I changed the root password for a fresh install using the
mysqladmin client tool:

c:\mysql\bin>mysqladmin -uroot password "new_pass"

c:\mysql\bin>mysql -uroot
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

c:\mysql\bin>mysql -uroot -pnew_pass
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.1.11-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>