Re: Workbench 6.3.9 - Unable to connect to MariaDB 15.1
I am still struggling to make a connection to the database.
The issue appears to relate to the sequence of events leading up to the 'Unsupported option provided to mysql_options()' exception, since WB doesn't even initiate a connection string to the database.
Using the Configuration Server Management utility I have been able to establish a connection to a remote MySQL database, so username, password and grants used are valid.
There's also a reference to a MySQL@localhost:3306 in the connections.xml file see below:
<data grt_format="2.0">
<value _ptr_="0x565063893630" type="list" content-type="object" content-struct-name="db.mgmt.Connection">
<value type="object" struct-name="db.mgmt.Connection" id="9f067eda-d826-11e7-a6c2-902b3441ed70" 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@localhost:3306</value>
<value type="int" key="isDefault">1</value>
<value _ptr_="0x565063ab9b10" type="dict" key="modules"/>
<value _ptr_="0x565063ab3d10" type="dict" key="parameterValues">
<value type="string" key=""></value>
<value type="string" key="SQL_MODE"></value>
<value type="string" key="hostName">localhost</value>
<value type="string" key="password"></value>
<value type="int" key="port">3306</value>
<value type="string" key="schema"></value>
<value type="string" key="socket">/var/run/mysql/mysql.sock</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">workbench</value>
</value>
<value type="string" key="name">Local instance 3306</value>
<link type="object" struct-name="GrtObject" key="owner">4ee72836-e70e-11e7-866d-902b3441ed70</link>
</value>
</value>
</data>
But I have no idea to what that relates. Or if indeed it is relevant.
I've also glimpsed a message indicating the existence of a configuration file in @HOME/.local/share/akonadi/mysql.conf, but this also seems to be odd, as it refers to another configuration file that doesn't exist and some of its directives conflict with /etc/my.cnf.
Any pointers will be most appreciated. Thanks.
Subject
Views
Written By
Posted
1463
December 13, 2017 12:10PM
4018
December 17, 2017 11:06AM
Re: Workbench 6.3.9 - Unable to connect to MariaDB 15.1
1209
December 22, 2017 06:57AM
987
December 22, 2017 04:36PM
1700
December 23, 2017 06:28AM
Sorry, you can't reply to this topic. It has been closed.
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.