cannot login a user on phpmyadmin
Hi,....firs sorry for my english..
I'm tryng to install and configure LAMP solution on my UBUNTU. i have installed all the software needed, and i want to create some user in phpmyadmin to admnistrate his own database.
i insert a username( for example alex) a passoword(es: 12345) and at the voice "host" i select from the combobox "ANY HOST". I though that the user alex can log-in on phpmyadmin from every host.
But when i tried to login with username alex i receive the error "#1045 Cannot log in to the MySQL server"...that error from any host i try to connect(local or not).
If I choose "local" instead of "any host" i can login.....from any host(local or remote).....that make me a bit confused...
someome...can help me to undestand how it works?......what it means to select "any host" instead local?
in a professional enviroment what a have to choose? local....any host or other?