Wamp-phpmyadmin User Issues

Source: Internet
Author: User
MySQL Database User WAMP permissions

Mysql_connection Connection Database
If you use the root user, you can connect to the ~ ~
But if you use one of my new user users will not connect ~ ~
Excuse me, what is the reason?? I guess is not MySQL configuration only allow root to use??
But it's not going to change ~ ~ hope the big God pointing it ~ ~


Reply to discussion (solution)

Is it a question of phpmyadmin or is there a link database inside PHP?

If it's the former,

User profile
User host password Global Permission authorization action
Any%--USAGE no Edit rights edit permission export Export
Any localhost no USAGE no edit permission edit permission Export Export
Root 127.0.0.1 No all privileges Edit Permissions edit permissions Export Export
Root: 1 No all privileges Edit Permissions edit permission Export Export
Root localhost is all privileges Edit Permissions edit permission Export Export
Test localhost is USAGE no edit permissions edit permission Export Export

Root is the one that can add new users and set permissions

The latter's words are more clearly described ...

What's wrong with your new user who authorized him?



Root localhost no all privileges is
User% is all privileges no

One is the root of a user is the first difference is the password ~~root no password, should not be the reason
The next one is authorization, as if it's a question of authorization.

What's wrong with your new user who authorized him?

Seems to be the issue of authorization, I look at ~ ~ Thank you ~ ~

What's wrong with your new user who authorized him?

Mysql_connect (): Access denied for user ' user ' @ ' localhost '
Seems to be wrong ~ ~ This is the fault of the newspaper ~ ~ should still be the user's problem, because the root and empty password is possible

Show grant after login with user; Look.
If the permissions are insufficient, execute the
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.