Wamp-PHPMyAdmin user problems

Source: Internet
Author: User
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;

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.