FATAL: Cannot connect to MySQL server on 'localhost'...

[swiftguy121]

Hello All,

Trying to install cacti on fedora 10. I installed the cacti using 'yum install cacti'.

It did install cacti but i could not see cacti in the default document root folder (i.e var/www/html)

Again I downloaded 'cacti-0.8e.tar.gz' and installed in /var/www/html

executed the following set of commands from console


Configure MySQL
groupadd cacti
useradd -g cacti cactyuser
mysql
mysql> set password for root@localhost=password('password');
mysql> create database cactidb;
mysql> grant all on cactidb.* to root;
mysql> grant all on cactidb.* to root@localhost;
mysql> grant all on cactidb.* to cactyuser;
mysql> grant all on cactidb.* to cactyuser@localhost;
mysql> set password for cactyuser@localhost=password('password');
mysql> exit

• mysql --user=root -p cactidb < cacti.sql
• chown -R cactyuser rra/ log/


I also changed the DB config details in global.php and config.php to the following

$database_type = "mysql";
$database_default = "cactidb";
$database_hostname = "localhost";
$database_username = "cactyuser";
$database_password = "cactyuser321";
$database_port = "3306";

/* Default session name - Session name must contain alpha characters */
$cacti_session_name = "Cacti";




Inspite doing all this i still get "FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'"


Kindly help me out.

[Howie]

Either restart mysqld, or run "flush privileges" from the mysql command prompt. I think your problem is that the grant commands haven't taken effect yet.