Michael
FayeC SQL wrote:
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)
-root doesn't mean anything, so this is trying to log in as the default
user, [EMAIL PROTECTED] What you need is
C:\c:\mysql\bin\mysql -u root -p
C:\c:\mysql\bin\mysqlshow
c:\mysql\bin\mysqlshow: Access denied for user: '[EMAIL PROTECTED]' (Using password
: NO)
Same here. Should be C:\c:\mysql\bin\mysqlshow -u root -p
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)'
[EMAIL PROTECTED] already has a password, so you can't change it without
authenticating. Try
C:\c:\mysql\bin\mysqladmin -u root -p password my-password-here
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)'
Here you change your connection method, but you still didn't give the
password. You need -p (and [EMAIL PROTECTED] would have to be an
authorized user).
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 believe you've been bitten by bad formatting in the manual. The command
should be
C:\mysql\bin\mysqladmin -u root flush-privileges password newpwd
I have no clue how to go on from hereanybody?? 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
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]