php - There is no root user in the mysql user table. Setting the root password will lead to anonymous access
PHP中文网
PHP中文网 2017-05-16 12:59:04
0
2
561

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

PHP中文网
PHP中文网

认证0级讲师

reply all(2)
phpcn_u1582

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

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template