Login system tutorial? / PMA #2002 error

[Fredrikmikael]

hello after installing PMA(phpmyadmin) on my website, every time i attempt to log in i get the error saying
#2002 Cannot log in to the MySQL server

 

What is the issue, and how do i solve it ?

 

Also, are there any good tutorials you could recommend for making a login system for a website.

[Bradleywh]

Are you using Xamp, appache etc? You need to set the username and password under security before you can login.

[Fredrikmikael]

Are you using Xamp, appache etc? You need to set the username and password under security before you can login.

i just put the phpmyadmin directly on the site.

[Bradleywh]

Try opening the console and typing: # mysqladmin -u root password your-password.

[rashdanml]

IIRC, phpmyadmin needs to be configured with the right MySQL root user/password when it's installed, or at least, configured with a limited phpmyadmin user/password with specific permissions (doing anything as root on a server is dangerous). 

 

For a Linux server: http://wiki.phpmyadmin.net/pma/Quick_Install

Read it word for word, as parts of it aren't applicable for every scenario. 

 

To actually create a login system, assuming Phpmyadmin and MySQL are setup correctly: http://www.phpeasystep.com/phptu/6.html