facing problem in installing cacti

[dxbpawan]

Hi,
i am new to Cacti. i am configuring cacti by this links.

http://www.cyberciti.biz/faq/fedora-rhe ... -software/

i am stuck at this command

#####################################
rpm -ql cacti | grep cacti.sql
/usr/share/doc/cacti-0.8.7g/cacti.sql
#######################################


[root@localhost ~]# mysql -u cacti -p cacti < /usr/share/doc/cacti-0.8.7g/cacti.sql
Enter password: PASSWORD
ERROR 1064 (42000) at line 5: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 6
############################################################################3

not able to understand whats this error is. please point me to right direction.

thanks

[gandalf]

This is a known issue. Please replace "Type=MyISAM" by "Engine=MyISAM". Latest MySQL does not accept the "old way"
R.

[dxbpawan]

in cacti.sql i changed "Type=MyISAM" by "Engine=MyISAM", now when i am giving this command, getting this message.

[root@localhost cacti-0.8.7g]# mysql -u root -p cacti < cacti.sql
Enter password:
ERROR 1050 (42S01) at line 5: Table 'cdef' already exists

still cacti is not opening in webpage, plz guide me friend.

thanks

[gandalf]

Please delete all tables in the cacti DB and then rerun the import
R.

[dxbpawan]

[root@localhost plal]# echo "drop table cacti.cdef" mysql -u root -p

[root@localhost plal]# mysql -u cacti -p < /usr/share/doc/cacti-0.8.7g/cacti.sql
Enter password:
ERROR 1046 (3D000) at line 5: No database selected

[dxbpawan]

[root@localhost plal]# mysql -u cacti -p cacti < /usr/share/doc/cacti-0.8.7g/cacti.sql
Enter password:
ERROR 1045 (28000): Access denied for user 'cacti'@'localhost' (using password:

[gandalf]

So the mysql permissions for cactiuser are not sufficient. Please see installation docs to find the requirements
R.