All,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:root_reset.sh#! /bin/bash# Script to reset the MySQL root passwordrst_file="/Scripts/MySQL/root-reset.txt";/etc/init.d/mysql stop;mysqld --skip-grant-tables --skip-networking < $rst_file;/etc/init.d/mysql restart;exit;root-reset.txt/* Reset the Root PWD */FLUSH PRIVILEGES;ALTER USER 'root'@'localhost' IDENTIFIED BY 'mypass';FLUSH PRIVILEGES;/* 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;FLUSH PRIVILEGES;QUIT;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!Cheers!OMR