Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Craig Jensen on July 10, 2002, 08:16:02 PM

Title: Broken Mysql after Cacti install
Post by: Craig Jensen on July 10, 2002, 08:16:02 PM
I followed: ftp://ftp.e-smith.net/pub/e-smith/contrib/SassouEfoeBoris/cacti.html  
to install cacti.  Worked fine....except.  Now all my other databases are inaccessible!  It appears to have 'broken' my root password.

Specifically the mysql part of the cacti setup is:
######################clip###########################################
STEP 4: Create the mysql Database

shell> mysqladmin create cacti  

--------------------------------------------------------------------------------

STEP 5: Import the default cacti database

shell> mysql cacti < /opt/administration/cacti/cacti.sql
   
--------------------------------------------------------------------------------

STEP 6: Create a MySQL username and password for cacti

shell> mysql --user=root mysql
mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'cactiuser';
mysql> flush privileges;

####################end-clip#########################################

I followed the above and now when I run 'mysql --user=root -p'

the password which allows acces is now 'root'!!!!!

What did/can I do?

Craig
Title: Re: Broken Mysql after Cacti install
Post by: Craig Jensen on July 10, 2002, 11:40:13 PM
Fixed....what a pain in the A**!!  That is time #2 for me!  Anyway, all is well and I now have a fix for my *goof* (at least 'this' one).   Life goes on, and my e-smith keeps hummin' away...


:-)

Craig