Re: Really dumb question Part II - Iikka Meriläinen - com.mysql.lists.win32

9 messages in com.mysql.lists.win32Re: Really dumb question Part II

From	Sent On	Attachments
BALAMWW	24 Jul 2002 04:39
David Siebert	26 Jul 2002 14:20
Gerald R. Jensen	27 Jul 2002 16:52
Marvin Cummings	27 Jul 2002 16:58
Paul DuBois	27 Jul 2002 18:39
David Siebert	29 Jul 2002 12:25
Iikka Meriläinen	29 Jul 2002 12:33
leo g. divinagracia iii	29 Jul 2002 15:28
Dave Watkinson	29 Jul 2002 15:40

Subject:	Re: Really dumb question Part II
From:	Iikka Meriläinen (Iikk...@pato.vaala.fi)
Date:	07/29/2002 12:33:51 PM
List:	com.mysql.lists.win32

Hello David,

I think you should start your mysqld with --skip-grant-tables command-line parameter and re-set your root password that way. Remember to set the host field correctly.

Regards Iikka

On Mon, 29 Jul 2002, David Siebert wrote:

The follow up to the really dumb question is when I do this or use the gui front end I get this error message.

1045 - Access denied for user: 'root@localhost' (Using password: NO)

All I did was an install. Any suggestions?

-----Original Message----- From: Paul DuBois [mailto:pa...@snake.net] Sent: Saturday, July 27, 2002 9:40 PM To: David Siebert; win...@lists.mysql.com Subject: Re: Really dumb question

At 17:21 -0400 7/26/02, David Siebert wrote:

What the heck is the default password for mysql. I just did an install on my XP machine and cna not find it anywhere.

There isn't one. You should be able to connect without one. For example, assuming the server is running, you should be able to connect like this:

mysql -h localhost -u root mysql -h 127.0.0.1 -u root mysql -h . -u root (only for servers that support named pipes)