关于cacti的问题。。

Question

装sql的最后。。输入
root@tuou php]# bin/php /opt/htdocs/cacti/poller.php

Warning: mysql_pconnect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /opt/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 356

[root@tuou bin]# ./mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

但是这样又没问题
root@tuou bin]# ./mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 5061 to server version: 5.0.24-standard

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> exit
Bye
最后在浏览器里http://local/host/cacti/install
出现
Warning: mysql_pconnect() [function.mysql-pconnect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /opt/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 355

Error
You have created a new database, but have not yet imported the 'cacti.sql' file. At the command line, execute the following to continue:
mysql -u cactiuser -p cacti < cacti.sql
This error may also be generated if the cacti database user does not have correct permissions on the cacti database. Please ensure that the cacti database user has the ability to SELECT, INSERT, DELETE, UPDATE, CREATE, ALTER, DROP, INDEX on the cacti database.

这是怎么一回事阿。。。help。。thx

Answer 1

已经这样作了
mysql -u cactiuser -p cacti < cacti.sql
还是一样。。看我最上面的错误
root@tuou php]# bin/php /opt/htdocs/cacti/poller.php

Warning: mysql_pconnect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /opt/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 356

[root@tuou bin]# ./mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Answer 2

Error
You have created a new database, but have not yet imported the 'cacti.sql' file. At the command line, execute the following to continue:
mysql -u cactiuser -p cacti < cacti.sql
This error may also be generated if the cacti database user does not have correct permissions on the cacti database. Please ensure that the cacti database user has the ability to SELECT, INSERT, DELETE, UPDATE, CREATE, ALTER, DROP, INDEX on the cacti database.
导入数据 mysql -u cactiuser -p cacti < cacti.sql