* MYSQL cygwin database connection requests root password
[not found] <2123854420.757325.1692231217070.ref@mail.yahoo.com>
@ 2023-08-17 0:13 ` HECTOR MENDEZ
2023-08-17 4:55 ` rappard
0 siblings, 1 reply; 4+ messages in thread
From: HECTOR MENDEZ @ 2023-08-17 0:13 UTC (permalink / raw)
To: cygwin
[-- Attachment #1: Type: text/plain, Size: 265 bytes --]
Hi everyone I saw that in order to connect MYSQL database on cygwin, this statement must be executed:
mysql -u root -p -h 127.0.0.1
However, as far as I know, there's no root user on cygwin.
How can I get that requested password?
Thank you in advance.
Regards
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: MYSQL cygwin database connection requests root password
2023-08-17 0:13 ` MYSQL cygwin database connection requests root password HECTOR MENDEZ
@ 2023-08-17 4:55 ` rappard
2023-08-18 22:14 ` HECTOR MENDEZ
0 siblings, 1 reply; 4+ messages in thread
From: rappard @ 2023-08-17 4:55 UTC (permalink / raw)
To: HECTOR MENDEZ; +Cc: cygwin
> Hi everyone I saw that in order to connect MYSQL database on cygwin, this statement must be executed:
> mysql -u root -p -h 127.0.0.1
> However, as far as I know, there's no root user on cygwin.
> How can I get that requested password?
Isn't "root" a MySQL username? If I recall correctly its default
password is either empty or "root".
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: MYSQL cygwin database connection requests root password
2023-08-17 4:55 ` rappard
@ 2023-08-18 22:14 ` HECTOR MENDEZ
2023-08-18 22:53 ` bzs
0 siblings, 1 reply; 4+ messages in thread
From: HECTOR MENDEZ @ 2023-08-18 22:14 UTC (permalink / raw)
To: rappard; +Cc: cygwin
[-- Attachment #1: Type: text/plain, Size: 560 bytes --]
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@dds.nl <rappard@dds.nl> escribió:
> Hi everyone I saw that in order to connect MYSQL database on cygwin, this statement must be executed:
> mysql -u root -p -h 127.0.0.1
> However, as far as I know, there's no root user on cygwin.
> How can I get that requested password?
Isn't "root" a MySQL username? If I recall correctly its default
password is either empty or "root".
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: MYSQL cygwin database connection requests root password
2023-08-18 22:14 ` HECTOR MENDEZ
@ 2023-08-18 22:53 ` bzs
0 siblings, 0 replies; 4+ messages in thread
From: bzs @ 2023-08-18 22:53 UTC (permalink / raw)
To: HECTOR MENDEZ; +Cc: rappard, cygwin
On August 18, 2023 at 22:14 cygwin@cygwin.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@dds.nl <rappard@dds.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@TheWorld.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*
^ permalink raw reply [flat|nested] 4+ messages in thread
end of thread, other threads:[~2023-08-18 22:54 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
[not found] <2123854420.757325.1692231217070.ref@mail.yahoo.com>
2023-08-17 0:13 ` MYSQL cygwin database connection requests root password HECTOR MENDEZ
2023-08-17 4:55 ` rappard
2023-08-18 22:14 ` HECTOR MENDEZ
2023-08-18 22:53 ` bzs
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).