Mysql upgrade problems:Plesk 7.5 fedora3

[AISPL]

I tried upgrade from 3.23.58 to 4.0.26 , doing rmp -Uvh for all four packages rpm(server,client,shared,devel).
Subsequently doing
-------------------------------------------------------------------------------------------------------------
# mysql --version
# mysql Ver 12.22 Distrib 4.0.26, for pc-linux-gnu (i686)

# rpm -qa | grep -i mysql
MySQL-server-4.0.26-0
MySQL-devel-4.0.26-0
php-mysql-4.3.11-2.8
perl-DBD-MySQL-2.9003-5
MySQL-shared-compat-4.0.26-0
MySQL-client-4.0.26-0
-------------------------------------------------------------------------------------------------------------

I could not connect to mysql, mysqldlog was
-----------------------------------------------------------------------------------------------------
051202 08:14:32 mysqld started
051202 8:14:32 Can't start server: Bind on TCP/IP port: Address already in use
051202 8:14:32 Do you already have another mysqld server running on port: 3306 ?
051202 8:14:32 Aborting
051202 8:14:32 /usr/sbin/mysqld: Shutdown Complete
051202 08:14:32 mysqld ended
-----------------------------------------------------------------------------------------------------------------


I serached and Followed http://www.whoopis.com/howtos/php5-mysql4-FC3-rpm.html
Error changed
---------------------------------------------------------------------------------------------------------------------
051202 08:36:24 mysqld started
Fatal error: Can't change to run as user 'mysql'. Please check that the user exists!
051202 8:36:26 Aborting

051202 8:36:26 /usr/sbin/mysqld: Shutdown Complete

051202 08:36:26 mysqld ended
------------------------------------------------------------------------------------------------------------
Then upon /sbin/reboot, error changed to
-----------------------------------------------------------------------------------------------------------
051202 22:47:54 mysqld started
051202 22:47:54 Warning: Can't create test file /var/lib/mysql/air838.lower-test
/usr/sbin/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)
051202 22:47:54 Aborting
051202 22:47:54 /usr/sbin/mysqld: Shutdown Complete
051202 22:47:54 mysqld ended

PS (air8383 is my server name)


Any help will be appreciated

 

[AISPL]

Well overcomed that with enforcing --force with rpm -Uvh

Now as in the process i have not backed up databases.(Since I have not created any) and deleted va/lib/mysql, i am getting this error now, when accessing my plesk interface.

ERROR: Unable to query: Table 'psa.misc' doesn't exist 0: /usr/local/psa/admin/plib/common_func.php3:203 psaerror(string "Unable to query: Table 'psa.misc' doesn't exist") 1: /usr/local/psa/admin/plib/common_func.php3:390 db_query(string "select param, val from misc") 2: /usr/local/psa/admin/plib/class.Session.php:113 get_param(string "login_timeout") 3: /usr/local/psa/admin/auto_prepend/auth.php3:139 Session->Session()

I am very new to plesk. (two days back i got one server on plesk)It was hard to note that plesk uses mysql table for login. Ensim and others does not. What will happen if some user doesnot want mysql and stop it to have memory. Plesk will not work.

Please help.