What is the HOST column of the User table in mysql?

Execute use mysql; then execute show tables; you can see all the tables in mysql
Execute desc user; you can see the table structure of user
You can see that host is a column in the user table , Execute select host, user, password from user; to find out the specific content of these columns
picture
Execute update user set host=’%’ where user=’ root’; You can add a record where host is% and user is root
Execute select host from user where user=’root’ to query the following results
picture

Leave a Comment

Your email address will not be published.