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
946
June 23, 2020 01:01AM
461
June 23, 2020 01:08AM
379
June 23, 2020 05:37AM
375
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.