2. PHPRunner General questions
  3. [SOLVED]  Questions on eval
This topic is locked
[SOLVED]

 Questions on eval

 		4/11/2005 1:44:08 PM
PHPRunner General questions
author

Greetings,

I'm trying out the evaluation version of PHPrunner, and I think I'm going to like it if I can sort out two issues:
One, after I upload the generated files to my webserver and log in to the PHPrunner login screen, I get the following error:
mysql_connect(): Access denied for user: 'root@domainname(Using password: YES)
It can't be that the MySQL username and password are incorrect, because I had to enter them correctly to generate the files to begin with.
Second, when I launch the software the nag screen pops up within seconds and prevents me from doing anything more. I have to quit and relaunch several times before I can get past the first part of the setup. If I get past the first page I am able to complete the project (though it keeps prompting me to save the work).
Thanks.
admin 4/12/2005

Hi,
This may happen when machine where you run PHPRunner and your Web server are two different boxes.
MySQL can store different passwords for root from localhost (root@localhost)

and for root from any other host (root@%). MySQL also can allow root access

from localhost only.
You can check the password configuration of your MySQL by issuing the following

command. The sample output shows that root user should use different passwords to connect locally or remote. Passwords are encoded.mysql> select host,user, password from mysql.user;

+-----------+-------+------------------+

| host | user | password |

+-----------+-------+------------------+

| localhost | root | 394036077845ecb2 |

| % | root | 606717496665bcba |

| localhost | | 7cfc33b574d442f6 |

| % | | 7cfc33b574d442f6 |

| % | admin | 2ebfbe6e025abf3e |

+-----------+-------+------------------+

5 rows in set (0.00 sec)
You may need to change or add the passwords to allow root user to

connect from the desired host. Use one of the following commands to do that.
set password for 'root'@'localhost' = PASSWORD('pass');

set password for 'root'@'domainname.org' = PASSWORD('pass');

set password for 'root'@'%' = PASSWORD('pass');

where "pass" is your desired password.
If you'll need help with resolving this issue, please post here the output of the

following mysql command:
select host,user, password from mysql.user