This will remove all local accounts from the mysql.user table that do not have passwords
In this example, it will drop 'localhost','gitlab','127.0.0.1', '::1', leaving just the 3 rows that have a password. This is what is suggested in the mysql harding guide.