phpMyAdmin to modify MySQL password and phpMyAdmin unable to login solution

Source: Internet
Author: User
Tags php file phpmyadmin

Modify Password method

First, through the browser log into the phpMyAdmin console, click "Permissions",

Second, check the root user, and click "Edit Permission" later,

Third, in the open page in the middle position, find the "Change Password" column, enter the new password two times, and click the "Execute" button;


Note, after you modify your password and then use phpMyAdmin to log in, you will be prompted

phpMyAdmin in the MySQL password, phpmyadmin can not log on, the error is prompted:

Welcome to use phpMyAdmin 2.9.0
Probably reason of this are that you did not create configuration file. You are might want to use the setup script to create one.
Error

MySQL return:

#1045-access denied for user: ' Root@localhost ' (Using password:no)


solution is

Enter the XAMPP installation directory, modify the xampp/phpmyadmin/config.inc.php file, and locate and set the password to begin modifying, such as $cfg[' Servers ' [$i] [' password '] = ' 8888 ';

In addition, we click on "permission" can see the entire database of users as follows, you can click "Operation" again modify the user password, modify the config.inc.php accordingly.

Related Article

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.