----- Original Message -----
From: Paul
To: coba-e (at mark) bluequartz.org
Sent: Thursday, October 23, 2008 2:45 PM
Subject: [coba-e:14210] mysql issues...
Guys,
Having problems with a virgin install and mysql.
For some reason that i cant work out, i cannot log in as root to mysql
database. There's no data in any of the tables being a new install, so i don't
mind loosing the whole thing.
I've tried the usual passwords (blank/root) to no avail.
I've also tried a yum remove and a yum install to no avail.
Is there any way short of reinstalling the box that i can default mysql back
to original install, with original passwords?? L
Thx
Paul
<<
Paul
Try this:
/etc/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD("thenewpassword") where User='root';
flush privileges;
quit
/etc/init.d/mysqld stop
/etc/init.d/mysqld start
----
Ken Marcus
Ecommerce Web Hosting by
Precision Web Hosting, Inc.
http://www.precisionweb.net