Verify my permissions in a MySQL database (or table) -
in job, i've been granted access several databases, not same degree of liberty each of them. few minutes ago, attempting make update operation , got error message: error code: 1142. update command denied user 'clawdidr'@'192.168.1.105' table 'test_table'. db admin isn't around give me information i'm needing, i've figure out myself. so, question arises here is: there way verify on own (with query or else) databases or tables able use select, insert, update or delete operations?
try with: show grants current_user
Comments
Post a Comment