[phpesp-general] password confusion

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

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?
-- 


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