I am attempting to perform an upgrade on our RT (4.2.10) to the latest version. I can successfully upgrade the client, however the script for upgrading the DB appears to mandate that it log into the MySQL server as root.
For security purposes, we don’t allow users to edit any MySQL DBs as root if they are not on the MySQL server. The script in this case ought to log into the server as a given user rather root.
Any help in figuring this out is appreciated.