While trying to login to the server I got the following errors:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\>c:\mysql\bin\mysql -root -p
Enter password: *****
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)

C:\>c:\mysql\bin\mysql -root -p
Enter password: ******
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)

C:\>c:\mysql\bin\mysqlshow
c:\mysql\bin\mysqlshow: Access denied for user: '[EMAIL PROTECTED]' (Using password
: NO)

C:\>c:\mysql\bin\mysqladmin -u root password my-password-here
c:\mysql\bin\mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'

C:\>c:\mysql\bin\mysqladmin -u root -h fayec password my-password-here
c:\mysql\bin\mysqladmin: connect to server at 'fayec' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'


Then I started the service with:

C:\>c:\mysql\bin\mysqld-nt --skip-grant-tables

I am now trying to reset my root password but I am getting errors when
trying to do so.
I followed the instructions on:
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
but when I get to the point I have to use:

flush-privileges password "newpwd"

I get the following error:

'flush-privileges' is not recognized as an internal or external command,
operable program or batch file.

I have no clue how to go on from here....anybody?? I am trying to
login to be able to create a db but it won't let me through without a
password and it won't accept the password I had set before (pretty
sure about the old password as it is the same I use for all my local
projects).

Any tips will be extremely appreciated. Thanks in advance.

FayeC

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to