Access PHP database, MySQL
Access denied for user ' * * * * * * (using Password:yes)
Why my server address is filled with the server address of the database, the database user name and password I also filled in the right
Always show this error, ask for expert guidance
------Solution--------------------
Do you have a MySQL client locally? Try it if you have one.
Mysql-h your MySQL ip-u you on the server side user-P Enter
Then enter the user's password
But I guess, there are eight or nine is the MySQL authorization is not done well ... Recommended LZ to study hard ... [email protected] means allow user to log on to MySQL on the IP machine
MySQL in the user table, there should be a record is
Host user
Your server IP you are on the server side of the user
------Solution--------------------
No permissions
------Solution--------------------
Search the keywords.
"MySQL arbitrary host login"
Http://hi.baidu.com/gdsoftware/blog/item/e42dccfcd9cb5187b901a08a.html
Maybe it'll solve your problem.
------Solution--------------------
Execute in MySQL
SQL Code
Grant all privileges on * * to root@ '% ' identified by ' your password ' with grant Option;flush privileges;