Database Reference
In-Depth Information
| user1 | % |
| user2 | %.example.com |
| user3 | _.example.com |
+-------+---------------+
2. To remove an identified account, use
DROP
USER
:
mysql>
DROP USER 'user1'@'%';
mysql>
DROP USER 'user3'@'_.example.com';
Alternatively, rename an account to make the host part more specific:
mysql>
RENAME USER 'user2'@'%.example.com' TO 'user2'@'host17.example.com';