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:
- Locate the installation directory: G:\wamp\apps\phpmyadmin4.1.14
- Create a new folder: Config
- Open http://localhost/phpmyadmin/setup/
- 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!