SEO

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?)

and why, when you set up password, first field is "current" password?
how am I supposed to know what "current" (or default, I suppose) pswd
is? (I tried YES, then in other two fields put new pswd, but it still
won't work..)

and why can't I set up as a service? (that option is grayed out..)

thank you..

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....

> and why, when you set up password, first field is "current" password?
> how am I supposed to know what "current" (or default, I suppose) pswd
> is? (I tried YES, then in other two fields put new pswd, but it still
> won't work..)
>
> and why can't I set up as a service? (that option is grayed out..)

No clue, WinXPx64 here.
--
Rik Wasmus

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...

On Sun, 05 Aug 2007 04:56:37 +0200, maya <maya778899@yahoo.com> 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...

I'm sorry, maybe other Windows user might enlighten you, but I'm not aware
of any 'field' for a setup in which I can enter passwords. When it comes
to 'pure' MySQL, I'm strictly a commandline user..

what does a simple 'mysql -uroot' on the commandline do?
--
Rik Wasmus

Rik wrote:
> On Sun, 05 Aug 2007 04:56:37 +0200, maya <maya778899@yahoo.com> 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...
>
> I'm sorry, maybe other Windows user might enlighten you, but I'm not
> aware of any 'field' for a setup in which I can enter passwords. When it
> comes to 'pure' MySQL, I'm strictly a commandline user..

yes, me too.. have been using MySQL on command-line client for years..
but before you get there you have to set it up in MySQL Server Instance
Config Wizard, which comes with installation...

thank you..

>
> what does a simple 'mysql -uroot' on the commandline do?

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?

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

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...

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.

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

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..

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"? I would think it should detect the empty field and
not use a password.

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