show/hide this revision's text 2 edited tags
show/hide this revision's text 1

Installer can't connect to MySQL on Debian

I'm trying to install Fogbugz 7.2.16 on a 64-bit Debian Lenny box running MySQL 5.0.51. I've created a fogbugz system user and MySQL user, and I can connect to MySQL from the command line as both root and the fogbugz user.

When I run the installer it prompts for MySQL connection details and then fails to go any further:

Failed to create user.
Trying out connections settings.  Connecting to MySQL on
localhost as fogbugz.
Unable to connect.  Was the password correct?
Configuration did not pass muster.

In the MySQL log I get the following, so it's trying to connect to the right place but failing:

38 Connect     Access denied for user 'root'@'localhost' (using password: YES)
39 Connect     Access denied for user 'fogbugz'@'localhost' (using password: YES)

Has anybody else seen this? I've tried creating the fogbugz database before running the installer and that made no difference. Also tried specifying IP instead of socket connection, also no difference.