Access denied to database even when privileges granted
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
Subject
Views
Written By
Posted
Access denied to database even when privileges granted
1059
June 23, 2020 01:01AM
505
June 23, 2020 01:08AM
419
June 23, 2020 05:37AM
425
June 23, 2020 05:59AM
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.