osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Major DB Problems Resolved
I installed osTicket and suddenly found it was as though someone erased my entire MySQL database. So I reached out to Customer Care accusing them of a "DROP ALL" mysql statement in the code.
Peter Rotich answered me stating no such thing. So looked through the code and he was right; no DROP ALL in there. I next suspected a "purge" & "re-install" of MySQL, but could not find that. Next I suspected some corruption, but again nothing.
Finally I found that I could neither login via phpMyAdmin with either my admin or root UID/PWD combo. I then, not being a DBA, had to read through loads and loads of crap to find the following bash script solution to resetting my root password:
# Script to reset the MySQL root password
mysqld --skip-grant-tables --skip-networking < $rst_file;
/* Reset the Root PWD */
ALTER USER 'root'@'localhost' IDENTIFIED BY 'mypass';
/* Create addition Admin user with root permissions */
CREATE USER '$user'@'localhost' IDENTIFIED BY 'mypass';
GRANT ALL PRIVILEGES ON *.* TO '$user'@'localhost' WITH GRANT OPTION;
CREATE USER '$user'@'%' IDENTIFIED BY 'mypass';
GRANT ALL PRIVILEGES ON *.* TO '$user'@'%' WITH GRANT OPTION;
It was amazing! As soon as the root password was reset I could suddenly see all my DBs and Tables.
So the crime committed by the dev team was to reset the root password to their own which locks the user out of all their DBs/Tables.
If you run into this problem, this is the solution!