Trying to run mysql I get:

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


So instead of trying to fix that, I tried installing the latest version of mysql. Which gets me:

rpm -i MySQL-3.23.53a-1.i386.rpm
error: failed dependencies:
MySQL conflicts with mysql-3.23.41-1
MySQL-server conflicts with mysql-server-3.23.41-1



How can I remove that older version if I don't have the original rpms that were used to install them?(--force and --replacepkgs don't fix the conflict either)

I had this very same error message in the past. For some reason my mysql.sock was not located in the right path. The easiest way to solve this is to put a symbolic link. This is what you can do to solve that problem.

login as root
Do a locate mysql.sock
replace the below with the path to your mysql.sock
ln -s /pathto/mysql.sock /tmp/mysql.sock

Hope this helps

And to upgrade the command would be

rpm -U

instead of

rpm -i

Looks like I don't have mysql.sock or ANY .sock files (I did 'locate *.html' and got lots of results, so locate _is_ working)


[root@/home/wp]# locate mysql.sock
[root@/home/wp]# locate *.sock




And I still have conflicts even when trying to upgrade.



[root@/home/wp]# rpm -U MySQL-3.23.53a-1.i386.rpm
error: failed dependencies:
MySQL-server conflicts with mysql-server-3.23.41-1
libmysqlclient.so.10 is needed by mysql-server-3.23.41-1
libmysqlclient.so.10 is needed by perl-DBD-MySQL-1.2216-4
libmysqlclient.so.10 is needed by php-mysql-4.0.6-15
[root@/home/wp]# rpm -U --force MySQL-3.23.53a-1.i386.rpm
error: failed dependencies:
MySQL-server conflicts with mysql-server-3.23.41-1
libmysqlclient.so.10 is needed by mysql-server-3.23.41-1
libmysqlclient.so.10 is needed by perl-DBD-MySQL-1.2216-4
libmysqlclient.so.10 is needed by php-mysql-4.0.6-15
[root@/home/wp]#

http://forum.rackshack.net/showthread.php?...t=upgrade+mysql

All the best

1. Save everything in one directory
2. cd to directory
3. rpm -Uvh *.rpm --force --nodeps
4. Smile, you are a hero

hey thanks a lot, it's running now.