Mantis and mysql

modifying mantis user data from command line

1. find the mantis config file    
locate config_inc.php

2. connect to the db
mysql -u username -h hostname -p


3. switch to the mantis database
use mantisdb;

4. locate the table that holds users.
show tables;

5. check table content.
select * from mantis_user_table;


6. do what ever you want to a user!
update!!!! update!!! update!!!