After several years of using MySQL, I've encountered some security issue that quite baffle me.
I create a new database, and a new user, then grant CRUD rights only to the new DB, to this user.
But when I log in either via some MySQL client, or via CLI mysql, I can read and change data in all databases.
I double-checked myself and verified that I should have access only to single DB - still I can access every DB.
Is there any setting for MySQL that just cause it to ignore the security, and I have accidentally turned it on?
Thanks.