Vista -- what a pain...

Jerry Stuckle wrote:
> maya wrote:
>> Jerry Stuckle wrote:
>>> maya wrote:
>>>> Jerry Stuckle wrote:
>>>>> maya wrote:
>>>>>> Rik wrote:
>>>>>>> On Sun, 05 Aug 2007 03:55:40 +0200, maya <maya778899@yahoo.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>> just as I thought, am having a hard time running MySQL on Vista
>>>>>>>> (Ultimate ed.) just downloaded mysql-5.0.45-win32.zip,
>>>>>>>> installed fine
>>>>>>>>
>>>>>>>> but at the end of config I get firewall/port error, get told I
>>>>>>>> have to add port.. I added port 3306, but still get exact same
>>>>>>>> error at the end of configuration:
>>>>>>>>
>>>>>>>> Error 1045 - Access denied for user root@localhost using pswd
>>>>>>>> YES (pswd YES?)
>>>>>>>
>>>>>>> Default setup is AFAIK root WITHOUT password....
>>>>>>
>>>>>> then why is first field in password set-up "current" password???
>>>>>> (there are a total of THREE fields when you set up pswd:
>>>>>> current, new, confirm...)
>>>>>>
>>>>>>
>>>>>> thank you...
>>>>>
>>>>> Maybe because it's a generic form? Or you may be installing over
>>>>> an older version of MySQL where you do have a password? Or maybe
>>>>> just to get people to ask stupid questions?
>>>>
>>>> I'm on a brand new machine I got about a week ago.. no previous
>>>> install of MySQL.. (what is "generic" form??)
>>>>
>>>> thank you...
>>>>
>>>
>>> Nothing to do with MySQL. It's just a form which is used generically.
>>>
>>> Just like when you sign on to Windows - it asks for a password,
>>> whether you have one set or not.
>>>
>>
>> ok, to recap: this is NOT an authentication problem, I cannot get
>> past phase where you SET password... oh brother, what a pain..
>>
>> thank you..
>>
>>
>>
>
> Yes, it is an authentication problem:
>
> >>>>> Error 1045 - Access denied for user root@localhost using pswd YES
>
> The question is, if you don't enter a password into the field, why is is
> saying "pswd YES"?

you tell me.....;)

what happens is in the config wizard is where I get that auth error,
when I'm SETTING the password.. I have to type in a "current" password,
I don't know what it is.. I created an anonymous acct, but I don't know
what the password to it is.... I have installed MySQL a number of times
before, both in Windows 2000 and XP.. I have never had this problem...

thank you...



I would think it should detect the empty field and
> not use a password.
>

maya wrote:
> Jerry Stuckle wrote:
>>
>> The question is, if you don't enter a password into the field, why is
>> is saying "pswd YES"?
>
> you tell me.....;)
>
> what happens is in the config wizard is where I get that auth error,
> when I'm SETTING the password.. I have to type in a "current" password,
> I don't know what it is.. I created an anonymous acct, but I don't know
> what the password to it is.... I have installed MySQL a number of times
> before, both in Windows 2000 and XP.. I have never had this problem...
>
> thank you...
>
>
>
> I would think it should detect the empty field and
>> not use a password.
>>

Yes, I understand what's going on.

The default password, as Rik indicated, is no password.

But maybe it's a problem with Vista saying the field actually contains
something when it doesn't. After all, that's what's different between
your failing system and thousands of other working systems.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Jerry Stuckle wrote:
> maya wrote:
>> Jerry Stuckle wrote:
>>>
>>> The question is, if you don't enter a password into the field, why is
>>> is saying "pswd YES"?
>>
>> you tell me.....;)
>>
>> what happens is in the config wizard is where I get that auth error,
>> when I'm SETTING the password.. I have to type in a "current"
>> password, I don't know what it is.. I created an anonymous acct, but I
>> don't know what the password to it is.... I have installed MySQL a
>> number of times before, both in Windows 2000 and XP.. I have never had
>> this problem...
>>
>> thank you...
>>
>>
>>
>> I would think it should detect the empty field and
>>> not use a password.
>>>
>
> Yes, I understand what's going on.
>
> The default password, as Rik indicated, is no password.
>
> But maybe it's a problem with Vista saying the field actually contains
> something when it doesn't. After all, that's what's different between
> your failing system and thousands of other working systems.
>

thank you for yr response.. ok, will try leaving 'current' pswd blank
tonight at home.. in the meantime, found this page..
http://www.idevelopment.info/data/My...ation%20Wizard
(don't know if this link will work, got it by searching in google for
"mysql config wizard" (2nd entry)

one thing I noticed in above-mentioned pg is this screenshot:
http://www.mayacove.com/misc/mysql.gif

there are only two pswd fields here, no "current"... now one thing I
noticed is in this one, http://www.mayacove.com/misc/mysql2.gif I chose
"standard" instead of "Detailed" configuration, so I guess have to try
"Detailed" configuration.. (gosh, I wish I remembered how I've done
this in the past..)

thanks again..