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
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
After setting the password, you need to update the permission table