Error 1045: Access denied for user

Hi All,

I am a new user and have just installed MySql 4.1.3 with MySql Administrator
1.0.
Running MS XP Pro - No SP's on Pentium 4
After installation:-

- MySqlserver is running as a service ok BUT
- Trying to connect via the Administrator I get the following error message:
Error 1045: Access for user 'root'@'localhost' using password NO denied
and
Error 1045: Access for user 'root'@'localhost' using password YES denied
- trying to run from a CMD box (DOS) I get the same error message.

- I thought it might be a permissions problem: made the folder shared -
still
same error.

Anyone had a similar problem before?

TIA
Peet



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Error 1045: Access denied for user

Well, obviously is a permission problem, so, I would advice you to use
the --skip-grant-tables option to temporalily open mysql to any and
all connections, connect as root and change the password, shutdown
down the server and start it again without the option.

This way you have reset your root password. Another option would be
that you already had a "data" directory or had an old mysql password
format, well, again you can use the solution above.

Good luck

PS: Check the manual for "How to reset lost password".

On 8/16/05, Peet wrote:
> Hi All,
>=20
> I am a new user and have just installed MySql 4.1.3 with MySql Administra=
tor
> 1.0.
> Running MS XP Pro - No SP's on Pentium 4
> After installation:-
>=20
> - MySqlserver is running as a service ok BUT
> - Trying to connect via the Administrator I get the following error messa=
ge:
> Error 1045: Access for user 'root'@'localhost' using password NO denied
> and
> Error 1045: Access for user 'root'@'localhost' using password YES denie=
d
> - trying to run from a CMD box (DOS) I get the same error message.
>=20
> - I thought it might be a permissions problem: made the folder shared -
> still
> same error.
>=20
> Anyone had a similar problem before?
>=20
> TIA
> Peet
>=20
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org