From owner-freebsd-questions@FreeBSD.ORG Tue Jun 7 01:46:39 2005 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 3F74816A41C for ; Tue, 7 Jun 2005 01:46:39 +0000 (GMT) (envelope-from sarath@linuxtechs.net) Received: from venus.mediacatch.com (ns13.mediacatch.com [216.27.201.20]) by mx1.FreeBSD.org (Postfix) with ESMTP id DCC9543D1D for ; Tue, 7 Jun 2005 01:46:38 +0000 (GMT) (envelope-from sarath@linuxtechs.net) Received: from [202.83.55.7] (helo=[202.83.55.7]) by venus.mediacatch.com with esmtpa (Exim 4.50) id 1DfTAr-00068z-33; Mon, 06 Jun 2005 21:46:50 -0400 Message-ID: <42A4FC2D.2000703@linuxtechs.net> Date: Mon, 06 Jun 2005 18:45:17 -0700 From: Sarath ER User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: John Andrews References: <21254E0482266244B6BE9186181F8A5E0277B9CA@corsxc0001> In-Reply-To: <21254E0482266244B6BE9186181F8A5E0277B9CA@corsxc0001> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - venus.mediacatch.com X-AntiAbuse: Original Domain - freebsd.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - linuxtechs.net X-Source: X-Source-Args: X-Source-Dir: Cc: freebsd-questions@freebsd.org Subject: Re: re-setting root password for MYSQL win 2003 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 07 Jun 2005 01:46:39 -0000 John Andrews wrote: >in order to access the MYSQL control centre and MYSQL administrator I >need to be able to re-set the root userpassword, can someone please >advise on how this is done in win2003 server > >admin tools/computer management/ local users and groups does not >disclose the MYSQL root user >see print screen. > >TIA > >john > > This is the wrong place to ask for a windows qn. Anyways here it is. The procedure under Windows: 1. Log on to your system as Administrator. 2. Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager: Start Menu -> Control Panel -> Administrative Tools -> Services Then find the MySQL service in the list, and stop it. If your server is not running as a service, you may need to use the Task Manager to force it to stop. 3. Create a text file and place the following command within it on a single line: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword'); Save the file with any name. For this example the file will be |C:\mysql-init.txt|. 4. Open a console window to get to the DOS command prompt: Start Menu -> Run -> cmd 5. We are assuming that you installed MySQL to |C:\mysql|. If you installed MySQL to another location, adjust the following commands accordingly. At the DOS command prompt, execute this command: C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt The contents of the file named by the |--init-file| option are executed at server startup, changing the |root| password. After the server has started successfully, you should delete |C:\mysql-init.txt|. Users of MySQL 4.1 and higher who install MySQL using the MySQL Installation Wizard may need to specify a |--defaults-file| option: C:\> C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" --init-file=C:\mysql-init.txt The appropriate |--defaults-file| setting can be found using the Services Manager: Start Menu -> Control Panel -> Administrative Tools -> Services Find the MySQL service in the list, right-click on it, and choose the |Properties| option. The |Path to executable| field contains the |--defaults-file| setting. 6. Stop the MySQL server, then restart it in normal mode again. If you run the server as a service, start it from the Windows Services window. If you start the server manually, use whatever command you normally use. 7. You should be able to connect using the new password.