I have the passwords entered into perhaps 50 locations I frequent and for most, but not all, of them my devices connect automatically when I'm in range. For some reason I don't understand, a few require me to enter the password again. I use WiFi in other locations for my two Kindles, my chromebook, and my cell phone.
I normally do my cell phone first and enter the information, including the password, in my Contacts. Then I can log on with a Kindle or my laptop without requesting a password again.
A few locations have a login page which is often, usually, more trouble than it's worth. If I want coffee I tend to go somewhere else.