Unsupported option provided to mysql_options()

问题:

I have installed mysql-server and mysql-workbench on my local machine having Ubuntu 16.04 as OS. I am able to connect to mysql-server through CLI, but not through mysql-workbench.

  mysql --version
  mysql  Ver 14.14 Distrib 5.7.12, for Linux (x86_64) using  EditLine wrapper

mysql-workbench --version
MySQL Workbench CE (GPL) 6.3.6 CE build 511

I am consistently getting this error from mysql-workbench when i try to connect to mysql-server.

Unsupported option provided to mysql_options()

please help me to understand what i am doing wrong to fix this issue i.e. to get connected to mysql-server through mysql-workbench.

回答1:

The server variable mysql_old_password protocol is no longer supported by Workbench, as its support was removed in MySQL Server 5.7. This affects the former "Use old authentication protocol" SSH connection option in the MySQL Workbench which causes the error

Unsupported option provided to mysql_options()

while you have attempted to establish the connection via workbench. So upgrade MySQL-Workbench to any newer version to avoid this error.

Please check this URL for reference : http://bugs.mysql.com/bug.php?id=78947

回答2:

To fix that issue. What you can do is to downgrade the MySQL Workbench CE (GPL) 6.3.6 to version 6.3.4

回答3:

Here are all the details - it is shame I cannot connect to older systems (actually it is database running on Centos 7...)

https://bugs.mysql.com/bug.php?id=78947

Update: On my Gentoo system I got it working locally with versions:

• mysql-workbench - 6.3.10
• mariadb - 10.1.31-r1 (I found note about latest mariadb version doesn't work as well here: https://forums.gentoo.org/viewtopic-t-1073876-start-0.html)

But it didn't work straightforward, I had to delete folder ~/.mysql/workbench first, otherwise this error still occured, now I have setup where this issue is fixed.