In MySql, how to see all possible users?
At yesterday, I tested how to create users and grant privileges to them. Then there are so many users. So I deleted using
Delete * from mysql.user
Then, no user is displayed in the user table. But I think they still are. When I create a user
Create user user1@localhost
It is said that user1 cannot be created. I have to use drop user before I create a new user.
Today, I can not use MYsql.Whenever I enter password, it automatically shutdown. May be because I have deleted root user.
Now, I have to reinstall MySQL?
How to see user lists?
How to delete users?