Or you could do this:
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
