ask for help! I met problem when I install plog 1.0

[szmickhuang]

I am a newbie. I just install plog 1.0 on my computer. but I met a problem and I can not solve it. pls help me.

I got the error msg below:
Exception message: mysql_connect(): Access denied for user 'mick'@'localhost' (using password: NO)
Error code: 2
-- Backtrace --
C:\apache\Apache2\htdocs\plog\class\database\adodb\drivers\adodb-mysql.inc.php(339): mysql_connect
C:\apache\Apache2\htdocs\plog\class\database\adodb\adodb.inc.php(413): adodb_mysql._connect
C:\apache\Apache2\htdocs\plog\wizard.php(656): adodb_mysql.connect
C:\apache\Apache2\htdocs\plog\wizard.php(937): connectdb
C:\apache\Apache2\htdocs\plog\class\controller\controller.class.php(305): wizardsteptwo.perform
C:\apache\Apache2\htdocs\plog\wizard.php(1814): controller.process

Exception message: mysql_get_server_info(): supplied argument is not a valid MySQL-Link resource
Error code: 2
-- Backtrace --
C:\apache\Apache2\htdocs\plog\class\database\adodb\drivers\adodb-mysql.inc.php(394): mysql_get_server_info
C:\apache\Apache2\htdocs\plog\class\database\adodb\drivers\adodb-mysql.inc.php(347): adodb_mysql._issupportutf8
C:\apache\Apache2\htdocs\plog\class\database\adodb\adodb.inc.php(413): adodb_mysql._connect
C:\apache\Apache2\htdocs\plog\wizard.php(656): adodb_mysql.connect
C:\apache\Apache2\htdocs\plog\wizard.php(937): connectdb
C:\apache\Apache2\htdocs\plog\class\controller\controller.class.php(305): wizardsteptwo.perform
C:\apache\Apache2\htdocs\plog\wizard.php(1814): controller.process

btw: my environment is winXP, apache 2.0.53, php 4.3.11, mysql 4.1.11

[markwu]

Hi szmickhuang:

It seems your mysql server reject you to login.

1. Make sure you already create the user "mick" or not
2. If already create, make sure you assign the right previliges for this user or not, you need to give the user previlige to handle your plog database

Mark

[szmickhuang]

I've checked my mysql's config and I'm sure that I have a account named "mick" and have assigned all privilges of database test to mick.
So I am mixed-up.

[markwu]

Does you assign password for this account? If not, kindly see the following post, it might help

http://forums.mysql.com/read.php?10,19811,19811#msg-19811

If yes, as I know there is a bug in PHP 4.3.x , it will casue the PHP can not connect to MySQL database 4.1.x.

I met the problem before, but I am not sure your problem is the same as mine or not. Kindly see this post:

http://forums.mysql.com/read.php?11,6400,10611#msg-10611

Mark

[szmickhuang]

Mark, thanks a lot

I solved it follow the instructions you suggested. It's php4.3.x's problem. I just clear root's password on mysql and reinstall plog. It's ok now!

So, I think I have to use php4.1.x or php5 instead.

Any way, thank you for your kindly help!