Problems upgrading MySQL on Ubuntu, with Apache2/PHP4
 

Greetings all,

I'm trying to upgrade mySQL on an Ubuntu server. The previous version of MySQL was 3.23.56, running alongside Apache2 and PHP4. I wanted to upgrade MySQL, so I apt-get'ed the relevant packages:

$ sudo apt-get install mysql-server-4.1
$ sudo apt-get install php4-mysql


Everything should be hunky-dory, so I check out phpinfo.php - but this tells me I'm still using MySQL 3.23.56:

mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.56
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient


Weirder still, is when I log into phpmyadmin, it greets me with "Welcome to phpMyAdmin... MySQL 4.1.10a-Debian_2ubuntu..."
So at least, this seems to recognize the new version.

Have I missed some important step here? It seems that the upgrade of mysql worked, but that PHP isn't aware of the newer version. Any help would be greatly appreciated!