Problems on XP

[ramses]

I am working whit

Windows XP
IIS 5.0
mysql 3.23.56


but every time I try to run the cacti this warning is diaplayed:
Warning: mysql_connect(): Access denied for user: 'ramses@Escaflowne_Negro.internet2.uanl.mx' (Using password: YES) in c:\inetpub\wwwroot\cacti-0.8.1\include\adodb\drivers\adodb-mysql.inc.php on line 207

Cannot connect to MySQL server on 'ESCAFLOWNE_NEGR'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.


I all ready check the server name, the data base user and everything is correct, please some one knows what is wrong.

[BChirhart]

OPen your config.php under cacti\include\ and check the following:

$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "Cacti_Server";
$database_username = "root";
$database_password = "password"; <------ This is probably your issue.

[ramses]

tks for the tip, but the problem remains, I all ready check the password and use it to star a sesion whit mysql, the password is correct, I do not know what else to do, I also check the steps in the install manual and I did everynthing as it said so I ran out of ideas, is there anything that you think I pass over?

[BChirhart]

Sorry Ramses, that's what got me past that same error message. Have you tried to change the password on the cacti database and update the config.php? Otherwise it could be a user permissions problem. Bring it back to simple basics, get it working, then lock it back up one piece at a time.

[bulek]

Try to use IP address instead of Escaflowne_Negro.internet2.uanl.mx name (maybe a problem with name resolution). Or if it is a local mysql then try ramses@localhost. Before doing this add proper users rights into mysql.

- bulek

[jcwonline]

Rameses,
Download and Install phpMyAdmin. It a visual MySQL Admin tool. It won't substitute the command-line but it will help you in visualizing what is going on with the connection to your database

Download it here:
http://www.phpmyadmin.net/