Difference between revisions of "Changed the MySQL Server or Password and TCAdmin can't Connect"

(Created page with "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/tc...")
 
 
Line 1: Line 1:
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, MYSQLUSER and MYSQLPASSWORD with the correct information. Then restart the monitor.
+
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"?>
 
  <?xml version="1.0" encoding="utf-16" standalone="yes"?>

Latest revision as of 10:18, 21 April 2020

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"