On Tuesday, March 29, 2005 21:29, bruce wrote: > hi... > > we're trying to install mysql/mysql-server (4.1.10a-1.i386) and are > running into some serious problems. we had mysql/server > (3.23.52-3.i386) running, but needed to go to the higher version... > > can someone tell us how/what we need to do to get this working > correctly. actually, if anybody's managed to do this, can you tell us > exactly what rpm packages you used? as you know, dealing with the > rpms gets into dependency hell, which we believe has a lot to do with > our issues... > > if you managed to get this version of mysql running on FC3, and you > built it from source, can you provide directions/pointers on what you > did, where you placed the resulting libs/etc... > > also, this has to be running with apache/php/perl/etc... > > thanks > > bruce
I use mysql primarily on RHEL3, but I just upgraded a FC2 box just to try it. I was able to upgrade it using the rpm's from dev.mysql.com. I did notice one thing. The rpm install didn't seem to kill the old mysqld properly, so I got an access denied right after the install. I ran the following as root: #killall mysqld #service mysql start After that I was then able to connect just fine. As far as perl, php, and apache, everything will continue to work without modification if you continue to use the old password hashes. You can force this. Refer to http://dev.mysql.com/doc/mysql/en/old-client.html, specifically the old-password option. To make perl work with the new passwords, all you need to do is build DBD::mysql from source. To do this, uninstall the dbd-mysql rpm if you have it installed. I can't remember the exact name because I don't use it. Then as root run: #perl -e shell -MCPAN cpan>install DBD::mysql Regards, -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]