Mysql Workbench crashing when connecting

crashMySQLmysql-workbenchpermissions

I have created an user i intend to give access to one db only.
But when i try connecting with him, the program crashes. When i connect with the root user, it works.

 create user 'test'@'localhost';
 GRANT ALL PRIVILEGES ON sbb2_test.* To 'test'@'localhost' IDENTIFIED BY 'test';
 FLUSH PRIVILEGES;

Then i have verified he has the permissions for the sbb2_test db only:

 SHOW GRANTS FOR 'test'@'localhost'

Output:

'GRANT USAGE ON *.* TO \'test\'@\'localhost\' IDENTIFIED BY PASSWORD \'*94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29\''
'GRANT ALL PRIVILEGES ON `sbb2_test`.* TO \'test\'@\'localhost\''

Then i have tried connecting with the new user:

I have entered "test" as the password, and the program crashed.
Why?
These are the last lines from the wb.log file:

15:58:40 [INF][ Workbench]: Current version given by meta info is: 6.1.7

15:58:41 [INF][ Workbench]: Exiting as another instance of WB is already running.
15:58:41 [INF][ Workbench]: Running the application

15:58:41 [INF][ WBContext]: Parsing application arguments.

15:58:41 [INF][ WBContext]: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\MySQLWorkbench.exe

15:58:46 [WRN][ WBContext UI]: Server instance has no attached connection, deleting it

15:59:17 [INF][ SSH tunnel]: Starting tunnel

15:59:17 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'test'@'localhost' (using password: NO)

15:59:30 [INF][ Admin]: Auto-created instance profile for connection

15:59:30 [ERR][ WBContext]: Unsupported server version: mariadb.org binary distribution 10.1.26-MariaDB

Best Answer

Looks like a known issue with it not handling an exception error properly and also the wrong version: https://bugs.mysql.com/bug.php?id=79364

Description: WB 6.3.5 (and also older release like 6.1.7) can connect to MariaDB.

> How to repeat:
> 1. Download WB 6.3.5 CE 64 bit (32 bit has the same issue)
> 2. Download MariaDB 10.0.22 64 bit windows
> 3. Start MariaDB using mysqld --console
> 4. Create a new connection using WB : testing the connection works
> 5. Connect to the database ( may or may not crash) : a SQL tab opens
> 6. Connect to the same database : crashes : it says MySQL workbench has stopped working : a new SQL tab can not open

[20 Nov 2015 23:32] Godofredo Miguel Solorzano
Thank you for the bug report. Looks like you have the reason for in the log:

15:14:22 [ERR][      WBContext]: Unsupported server version: mariadb.org binary distribution 10.0.22-MariaDB

Are you using containers in your environment?

edit: For now I solved it this way:from the menu Database => Manage Connections... I have created and saved the connection for the "test" user, so that it appears on the start screen ( when you launch WB, the saved connections appear as a list of gray buttons , and you can launch them directly from there).

Related Solutions

Mysql – Grant table privileges to a user connecting from any host

When you execute GRANT SELECT ON store.catalog TO 'wordpress'@'%';, mysqld wants to insert a row into the grant table mysql.tables_priv. Here is mysql.tables_priv:

mysql> show create table mysql.tables_priv\G
*************************** 1. row ***************************
       Table: tables_priv
Create Table: CREATE TABLE `tables_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges'
1 row in set (0.00 sec)

mysql>

Since you want to insert a row into mysql.table_priv where user='wordpress' and host='%', there has to exist a row in mysql.user where user='wordpress' and host='%'.

You also mentioned that you are using MySQL Workbench. You must be using 'root'@'localhost'. That would usually have all rights and a password.

If you want to just allow anonymous SELECT against that table, first run this:

GRANT USAGE ON *.* TO 'wordpress'@'%';

This will place wordpress@'%' into mysql.user. Afterwards, GRANT SELECT ON store.catalog TO 'wordpress'@'%' should run just fine.

You will have to see what other wordpress entries are in mysql.user. This should show what SQL GRANT commands you need:

SELECT CONCAT('GRANT SELECT ON store.catalog TO ',userhost,';') GrantCommand
FROM
(
    SELECT CONCAT('''',user,'''@''',host,'''') userhost
    FROM mysql.user WHERE user='wordpress'
) A;

MySQL workbench: Cannot Connect to Database Server (ssh)

No you can't.

SSH is an operating system for remote administration, what is happening when you do ssh and directly enter to the database is because of a script or default shell changed in /etc/passwd for the specific user.

But for mariadb(mysql) (including workbench) this means nothing, cause in practice is very likely to do ssh root@yourserver and then mysql -pyourpass.

So ssh is not the protocol you are looking for.

Best Answer

Related Solutions

Mysql – Grant table privileges to a user connecting from any host

MySQL workbench: Cannot Connect to Database Server (ssh)

Related Question