mysql

doesn't look like its worth trying to get existing mysql session mgr for
shib working since comments describe it as a two level cache with the
attributes remaining in ram. will need to look at this more closely.
don't need to worry about it for now. need ldap database and vo mgm up
more pressing.

would need to build a attribute cache backend that stores the attributes
into the voaa origin aa cache or build that shib shim that captures the
attributes during the vo origin hs processing after the shib
authentication is done.

In MySQL manual: http://dev.mysql.com/doc/mysql/en/resetting-permissions.html

1. stop mysql server; they recommend locating the .pid file for the process and using 'kill' command.

2. create text file and save:

   SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');

   command all on one line.

3. restart msql server as follows:
   mysqld_safe --init-file=~/path/fname &

   where fname is the file you just created & enough path info for the server to locate this.

4. this time, write the password down :0

5. delete the file fname