MySQL Forums
Forum List  »  Connector/C++

Access denied to database even when privileges granted
Posted by: Eddy Lynch
Date: June 23, 2020 01:01AM

Hi, I am using MySQL C++ connector 8.0 and while I connect to the database successful my program crashed saying access denied for user to the database. I have the user INSERT UPDATE DELETE AND SELECT privileges. At the time of the crash the program was inserting into the database. However I do a check to see if the table is locked before doing anything by running the query SHOW OPEN TABLES. But I believe I don't need superuser permissions for that? Or am I wrong? I logged into the mysql shell with the same user and can verify that I can insert into the database from there so I'm starting to think it could be the SHOW OPEN TABLES?

Thanks,
Eddy

Options: ReplyQuote


Subject
Views
Written By
Posted
Access denied to database even when privileges granted
207
June 23, 2020 01:01AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.