Wamp-PHPMyAdmin user problems

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

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.