I gave up trying to get MySQL to work so I'm using PostgreSQL instead. I can actually connect using the postgres user because the password is all lower case. When I log in with a user that has upper case letters and special characters I get an error message with "... password authentication failed for user ..." I can log into the SQL interpreter (psql) using the password without a problem. Are the libraries mangling the password before sending it over to the server? Also, I've using MD5 encryption for the passwords. My pg_hba.conf looks like this
host all all 127.0.0.1/32 md5
with lines for other hosts as well. I can log in to PgAdmin III on the client with this user/password, but not phpPgAdmin. I *can't* log in with pgpPgAdmin and user postgres.
My versions: Laz 1.0.4 / FPC 2.6.0 / WinXP (client) / CentOS 6.3 (server) / PG 8.4.13