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?


Options: ReplyQuote

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

Sorry, you can't reply to this topic. It has been closed.

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.