Wamp-PHPMyAdmin user problem mysql_connection & nbsp; connection to the database can be connected if the root user is used ~~ However, if you use a new user, the connection will fail ~~ What is the reason ?? I guess is the mysql configuration only allowed for root ?? But it cannot be changed ~~ Hope you can give me some advice ~~ Wamp-PHPMyAdmin user problems
Mysql_connection
If you use the root user, you can connect to the client ~~
However, if you use a new user, the connection will fail ~~
What is the reason ?? I guess is the mysql configuration only allowed for root ??
But it cannot be changed ~~ Hope you can give me some advice ~~ The WAMP permission of MySQL database users is shared:
------ Solution --------------------
Is PHPMyAdmin a problem or is it a problem of connecting to a database in php?
If it is the former
User Overview
User host password global permission authorization operation
Arbitrary % -- USAGE no edit permission export and export
Any localhost no USAGE no edit permission export and export
Root 127.0.0.1 no all privileges is edit permission export
Root: 1 no all privileges is edit permission export
Root localhost is all privileges. edit permission. edit permission. export permission.
Test localhost is USAGE no edit permission export and export
Root can add new users and set permissions.
The latter can be clearly described...
------ Solution --------------------
Use the user to log on to show grant.
If the permission is insufficient, execute
Grant all on *. * to user @ localhost;
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.