Cacti installation on Debian Sarge: create cacti database error

Yahweee · 02-21-2007, 07:05 AM

Hi

I have searched the whole internet for a solution to my problem but it seems i going nowhere. I am installing Cacti on Debian sarge and my apt-get install cacti went thru. However the big challenge is on creating the cacti database by running this command :-

# mysqladmin –user=root create cacti

Below is the error reported :-

mysqladmin: connect to server at 'locahost' failed
error: 'Access denied for user 'root@localhost' (using password: NO)

Help please.

Thanks you

JimBass · 02-22-2007, 04:09 PM

If you never configured mysql, that is the source of your problems. Mysql doesn't automatically import all your system accounts into itself, so it is quite possible mysql has no root account. I believe Debian installs mysql with only user debian-sys-maint. You'll need to look in the mysql configs, or get to a point where you can sign into mysql and create users/databases etc.

Peace,
JimBass

irado · 08-26-2008, 06:35 AM

Quote:

Originally Posted by Yahweee

Hi

# mysqladmin –user=root create cacti

Below is the error reported :-

mysqladmin: connect to server at 'locahost' failed
error: 'Access denied for user 'root@localhost' (using password: NO)

use the mysql console, instead this one.

mysql -u root[@somehost] -psome.passwd (if any)
mysql> create cacti;
[...]
import tables, etc - as instructed.