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 ~~
WAMP permission for MySQL database users
Share:
------ 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 [email protected];