Arch Linux

n_t

Member

Registered: 2013-02-01

Posts: 48

MySql Workbench - Invalid Options

I've followed the arch wiki and installed maria db. I've then installed mysql-workbench from that aur, but I cannot connect to a local db. I get this error:

Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
  Unsupported option provided to mysql_options()

Please:
1 Check that mysql is running on server 127.0.0.1
2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from

When I click on the connection, and hit "Test Connection" I get this error:

Unsupported option provided to mysql_options()

I know mysql is running because I can connect via the CLI:

➜  Downloads  mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.0.14-MariaDB-log MariaDB Server

Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| blah               |
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
5 rows in set (0.00 sec)

MariaDB [(none)]> 

And I know it is running on port 3306:

➜  Downloads  sudo netstat -nap | grep 3306
tcp6       0      0 :::3306                 :::*                    LISTEN      16369/mysqld   

Any idea?

Last edited by n_t (2014-11-24 17:24:30)

bbv

Member

Registered: 2015-02-18

Posts: 1

Re: MySql Workbench - Invalid Options

Did you find out what was wrong? I started to have exactly the same problem on my home computer, although it works correctly at my work computer with very similar configuration.

aleextra

Member

Registered: 2009-12-02

Posts: 28

Re: MySql Workbench - Invalid Options

Have both of you fixed that problem? When running workbench at console I am getting:

[mik@mik-l tmp]$ mysql-workbench
/usr/bin/mysql-workbench-bin: /usr/lib/libmysqlclient.so.18: no version information available (required by /usr/lib/libgdal.so.1)
/usr/bin/mysql-workbench-bin: /usr/lib/libmysqlclient.so.18: no version information available (required by /usr/lib/libmysqlcppconn.so.7)
Ready.

thulsadum

Member

Registered: 2015-08-01

Posts: 1

Re: MySql Workbench - Invalid Options

I had the very same problem, then I recognized, that I had the old libmysqlclient package installed instead of libmariadbclient.

Installing the libmariadbclient, fixed it for me:

% pacman -S --asdeps libmariadbclient
resolving dependencies...
looking for conflicting packages...
:: libmariadbclient and libmysqlclient are in conflict. Remove libmysqlclient? [y/N] y

Package (2)             Old Version  New Version  Net Change  Download Size

libmysqlclient          5.5.30-7                  -25,37 MiB
extra/libmariadbclient               10.0.20-1     19,04 MiB       4,20 MiB

Last edited by thulsadum (2015-08-01 23:19:24)