Johannes Skov Frandsen schrieb:
> Hi
>
> For reasons unknown my mysql db has decide to lock me out and I can't
> access it with my root account anymore from the shell.
>
> I have tried resetting it following this guide:
> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
>
> but
Johannes Skov Frandsen schrieb:
> Hi
>
> For reasons unknown my mysql db has decide to lock me out and I can't
> access it with my root account anymore from the shell.
>
> I have tried resetting it following this guide:
> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
>
> but
Hi
For reasons unknown my mysql db has decide to lock me out and I can't
access it with my root account anymore from the shell.
I have tried resetting it following this guide:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
but it doesn't seem to do the trick.
I just get
Jerry Swanson schrieb:
How to reset mysql password to mysql?
mysql -u root
ERROR 1045 (0): Access denied for user: '[EMAIL PROTECTED]' (Using
password: NO)
You could start your mysqld with "--*without-grant-tables"* option. But
keep in mind that this will
stop the complete permission
- Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
From: Jerry Swanson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 23 November 2005 12:19 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: Re: Reset root password to mysql?
Hot to
Wednesday, 23 November 2005 12:11 PM
> To: mysql@lists.mysql.com
> Subject: Reset root password to mysql?
>
> How to reset mysql password to mysql?
>
>
> mysql -u root
> ERROR 1045 (0): Access denied for user: '[EMAIL PROTECTED]' (Using
> password: NO)
>
-Original Message-
From: Jerry Swanson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 23 November 2005 12:11 PM
To: mysql@lists.mysql.com
Subject: Reset root password to mysql?
How to reset mysql password to mysql?
mysql -u root
ERROR 1045 (0): Access denied for user: '[EMAIL PROT
How to reset mysql password to mysql?
mysql -u root
ERROR 1045 (0): Access denied for user: '[EMAIL PROTECTED]' (Using
password: NO)
Following the manual at http://www.mysql.com/doc/R/e/Resetting_permissions.html, I
still get the following error:
# mysqladmin -h 127.0.0.1 -u root password 'newpass'
mysqladmin: unable to change password; error: 'You must have privileges to update
tables in the mysql database to be able to cha
