6 messages in com.mysql.lists.win32RE: root password
FromSent OnAttachments
weetat09 Nov 2005 22:13 
Jesper Hørup09 Nov 2005 23:00 
weetat09 Nov 2005 23:56 
Jesper Hørup10 Nov 2005 00:12 
Daniel da Veiga10 Nov 2005 05:16 
Daniel da Veiga10 Nov 2005 05:25 
Subject:RE: root password
From:Jesper Hørup (JH@rtx.dk)
Date:11/09/2005 11:00:18 PM
List:com.mysql.lists.win32

Stop the current service: net stop mysql (or whatever your service name are)

start the mysql deamon with the --skip-grant-tables C:\mysql\mysql-4.1.2-alpha\bin>mysqld[-nt].exe --skip-grant-tables --console

Now you should be able to connect and change the root pw.

stop the deamon.

Start the service again net start mysql (or whatever your service name are)

This guide only works if you really have forgotten the pw - if you are trying to
hack your way into the database, it wont't work ;)

/jesper

-----Original Message----- From: news [mailto:ne@sea.gmane.org]On Behalf Of weetat Sent: 10. november 2005 07:14 To: win@lists.mysql.com Subject: root password

Hi all ,

I am using mysql-4.1.2 database server . Everything are ok except i have forget my "root" password for mysql database. see below . How to reset my root password ?

C:\mysql\mysql-4.1.2-alpha\bin>mysql mysql -u root -p Enter password: ********** ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: YES)

Thanks

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=jh@rtx.dk