Uderc programming article aggregator sites

MySql Workbench - Invalid Options

Tags:
Answers: Have 2 answers
Advertisement
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)
Advertisement
The best answer: 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.