Hello Bernard and Michael, thanks for the hints. After following them
and being confused to hell at the fact that they wouldn't work, I
realised that I had changed the name of the MySQL admin user from root
to something else... so i couldn't log in as root and couldn't change
root's password.
It's all fixed now, thanks again
Bruce
From: Egor Egorov Date: August 23 2004 2:13pm
Subject: Re: Root password lost?; can't manage existing database...
"DBS" <[EMAIL PROTECTED]> wrote:
> I have a problem, It's been months since I used MySQL and (I believe) I had
> set it up with a root password. Now I can't log on to MySQL as root MySQL
> user and create a new user or manage an existing user (I can log onto server
Familiar situation. :)
Do so:
service mysql stop
wait until MySQL shuts down. Then run
mysqld_safe --skip-grant-tables &
then you will be able to login as root with no password.
mysql -uroot mysql
In MySQL command line prompt issue the following command:
UPDATE user SET password=PASSWORD("abcd") WHERE user="root";
FLUSH PRIVILEGES;
At this time your root password is reset to "abcd" and MySQL will now
know the privileges and you'll be able to login with your new password:
mysql -uroot -pabcd mysql
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
On 5/3/06, Bernard Li <[EMAIL PROTECTED]> wrote:
>
>
> Hi Bruce!
>
> As the "root" user, you should be able to access the MySQL database without
> any password. Once you're in you should be able to reset the password for
> the "oscar" user in the mysql.user table.
>
> Once you've re-setted the password, put it into /etc/odapw and everything
> *should* be back to normal.
>
> Cheers,
>
> Bernard
>
> ________________________________
> From: [EMAIL PROTECTED] on behalf of
> Bruce Becker
> Sent: Wed 03/05/2006 01:58
> To: OSCAR users
> Subject: [Oscar-users] How to recover from a lost DB ?
>
>
>
>
> Hello OSCAR users...
>
> I have a question regarding damage control. While performing some
> "security maintenance", *somebody* lost the mysql password on our head
> node (don't laugh, and no, it wasn't me !). My question is, what is
> the best way to rebuild the OSCAR database ? Should we drop it from
> the db and run 'install_cluster' or is there something less drastic we
> can do ?
>
> Thanks for any advice...
> Bruce
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=k&kid0709&bid&3057&dat1642
>
> _______________________________________________
> Oscar-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/oscar-users
>
>
>
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642
_______________________________________________
Oscar-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/oscar-users
