From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from pcls6.std.com (pcls6.std.com [192.74.137.146]) by sourceware.org (Postfix) with ESMTPS id 963E938654AD for ; Fri, 18 Aug 2023 22:54:38 +0000 (GMT) DMARC-Filter: OpenDMARC Filter v1.4.2 sourceware.org 963E938654AD Authentication-Results: sourceware.org; dmarc=none (p=none dis=none) header.from=theworld.com Authentication-Results: sourceware.org; spf=pass smtp.mailfrom=theworld.com Received: from pcls8.std.com (pcls8.std.com [192.74.137.148]) by pcls6.std.com (8.14.5/8.14.5) with ESMTP id 37IMrx2Q000357; Fri, 18 Aug 2023 18:54:01 -0400 Received: from pcls8 (localhost [127.0.0.1]) by pcls8.std.com (8.14.5/8.14.5) with ESMTP id 37IMrsVI022934; Fri, 18 Aug 2023 18:53:54 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Message-ID: <25823.63106.199581.943306@gargle.gargle.HOWL> Date: Fri, 18 Aug 2023 18:53:54 -0400 From: bzs@theworld.com To: HECTOR MENDEZ Cc: "rappard@dds.nl" , "cygwin@cygwin.com" Subject: Re: MYSQL cygwin database connection requests root password In-Reply-To: <377865266.1746810.1692396891053@mail.yahoo.com> References: <2123854420.757325.1692231217070.ref@mail.yahoo.com> <2123854420.757325.1692231217070@mail.yahoo.com> <377865266.1746810.1692396891053@mail.yahoo.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 List-Id: On August 18, 2023 at 22:14 cygwin@cygwin.com (HECTOR MENDEZ via Cygwin= ) wrote: > =20 > Hi there, > I tried with an empty password and "root" word a password but no lu= ck, so far. > Thank you El mi=E9rcoles, 16 de agosto de 2023, 22:56:12 GMT-6, r= appard@dds.nl escribi=F3: =20 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 --=20 -Barry Shein Software Tool & Die | bzs@TheWorld.com | http://www.TheW= orld.com Purveyors to the Trade | Voice: +1 617-STD-WRLD | 800-THE-WRLD The World: Since 1989 | A Public Information Utility | *oo*