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

Revision as of 10:18, 21 April 2020 by TCAWiki (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.

Retrieved from "https://help.tcadmin.com/index.php?title=Changed_the_MySQL_Server_or_Password_and_TCAdmin_can%27t_Connect&oldid=2054"