Thursday, April 22, 2004, 9:21:35 PM, Dave Dennis wrote:
DD> Is there a procedure to follow for this exactly, step by step?
Yes.
DD> Its on a running production server, don't want to lose data.
Note:
If you run MySQL server with --skip-grant-tables option, MySQL will not use privilege
tables.
Dave Dennis <[EMAIL PROTECTED]> wrote:
> Dear MySQL list,
>
> Managed to create a problem where:
>
> mysql > use mysql;
>
> ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
>
> Need a procedure to follow / documented steps to restore root's access
> to database mysql,
Dear MySQL list,
Managed to create a problem where:
mysql > use mysql;
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
Need a procedure to follow / documented steps to restore root's access
to database mysql, version 4.0.17 .
Kind regards,
+