Search code examples
mysqldelete-row

Logged on as one user and deleted records from a table. Another user logged in can still see records. How?

Details: I have 2 users (qa_user, dev_user) with the same privileges in the mysql.user table. I have no other settings for these 2 users in the following tables: mysql.db, mysql.host, mysql.tables_priv, mysql.columns_priv and mysql.procs_priv.

logged in as qa_user: I delete the records from a table address.

delete from address where zip = '10019';

I have another user, dev_user, logged in: That user can still see the records with zip = '10019' I've done everything with this user by logging out and logging back in.

I use TOAD as my IDE and connecting to the database server with both users.

Solution

  • Found the answer. With @TimBiegeleisen's commentary regarding caching. I looked into MySQL cache. 

    FLUSH QUERY CACHE;

    Running the SQL statement above, quickly cleared up the cache results and initialized the cache. More info can be found FLUSH_QUERY_CACHE