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
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
What is the HOST column of the User table in mysql?
WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 2956 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC