Wamp phpMyAdmin error #1045-access denied for user root@locahost fixed!

Source: Internet
Author: User
Tags phpmyadmin

Here's the video:

Https://www.youtube.com/watch?v=iA_UYg5MLZk

StackOverflow Solution here: http://stackoverflow.com/questions/19482371/fix-access-denied-for-user-rootlocalhost-for-phpmyadmin

The connection is very simple here!

Baidu search the words directly to modify how many lines how many lines ....

Here's a brief summary:

    1. Locate the installation directory: G:\wamp\apps\phpmyadmin4.1.14
    2. Create a new folder: Config
    3. Open http://localhost/phpmyadmin/setup/
    4. Select New server:

5. Encryption method: Default is empty, save.

Now in the directory you just created, Config sees that a new PHP file has been generated

Find the same file renamed in the same sibling directory.

And then copy the file that was just generated.

Find $cfg[' Servers ' [$i] [' allownopassword '] = True in the original file; Copy, paste in a new file

The final configuration file is:

<?PHP/** Generated configuration file * Generated by:phpmyadmin 4.1.14 setup Script * Date:sat, 2015 19:51:42 +0200 *//*Servers Configuration*/$i= 0;/*server:localhost [1]*/$i++;$cfg[' Servers '] [$i[' verbose '] = ';$cfg[' Servers '] [$i[' host '] = ' localhost ';$cfg[' Servers '] [$i[' port '] = ';$cfg[' Servers '] [$i[' socket '] = ';$cfg[' Servers '] [$i[' connect_type '] = ' TCP ';$cfg[' Servers '] [$i[' extension '] = ' mysqli ';$cfg[' Servers '] [$i[' auth_type '] = ' cookie ';$cfg[' Servers '] [$i[' user '] = ' root ';$cfg[' Servers '] [$i[' password '] = ';$cfg[' Servers '] [$i[' allownopassword '] =true;/*End of servers configuration*/$cfg[' blowfish_secret '] = ' 55bd072aa73ba9.57946818 ';$cfg[' defaultlang '] = ' en ';$cfg[' serverdefault '] = 1;$cfg[' uploaddir '] = ';$cfg[' savedir '] = ';?>

Effect:

Wamp phpMyAdmin error #1045-access denied for user [email protected] fixed!

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.