php - There is no root user in the mysql user table. Setting the root password will lead to anonymous access

Question

Now the root password is empty by default. Set the root password according to the online method
SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpass’);
After entering, it is an anonymous user, resulting in no permissions, so I deleted this anonymous user.
I found that there is no Root user when checking mysql users. What is the reason for this? The system is windows

Answer 1

show grnats for sgsl@'localhost' to see if the default super user is sgsl when you install it. If so, there is no need to configure root. The syntax for configuring the root password may be because you don’t have it. It is the root user that causes the failure

Answer 2

After setting the password, you need to update the permission table