Re: [phpesp-general] reset root phpesp password?

[Jim B. <jp...@si...>]

* Harry Mangalam <hj...@ta...> [2005-09-09 21:11]:
> 
> > Is there a way to reset the root phpesp password?  I have root on this
> > system (and HAVE remembered the root mysql DB).
> >


Log into mysql phpesp database.  Update the 'designer' table :


$ mysql -u root -p phpesp
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 462 to server version: 4.1.10a

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> update designer set password = PASSWORD('12345') where username = 'root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> exit
Bye
$


Log into the phpESP management interface with user root and password 12345.


Hope this helps,
Jim B.