Skip to main content

Changed the MySQL Server or Password and TCAdmin can't Connect

If you changed your MySQL password or server IP and TCAdmin doesn't start correctly replace the contents of C:\Program Files\TCAdmin2\Monitor\ConfigUtility.config or /home/tcadmin/Monitor/ConfigUtility.config with the following. Replace MYSQLIP, MYSQLDB, MYSQLUSER and MYSQLPASSWORD with the correct information. Then restart the monitor.

<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<values>
<add key="TCAdmin.ConfigUtility.Database.ConnectionString" value="Data Source=MYSQLIP;User Id=MYSQLUSER;Password=MYSQLPASSWORD;Database=MYSQLDB;Pooling=false;Compress=false;Connection Lifetime=900;Connect Timeout=30;Protocol=TCP" type="System.String,mscorlib" />
<add key="TCAdmin.ConfigUtility.Database.DBMS" value="MySql" type="System.String,mscorlib" />
<add key="TCAdmin.ConfigUtility.Database.Provider" value="TCAdmin.DatabaseProviders.MySql.MySqlManager,TCAdmin.DatabaseProviders.MySql" type="System.String,mscorlib" />
<add key="TCAdmin.ConfigUtility.Database.ConnectionString.Encrypted" value="False" type="System.String,mscorlib" />
<add key="TCAdmin.ConfigUtility.Monitor.ServerId" value="1" type="System.String,mscorlib" />
<add key="TCAdmin.ConfigUtility.Certificate.Thumbprint" value="" type="System.String,mscorlib" />
</values>

For remote servers go to Settings > Remote DB Connection and configure the new connection info. Then download a new ConfigUtility.config from the remote server settings and save it to the remote server's Monitor folder. Then restart the monitor.