Re: [phpesp-general] password confusion

[Christopher A. <chr...@st...>]

Thanks. So, the 'root' user is always the user that logs into the 
management interface and that shouldn't be changed. Correct?


Christopher Adams
Library Systems Analyst
Oregon State Library
503-378-4243 258
chr...@st...


Matthew Gregg wrote:
> You should be able to change the root password from the Designer page in
> the management interface.
> On Fri, 2005-08-19 at 15:13 -0700, Christopher Adams wrote:
> 
>>I am a little confused about passwords when configuring phpESP. I have 
>>the application working and so far, there don't seem to be any problems. 
>>So, you may ask why this guy is trying to fix something that isn't broken.
>>
>>Well, it stems from confusion about passwords. Just by  chance, though 
>>maybe I had read it somewhere, I finally was able get to the management 
>>screen by using username: root, password: esp. However, I would like to 
>>change this, but can't quite see where to do it. The installation help 
>>says to change the default password from 'phpesp' before executing the 
>>'mysql_create.sql' script. I assume that means for the 'phpesp' user 
>>that is created. I didn't change the default password in the script 
>>before running it and so it says:
>>
>>INSERT INTO user (host, user, password) VALUES ( 'myserver',
>>   'phpesp', PASSWORD('phpesp'));
>>
>>Then it says to use this same password when configuring phpESP. That 
>>would be the section in phpESP.ini.php, which says:
>>
>>// Database connection information
>>$ESPCONFIG['db_host'] = 'myserver.anywhere.com';
>>$ESPCONFIG['db_user'] = 'otheruser';
>>$ESPCONFIG['db_pass'] = 'otherpass';
>>$ESPCONFIG['db_name'] = 'phpesp';
>>
>>However, I entered a username/password that is different from the phpesp 
>>username/password, and one that allows me to access teh 'phpesp' 
>>database. Everything works fine.
>>
>>
>>So, the bottom line is, what should I be doing and how can I change the 
>>admin username/password for management?