Hi,
My opinion is :
- open the "mysql" client;select the system mysql database with "use
mysql" and update the
users table with next SQL statement :
"update user set Password=PASSWORD('your_new_password') where
user='root' and Host='%';
and to make active this change you can do:
"flush privileges;"
Gelu
____________________________________________________________________
G.NET SOFTWARE COMPANY
----- Original Message -----
From: DL Neil <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 25, 2002 10:23 AM
Subject: Re: Changing root access on MySQL
> Hi Jim,
> >
> > Please forgive the elementary question but I am new to MySQL and DBs in
> > general.
> >
> > I have inherited a MySQL DB to which the root password is not available,
I
> > have read the documentation on the subject but my best efforts have
failed
> > to elicit the desired result from MySQL.
> >
> > Could some one out there please tell me what I am missing or what form
of
> > advanced muppetry I can committing with the information below.
> >
> > I can stop the sever without any difficulty using the instructions, next
I
> > restart the server with;
> >
> > # /usr/bin/safe_mysql --skip-grant-tables &
> >
> > the response to which is;
> >
> > [2] 7494
> > [1] Done /usr/bin/safe_mysql --skip-grant-tables
> > # starting mysqld daemon from /var/lib/mysql
> >
> > Then I use mysqladmin command thus;
> >
> > # mysqladmin -h localhost -u root password 'new_password'
> >
> > The response to which is;
> >
> > mysqladmin: unable to change password; error: 'You must have privileges
to
> > update tables in the mysql database to be able to change passwords for
> > others'
> >
> > AFAIK my syntax seems correct but knowing so little about MySQL at this
> > point I confess to being stuck. Thanks to anyone willing to help me out
in
> > advance.
>
>
> No one seems to have (publicly) replied to you.
> RTFM: A.4.2 How to Reset a Forgotten Password
>
> Regards,
> =dn
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
