 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
omikron
Joined: 28 Oct 2015 Posts: 10 Country: Germany |
|
Cannot connect to mysql DB |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
In order to get database schemas, users and roles, SQL Assistant by default queries mysql.user table. the message you posted shows
 |
 |
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.
 |
 |
select
SCHEMA_NAME, 'SC'
from
information_schema.SCHEMATA |
|
|
Thu Mar 10, 2016 10:06 am |
|
 |
|
|
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
|
|
|