I just recently setup a VPS III server with 1and1.com. Below are the server particulars: OS: fedora-core-4-x86_64 Packages: devel-fc4-x86_64 / 20060804 fc4-x86_64-custom-config / 20061205 fc4-x86_64-psa8-key / 20061205 fc4-x86_64-psa8-language / 20061205 mod_perl-fc4-x86_64 / 20060411 mod_ssl-fc4-x86_64 / 20060804 mysql-fc4-x86_64 / 20060804 php-fc4-x86_64 / 20060220 psa-bu-fc4-x86_64 / 20060614 psa-fc4-x86_64 / 20060614 psa-vault-fc4-x86_64 / 20060611 I have everything up and running and I just noticed that the version of MySQL is 4.1.20. I want to upgrade to 5.0.45 (latest stable). The problem is I have no clue how to begin. I have spent hours and hours looking and trying things, but nothing is working. There is no data that I need to keep, basically start from scratch. The current "installation" is located in the /var/lib/mysql directory. Does anyone have "simple" instructions on how to upgrade, or install the latest version of MySQL? I know enough to be dangerous. Thanks in advance!
I found an rpm for FC 4 here: http://rpm.pbone.net/index.php3/stat/4/idpl/4577242/com/mysql-5.0.45-1.fc4.remi.i386.rpm.html
Boy was I excited when I saw the response. I removed the old installation and installed the 2 rpm files. rpm -ivh ftp://ftp.pbone.net/mirror/remi.collet.free.fr/rpms/fc4.i386/mysql-libs-5.0.45-1.fc4.remi.i386.rpm rpm -ivh ftp://ftp.pbone.net/mirror/remi.collet.free.fr/rpms/fc4.i386/mysql-5.0.45-1.fc4.remi.i386.rpm Now when I go to log in I am getting the following error. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Any ideas?
Any errors in your logs? Any errors when you restart MySQL? What's the output of Code: ps aux | grep -i mysql and Code: netstat -tap ?
Actually I figured out my problem late last night. It is a 64 bit server. Here is the complete upgrade script that worked for me. # Install yum rpm -ivh http://update.onlinehome-server.com...ra/RPMS/python-elementtree-1.2.6-4.x86_64.rpm http://update.onlinehome-server.com.../Fedora/RPMS/python-sqlite-1.1.6-1.x86_64.rpm http://update.onlinehome-server.com...ora/RPMS/python-urlgrabber-2.9.6-1.noarch.rpm http://update.onlinehome-server.com/fedora/linux/core/4/x86_64/os/Fedora/RPMS/yum-2.3.2-7.noarch.rpm # Remove old MySQL yum remove mysql # CD to tmp cd /tmp/ # Get new MySQL files wget http://dev.mysql.com/get/Downloads/....glibc23.x86_64.rpm/from/http://mysql.he.net/ wget http://dev.mysql.com/get/Downloads/....glibc23.x86_64.rpm/from/http://mysql.he.net/ wget http://dev.mysql.com/get/Downloads/....glibc23.x86_64.rpm/from/http://mysql.he.net/ wget http://dev.mysql.com/get/Downloads/....glibc23.x86_64.rpm/from/http://mysql.he.net/ wget http://dev.mysql.com/get/Downloads/....glibc23.x86_64.rpm/from/http://mysql.he.net/ # Install new MySQL files rpm -U MySQL-server-5.0.45-0.glibc23.x86_64.rpm MySQL-client-5.0.45-0.glibc23.x86_64.rpm MySQL-devel-5.0.45-0.glibc23.x86_64.rpm MySQL-shared-5.0.45-0.glibc23.x86_64.rpm MySQL-shared-compat-5.0.45-0.glibc23.x86_64.rpm Thanks for the help! Hopefully this can help someone else.
