MySQL Forums
Forum List  »  MySQL Workbench

Re: Cannot Connect to Database Server: Type mismatch
Posted by: Michael Britt
Date: July 22, 2022 06:54PM

I found the connections.xml file. Here it is with both connections. The first section will not connect. The second section will.

The only differences i can see are the db.mgmt.Connection values and the "int" "isDefault" where the top one is set to 1 and the bottom one is set to 0.

<?xml version="1.0"?>
<data grt_format="2.0">
<value _ptr_="000001EB361ECAB0" type="list" content-type="object" content-struct-name="db.mgmt.Connection">

<value type="object" struct-name="db.mgmt.Connection" id="{762832BE-02A6-472B-A16C-5FD6CFBF8092}" struct-checksum="0x96ba47d8">
<link type="object" struct-name="db.mgmt.Driver" key="driver">com.mysql.rdbms.mysql.driver.native</link>
<value type="string" key="hostIdentifier">Mysql@127.0.0.1:3306</value>
<value type="int" key="isDefault">1</value>
<value _ptr_="000001EB355F8C20" type="dict" key="modules"/>
<value _ptr_="000001EB355F8740" type="dict" key="parameterValues">
<value type="int" key="DbSqlEditor:LastDefaultSchema">1981</value>
<value type="string" key="SQL_MODE"></value>
<value type="string" key="hostName">127.0.0.1</value>
<value type="int" key="lastConnected">1658434767</value>
<value type="string" key="password"></value>
<value type="int" key="port">3306</value>
<value type="string" key="schema"></value>
<value type="string" key="serverVersion">8.0.29</value>
<value type="string" key="sslCA"></value>
<value type="string" key="sslCert"></value>
<value type="string" key="sslCipher"></value>
<value type="string" key="sslKey"></value>
<value type="int" key="useSSL">1</value>
<value type="string" key="userName">root</value>
</value>
<value type="string" key="name">Local instance MySQL80</value>
<link type="object" struct-name="GrtObject" key="owner">{1238A872-4333-4C61-A8AF-F395EEB99503}</link>
</value>

<value type="object" struct-name="db.mgmt.Connection" id="{A07CCE27-C6BB-43A9-AC9E-D48D7E035C73}" struct-checksum="0x96ba47d8">
<link type="object" struct-name="db.mgmt.Driver" key="driver">com.mysql.rdbms.mysql.driver.native</link>
<value type="string" key="hostIdentifier">Mysql@127.0.0.1:3306</value>
<value type="int" key="isDefault">0</value>
<value _ptr_="000001EB3631EA60" type="dict" key="modules"/>
<value _ptr_="000001EB3631F000" type="dict" key="parameterValues">
<value type="string" key="SQL_MODE"></value>
<value type="string" key="hostName">127.0.0.1</value>
<value type="int" key="lastConnected">1658537048</value>
<value type="string" key="password"></value>
<value type="int" key="port">3306</value>
<value type="string" key="schema"></value>
<value type="string" key="serverVersion">8.0.29</value>
<value type="string" key="sslCA"></value>
<value type="string" key="sslCert"></value>
<value type="string" key="sslCipher"></value>
<value type="string" key="sslKey"></value>
<value type="int" key="useSSL">1</value>
<value type="string" key="userName">root</value>
</value>
<value type="string" key="name">NonBrokenRootAccess</value>
</value>

</value>
</data>

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Cannot Connect to Database Server: Type mismatch
568
July 22, 2022 06:54PM
88
November 07, 2023 07:54AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.