Wamp-PHPMyAdmin user problems MySQL database user WAMP permission
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 ~~
Reply to discussion (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...
What error is reported? has your new user authorized him?
Root localhost no all privileges is
User % is all privileges no
One is root and the other is user. The first difference is the password ~~ Root does not have a password. this is probably not the reason.
The one next is authorization, which seems to be a problem with authorization ~~ Let me take a look ~~
What error is reported? has your new user authorized him?
It seems to be an authorization issue. let me take a look at it ~~ Thank you ~~
What error is reported? has your new user authorized him?
Mysql_connect (): Access denied for user 'user' @ 'localhost'
It seems wrong ~~ This is an error ~~ It should still be a user problem, because the root and empty passwords are acceptable.
Use the user to log on to show grant.
If the permission is insufficient, execute
Grant all on *. * to user @ localhost;