Geek Answers Handbook

Unsupported option provided by mysql_options ()

I installed mysql-server and mysql-workbench on my local machine with Ubuntu 16.04 as the OS. I can connect to the mysql server through the 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 constantly get this error from mysql-workbench when I try to connect to mysql server.

 Unsupported option provided to mysql_options()

please help me understand what I'm doing wrong to fix this problem, namely, to connect to the mysql server through mysql-workbench.

+6
source share
2 answers

The mysql_old_password server protocol is no longer supported by Workbench since its support was removed in MySQL Server 5.7. This affects the previous option Use the old SSH authentication protocol in MySQL Workbench, which causes an error

Unsupported option provided by mysql_options ()

while you tried to connect through the workbench. Therefore, 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

+1
source

To fix this problem. What you can do is downgrade MySQL 6.3.6 Workbench CE (GPL) to 6.3.4

+1
source

More articles:


All Articles