'42000SELECT command denied to user' error when connecting to database in Reverse Engineering wizard (4245328)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

'42000SELECT command denied to user' error when connecting to database in Reverse Engineering wizard
Description

The following error appears in the Reverse Engineering Wizard, when trying to connect to MySQL 5.1 (KACE database).

'Source: Toad Data Modeler - Internal errpr
Scipt: REDataMigratorDBMY51
Description:
#42000SELECT command denied to user 'user_name'@ip_address' for table 'db''
Resolution

Please ensure the user in question has SELECT permissions granted to the database

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title