This topic is locked

PHP error on uploaded page

6/22/2008 10:03:29 AM
PHPRunner General questions
P
petrmelis author

Hi,

I am new in PHP and MySQL so apologize for stupid question.

Still trying trialout version of PHPrunner on WinXP Pro SP3, IIS5, PHP 5.2.6, MySQL5.

I generated testing site with PHPrunner into C:\Inetpub\wwwroot\output. It works fine on my localhost server.

http://localhost/output/

When I upload all files from "output" folder to "jirka" folder with demo account on asprunner server its working fine too.
see it here
When I upload all files from "output" folder to "jirka" folder on my own hosting server at hostmonster.com its show error.
PHP error happened

Technical information

Error type 2

Error description mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES)

URL petrspage.com/jirka/cars_list.php?

Error file /home/miroscre/public_html/petrspage/jirka/include/dbconnection.php

Error line 9

SQL query
see it here
I think it is something about communicating with database.

Connection was created on localhost server and it does not work o remote server.

Maybe I am wrong. Any ideas how to make it work?

Thanks Petr

sorry for my english <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8830&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />

mikue from germany 6/22/2008

Hi,

  1. You have to modify include/dbcommon.php with login data for desired mysql database.
  2. Import db.sql file with phpmyadmin provided by your ISP, you'll find file at location:
    local install directory ... templates\business\cars\database\db.sql
  3. Please check also FAQ of your ISP :
    http://helpdesk.hostmonster.com/kb/index.p...ot=7&id=237
    Greetings Michael

S
swanside 6/23/2008

Hi,

I am new in PHP and MySQL so apologize for stupid question.

Still trying trialout version of PHPrunner on WinXP Pro SP3, IIS5, PHP 5.2.6, MySQL5.

I generated testing site with PHPrunner into C:\Inetpub\wwwroot\output. It works fine on my localhost server.

http://localhost/output/

When I upload all files from "output" folder to "jirka" folder with demo account on asprunner server its working fine too.
see it here
When I upload all files from "output" folder to "jirka" folder on my own hosting server at hostmonster.com its show error.
PHP error happened

Technical information

Error type 2

Error description mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES)

URL petrspage.com/jirka/cars_list.php?

Error file /home/miroscre/public_html/petrspage/jirka/include/dbconnection.php

Error line 9

SQL query
see it here
I think it is something about communicating with database.

Connection was created on localhost server and it does not work o remote server.

Maybe I am wrong. Any ideas how to make it work?

Thanks Petr

sorry for my english <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=30498&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />


Its looking for a password.
i.e.

mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES)

P
petrmelis author 6/24/2008

Hi,


  1. You have to modify include/dbcommon.php with login data for desired mysql database.
  2. Import db.sql file with phpmyadmin provided by your ISP, you'll find file at location:
    local install directory ... templates\business\cars\database\db.sql
  3. Please check also FAQ of your ISP :
    http://helpdesk.hostmonster.com/kb/index.p...ot=7&id=237
    Greetings Michael


Thanks Michael,
I am on vacation now. I`ll be back next week so I`ll try that. It seems to be it.

Thanks Petr