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