How to configure a new connection port after updating MySQL Database

GreenHell138

osTicket Version v1.15.4 (6bd7884) — Up to date
Web Server Software Microsoft-IIS/8.5
MySQL Version 5.5.62
PHP Version 7.3.31

Hello, I recently installed MySQL Database version 5.7.37 alongside the previous version and successfully imported the exported database from osTicket on MySQL 5.5.62 into 5.7.37 without errors, but I configured the port for the new DB to operate on 3307. Where/in what configuration file can I configure the osTicket to connect to the DB on the new port, 3307? I checked ost-config.php and it doesn't contain the setting to connect on the specific port (only the specific settings below). Thanks in advance!

Database Options

---------------------------------------------------

Mysql Login info

define('DBTYPE','mysql');
define('DBHOST','localhost');
define('DBNAME','osTicket');
define('DBUSER','root');
define('DBPASS','<password redacted>');

KevinTheJedi

GreenHell138

Directly in the host name like:

hostname:3307

Cheers.

GreenHell138

KevinTheJedi After the making the change to the Database Options section | Mysql Login info subsection of the ost-config.php file below, osTicket is now using the upgraded database MySQL database on the new port 3307:

define('DBHOST','localhost:3307');

As you explained, all that was needed was to add the :3307 after the hostname "localhost" ( define('DBHOST','localhost:3307');) and then restart IIS to make PHP reread the ost-config.php configuration file, and reconnect osTicket to the new database on the new port.

Admin Panel -->Dashboard --> Information now shows we are running MySQL DB v5.7.37. I tested opening, assigning, commenting, and closing tickets. Everything works as expected. Thanks!