SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Cannot connect to mysql DB

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Cannot connect to mysql DB
Author Message
omikron



Joined: 28 Oct 2015
Posts: 10
Country: Germany

Post Cannot connect to mysql DB Reply with quote
Hello,
I am trying to connect to mysql using native mode (libmysql.dll is chosen from the Workbench folder) but after the connection I see just the error message:

Prepare: MySQL Error (1142): mysql_stmt_prepare
Client: 5.6.10
Server: 5.5.46-0+deb8u1
SELECT command denied to user 'ita'@'identisk.omikron.net' for table 'user';

select
SCHEMA_NAME, 'SC'
from
information_schema.SCHEMATA

union all
select
concat('''',user,'''@''',host,''''),'SL'
from
mysql.user

Here is the about window from Mysql Workbench:
MySQL Workbench CE for Windows version 5.2.47 revision 10398
Configuration Directory: C:\Users\ad.OMIKRON\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft (build 9200), 64-bit
CPU: 4x Intel(R) Core(TM) i7-3520M CPU @ 2.90GHz, 7.9 GiB RAM
Active video adapter Intel(R) HD Graphics 4000
Installed video RAM: -1984 MB
Current video mode: 1920 x 1200 x 4294967296 Farben
Used bit depth: 32
Driver version: 10.18.10.4252
Installed display drivers: igdumdim64.dll,igd10iumd64.dll,igd10iumd64.dll,igdumdim32,igd10iumd32,igd10iumd32
Current user language: Deutsch (Deutschland)
Thu Mar 10, 2016 8:41 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Reply with quote
In order to get database schemas, users and roles, SQL Assistant by default queries mysql.user table. the message you posted shows

Quote:
SELECT command denied to user 'ita'@'identisk.omikron.net' for table 'user';



Please request SELECT permissions for the user table. If that's something that absolutely cannot be done, you can workaround the issue by modifying "Schemas (MySQL)" query in SQL Assistant options to the following simple query. That would help but with reduced functionality.

Code:
select
   SCHEMA_NAME, 'SC'
from
   information_schema.SCHEMATA

Thu Mar 10, 2016 10:06 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.