Install phpmyadmin # 1045-Accessdeniedforuser 'root' @ 'localhost' on Ubuntu'

Use new gains install Ubuntu source phpmyadmin version is 2.11.3phpmyadmin official website has the latest version of the http://www.phpmyadmin.net installed, access http: // localhost/phpmyadmin login, use root Login Without Password, error # login 5-accessdeniedforuser 'root' @ 'localhost' (usi

Install phpmyadmin from Ubuntu

Version 2.11.3

Phpmyadmin official website has the latest http://www.phpmyadmin.net

After installation, access http: // localhost/phpmyadmin

Logon: Use root to log on without a password. An error occurs.

#1045-Access denied for user 'root' @ 'localhost' (using password: NO)

Find/etc/phpmyadmin/htpasswd. setup

You can use admin to log on without a password. After logging on, you can see a database information_schema (17 ).

You do not have the permission to create a database using admin. Think about the password set for root during mysql installation. It turns out that the password has been changed.

Now I have logged on to the database as root, and all permissions are available. We can see 2 databases information_schema (17) and mysql (17 ).

Installed files
/Etc/phpmyadmin
/Etc/phpmyadmin/apache. conf
/Etc/phpmyadmin/config. footer. inc. php
/Etc/phpmyadmin/config. header. inc. php
/Etc/phpmyadmin/config. inc. php
/Etc/phpmyadmin/lighttpd. conf

/Usr/share/phpmyadmin

/Var/lib/phpmyadmin
/Usr/share/phpmyadmin/docs.css
/Usr/share/phpmyadmin/translators.html
/Usr/share/phpmyadmin/Documentation.html