LifeType 中文開發論壇

支援 => 安裝與設定 => 主題作者是: szmickhuang 於 四月 14, 2005, 11:44:07 下午



主題: ask for help! I met problem when I install plog 1.0
作者: szmickhuang四月 14, 2005, 11:44:07 下午
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


主題: ask for help! I met problem when I install plog 1.0
作者: markwu四月 15, 2005, 12:28:38 上午
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


主題: ask for help! I met problem when I install plog 1.0
作者: szmickhuang四月 15, 2005, 12:48:18 上午
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.


主題: ask for help! I met problem when I install plog 1.0
作者: markwu四月 15, 2005, 01:09:43 上午
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


主題: ask for help! I met problem when I install plog 1.0
作者: szmickhuang四月 15, 2005, 10:36:21 上午
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! :-)