提供给mysql_options()的不受支持的选项 [英] Unsupported option provided to mysql_options()

问题描述

我已在装有Ubuntu 16.04作为操作系统的本地计算机上安装了mysql-server和mysql-workbench.我可以通过CLI而不是通过mysql-workbench连接到mysql-server.

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

当我尝试连接到mysql-server时，我一直从mysql-workbench收到此错误.

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

Unsupported option provided to mysql_options()

请帮助我了解我为解决此问题所做的错误，即通过mysql-workbench连接到mysql-server.

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.

推荐答案

Workbench不再支持服务器变量 mysql_old_password 协议，因为它的支持已在MySQL Server 5.7中删除.这会影响MySQL Workbench中以前的"使用旧的身份验证协议" SSH连接选项，从而导致错误

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

提供给mysql_options()的不受支持的选项

Unsupported option provided to mysql_options()

当您尝试通过工作台建立连接时.因此，请将MySQL-Workbench升级到任何较新的版本，以避免出现此错误.

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

请检查此URL供参考: http://bugs.mysql.com/bug.php?id=78947

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

这篇关于提供给mysql_options()的不受支持的选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！