Several months ago I reported on Default Users in MySQL 5.7. With the addition of the sys schema the server needs an extra user to secure operations. The problem with extra users is that, if you are not aware of their existence and why they are needed, you may easily mismanage them. For example, you may have a cleanup routine that you run when you use a new server, and the routine may have a command like
DELETE FROM mysql.user WHERE user != 'root';
This was good up to MySQL 5.6. Then the sys schema was added, and
with it the user mysql.sys
, which may cause errors
if you try to re-create views in the sys schema.
The latest user sneaking below the radar is
mysqlxsys
. Like its predecessor, it …