X-Recipient: archive-cygwin AT delorie DOT com
DKIM-Filter: OpenDKIM Filter v2.11.0 sourceware.org C3DE138319D1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cygwin.com;
	s=default; t=1692399316;
	bh=Ii+wenNmxs/PmEelzVrAGT3qUAMk0m9NF3K61dIjfp4=;
	h=Date:To:Cc:Subject:In-Reply-To:References:List-Id:
	 List-Unsubscribe:List-Archive:List-Post:List-Help:List-Subscribe:
	 From:Reply-To:From;
	b=b8M3iXGzs0ZZ3tLYfHCqhhc1oVFGBklaBWrXgzDNv5sml6fLZCCczJgtQG05eFbza
	 6sv1sgam4QjpFRknAuj+/VKC8gQKUATnDvkqFrvvLEeM0aIRc7oUQboU0ALrMs3oJI
	 UmocxGKjx+Y4bBC3yfel4AC7D2+HKlb7yMfW9PUc=
X-Original-To: cygwin AT cygwin DOT com
Delivered-To: cygwin AT cygwin DOT com
DMARC-Filter: OpenDMARC Filter v1.4.2 sourceware.org 963E938654AD
MIME-Version: 1.0
Message-ID: <25823.63106.199581.943306@gargle.gargle.HOWL>
Date: Fri, 18 Aug 2023 18:53:54 -0400
To: HECTOR MENDEZ <jmendez7019 AT yahoo DOT com DOT mx>
Cc: "rappard AT dds DOT nl" <rappard AT dds DOT nl>, "cygwin AT cygwin DOT com" <cygwin AT cygwin DOT com>
Subject: Re: MYSQL cygwin database connection requests root password
In-Reply-To: <377865266.1746810.1692396891053@mail.yahoo.com>
References: <2123854420 DOT 757325 DOT 1692231217070 DOT ref AT mail DOT yahoo DOT com>
 <2123854420 DOT 757325 DOT 1692231217070 AT mail DOT yahoo DOT com>
 <CACpHt-u9FKWo1p_cFs9Eo3EEcBXA0zhXma0o2Hi49wf+OJwM_w AT mail DOT gmail DOT com>
 <377865266 DOT 1746810 DOT 1692396891053 AT mail DOT yahoo DOT com>
X-Mailer: VM 8.2.0b under 27.2 (x86_64-pc-linux-gnu)
X-Spam-Status: No, score=-2.2 required=5.0 tests=BAYES_50, KAM_DMARC_STATUS,
 NICE_REPLY_A, RCVD_IN_DNSWL_LOW, RCVD_IN_MSPIKE_H3, RCVD_IN_MSPIKE_WL,
 SPF_HELO_PASS, SPF_PASS, TXREP autolearn=ham autolearn_force=no version=3.4.6
X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on
 server2.sourceware.org
X-BeenThere: cygwin AT cygwin DOT com
X-Mailman-Version: 2.1.29
Precedence: list
List-Id: General Cygwin discussions and problem reports <cygwin.cygwin.com>
List-Unsubscribe: <https://cygwin.com/mailman/options/cygwin>,
 <mailto:cygwin-request AT cygwin DOT com?subject=unsubscribe>
List-Archive: <https://cygwin.com/pipermail/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-request AT cygwin DOT com?subject=help>
List-Subscribe: <https://cygwin.com/mailman/listinfo/cygwin>,
 <mailto:cygwin-request AT cygwin DOT com?subject=subscribe>
From: bzs--- via Cygwin <cygwin AT cygwin DOT com>
Reply-To: bzs AT theworld DOT com
Content-Type: text/plain; charset="iso-8859-1"
Errors-To: cygwin-bounces+archive-cygwin=delorie DOT com AT cygwin DOT com
Sender: "Cygwin" <cygwin-bounces+archive-cygwin=delorie DOT com AT cygwin DOT com>
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by delorie.com id 37IMtHTS026406


On August 18, 2023 at 22:14 cygwin AT cygwin DOT com (HECTOR MENDEZ via Cygwin) wrote:
 >  
 > Hi there,
 >  I tried with an empty password and "root" word a password but no luck, so far.
 > Thank you    El miércoles, 16 de agosto de 2023, 22:56:12 GMT-6, rappard AT dds DOT nl <rappard AT dds DOT nl> escribió:  

MySQL's 'root' account and the system root account have little
relationship other than they share the same four characters in the
same order.

There are instructions in the online MySQL manual on how to recover
the MySQL root password, no doubt others have summarized, try your
favorite search engine.

But it basically amounts to:

1. Stop the MySQL server

2. Start it with a command line flag which says don't use passwords

3. Login as root via the MySQL client, it won't ask for a password

4. Set a password for that root account using the usual MySQL SET
PASSWORD command

5. Logout of the client

6. Stop the MySQL server

7. Start the MySQL the normal way, without the flag to not use
passwords

8. You are done

Here's a link to the MySQL 8.0 instructions;

  https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html

-- 
        -Barry Shein

Software Tool & Die    | bzs AT TheWorld DOT com             | http://www.TheWorld.com
Purveyors to the Trade | Voice: +1 617-STD-WRLD       | 800-THE-WRLD
The World: Since 1989  | A Public Information Utility | *oo*

-- 
Problem reports:      https://cygwin.com/problems.html
FAQ:                  https://cygwin.com/faq/
Documentation:        https://cygwin.com/docs.html
Unsubscribe info:     https://cygwin.com/ml/#unsubscribe-simple