I’m on Debian Linux, installed MySQL, and moving my WordPress blog over from Windows to Linux. Easy, no doubt. But not so. Once I had MySQL installed, WordPress and Apache configured, I couldn’t get it to work. I kept getting this error: Your PHP installation appears to be missing the MySQL which is required …
This was another kicker. I’ve done my MySQL install, everything’s cooking along and mysqld is starting up on boot. I downloaded the Debian MySQL Navigator package. I moved across my Windows folder with my WordPress blog files in it. Since it’s a self contained application, I knew it should just “find” itself so long as I did my database CREATE and added a user, just as they describe in their install docs. [Tangent: I saw a lot of snotty comments about the 5 Minute Installation document while trying to fix this one – the 5 Minute worked as promised on my Windows install, so I blame my need for the detailed one on my own limitations, not the WordPress folks!]
This is one of those extra long errors which is easy to Google but the suggestions I got all related to (a) adding PHP(-MYSQL) packages or (b) editing the php.ini file. My biggest hurdle was to figure out where the heck the modules were!? On Windows, your php.ini file is full of commented-out extensions, which you activate as necessary. My install of PHP4 on Debian had a blank extensions section (beyond examples). So I knew I needed to call the mysql.so file, so uncommented the example (!), and then went hunting for the file. It was in a weird directory (/usr/lib/php/20020429/) which I added to the extensions = directory line. A quick restart of Apache2ctl and I was connected to MySQL and could move on to the WordPress install.
I felt this fellow’s pain, since his guess was so close (php.ini instead of apache.conf). I’m leaving it as is, since it’s working, but am going to have to look further to see how to get extensions, and determine why this file (from April 29, 2002?) is in such a weird place and whether it needs updating.