anonymous login in mysql?# Database - 数据库
j*y
1 楼
Hi, all:
In setting up the password for the root user, I have used the command
DELETE FROM user WHERE Host='localhost' AND User='';
It is used to delete the anonymous users, and prevent them from logging in.
Yet, when I use "mysql -u abc" to login, it still can be successful.
Haven't I deleted the anonymous users from the user tables? I have checked my
user table again, only "root" and "mysql" are present. No other users in the
table.
Then how can user "abc" to log in?
thanks for any suggestions
In setting up the password for the root user, I have used the command
DELETE FROM user WHERE Host='localhost' AND User='';
It is used to delete the anonymous users, and prevent them from logging in.
Yet, when I use "mysql -u abc" to login, it still can be successful.
Haven't I deleted the anonymous users from the user tables? I have checked my
user table again, only "root" and "mysql" are present. No other users in the
table.
Then how can user "abc" to log in?
thanks for any suggestions