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';
Search WWH ::




Custom Search