Unsupported option provided to mysql_options()

Question

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.

Answer 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

Answer 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