MySQL Forums
Forum List  »  MySQL Workbench

Re: Workbench 6.3.9 - Unable to connect to MariaDB 15.1
Posted by: Malcolm White
Date: December 22, 2017 06:57AM

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 type="string" key="name">Local instance 3306</value>
<link type="object" struct-name="GrtObject" key="owner">4ee72836-e70e-11e7-866d-902b3441ed70</link>

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.

Options: ReplyQuote

Written By
Re: Workbench 6.3.9 - Unable to connect to MariaDB 15.1
December 22, 2017 06:57AM

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.