[solved] .8.7g failed to create Cacti database

[nomanlan]

I tried to install Cacti-0.8.7g_1.95.exe on a server that previously had Cacti 0.8.7d installed. I uninstalled the old MySQL from the Add/Remove program and removed MySQL directory as well as the "cacti" directory under inetpub\wwwroot. Then proceeded to install 0.8.7g, the install ran fine to completion but I can't bring up the Cacti login afterward. I noticed the Cacti-installer.log has the following error "error: 'Access denied for user 'root'@'localhost'".

Output folder: C:\DOCUME~1\derek\LOCALS~1\Temp\nswC.tmp
Launching MySQL x86 5.1.50 Installer...
Extract: mysql.msi... 100%
Execute: msiexec /i "C:\DOCUME~1\derek\LOCALS~1\Temp\nswC.tmp\mysql.msi" /qn USERNAME="Valued Cacti Customer"
MySQL installer exited with: 0
Configuring MySQL...
Stopping MySQL...
The MySQL service is stopping.
The MySQL service was stopped successfully.
...
...
MySQL Started
Installing Cacti DB
C:\Program Files\MySQL\MySQL Server 5.1\\bin\mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[nomanlan]

I took the same install file and ran it on a server that does not have Cacti installed before and everything went fine. Cacti came up without any problem. Any tricks on how to get rid of MySQL completely?

Output folder: C:\DOCUME~1\derek\LOCALS~1\Temp\1\nst2.tmp
Launching MySQL x86 5.1.50 Installer...
Extract: mysql.msi... 100%
Execute: msiexec /i "C:\DOCUME~1\derek\LOCALS~1\Temp\1\nst2.tmp\mysql.msi" /qn USERNAME="Valued Cacti Customer"
MySQL installer exited with: 0
Configuring MySQL...
Stopping MySQL...
The MySQL service is stopping.
The MySQL service was stopped successfully.

MySQL Stopped
Writing my.ini...
Starting MySQL...
The MySQL service is starting.
The MySQL service was started successfully.
...
MySQL Started
Installing Cacti DB
Creating Cacti DB User
Performing Cacti DB maintanance
Updating Cacti defaults...
Adding localhost Windows device

[BSOD2600]

After you removed mysql, did you reboot?
Did you purge the old mysql files it left?

[nomanlan]

Yes, I rebooted a couple of times. Finally, I got over the instal problem, I found a "mysql" directory under c:\documents and settings\all users\application data, it still has some old data files. After deleting the entire mysql directory, the install went through perfectly. So glad seeing my Cacti screen back. Thanks.

[nhutminh008]

Hi all,
I am currently using previous version with mysql database. I want to try this windows installer. the question is that Can I backup current database first and restore after completing new installation?

[BSOD2600]

Probably... but why do you want to use the installer when you already have an cacti installation? If you're trying to upgrade, then follow the upgrade instructions instead.