Upgraded MySQL 4.1.12 to 5.1 but still showing old version

B

blitzer

Verified User
Joined
May 12, 2009
Messages
35
Hi Guys,

Appreciate any help here as soon as possible.

Few weeks back, upgraded php4 to php5.
Client suddenly couldnt login to phpmyadmin using their db user/pass

After the usual checking on DA forums, decided to upgrade mySQL to solve the problem. Used custombuild to upgrade mySQL to 5.1 including the re-building of php. All went well with no errors. i followed this guide

http://help.directadmin.com/item.php?id=240

However, now the phpmyadmin still shows the error

"You should upgrade to MySQL 5.0.15 or later."

And running the following command gives me

[root@inix custombuild]# rpm -qa | grep 'MySQL-'
MySQL-server-4.1.12-1
MySQL-shared-5.1.58-1.glibc23
MySQL-devel-5.1.58-1.glibc23
MySQL-client-5.1.58-1.glibc23

I have tried running the build mysql several times but it still shows the old server.

Hope there is someone who can help me.
Many thanks in advance.
 
That should help.

Code: 
rpm -e MySQL-server-4.1.12-1

cd /usr/local/directadmin/custombuild
./build update
./build mysql d
./build php n


Update us with results if any.
 
Hi Alex,

Thanks for your advice.

This is the error message i encountered

[root@inix admin]# rpm -e MySQL-server-4.1.12-1
error reading information on service mysql: No such file or directory
error: %preun(MySQL-server-4.1.12-1.i386) scriptlet failed, exit status 1
 
Hi,

it still doesnt work..

[root@inix admin]# rpm -e --force --nodeps MySQL-server-4.1.12-1.i386
rpm: only installation, upgrading, rmsource and rmspec may be forced

When i try the methods in the url u gave me, it doesnt work as well

[root@inix lib]# rpmdb_verify Packages
bash: rpmdb_verify: command not found
 
Try then:

Code: 
# rpm -qa | grep -i ^mysql | xargs rpm -e --nodeps
# cd /usr/local/directadmin/custombuild
# ./build update
# ./build mysql d
# ./build php n
 
Hi Alex,

Error as follows

[root@inix admin]# rpm -qa | grep -i ^mysql | xargs rpm -e --nodeps
error reading information on service mysql: No such file or directory
error: %preun(MySQL-server-4.1.12-1.i386) scriptlet failed, exit status 1
xargs: rpm: exited with status 255; aborting

Thanks for everyone's help by the way.
Hope this can be resolved soon.
 
Hi Alex,

[root@inix custombuild]# rpm -qa | grep -i ^mysql
MySQL-server-4.1.12-1
 
Some errors when i tried to build mysql again

[root@inix custombuild]# ./build mysql d
Cannot find /usr/bin/mysqldump
Found /usr/local/directadmin/custombuild/mysql/MySQL-client-5.1.58-1.glibc23.i386.rpm
Found /usr/local/directadmin/custombuild/mysql/MySQL-devel-5.1.58-1.glibc23.i386.rpm
Found /usr/local/directadmin/custombuild/mysql/MySQL-server-5.1.58-1.glibc23.i386.rpm
Found /usr/local/directadmin/custombuild/mysql/MySQL-shared-5.1.58-1.glibc23.i386.rpm
Stopping mysqld ...
Shutting down MySQL. [ OK ]
Cannot find /usr/bin/mysql, installing MySQL
Preparing... ########################################### [100%]
file /etc/init.d/mysql from install of MySQL-server-5.1.58-1.glibc23 conflicts with file from package MySQL-server-4.1.12-1
file /usr/bin/my_print_defaults from install of MySQL-server-5.1.58-1.glibc23 conflicts with file from package MySQL-server-4.1.12-1
file /usr/bin/myisam_ftdump from install of MySQL-server-5.1.58-1.glibc23 conflicts with file from package MySQL-server-4.1.12-1
file /usr/bin/myisamchk from install of MySQL-server-5.1.58-1.glibc23 conflicts with file from package MySQL-server-4.1.12-1
file /usr/bin/myisamlog from install of MySQL-server-5.1.58-1.glibc23 conflicts with file from package MySQL-server-4.1.12-1
file /usr/bin/myisampack from install of MySQL-server-5.1.58-1.glibc23 conflicts with file from package MySQL-server-4.1.12-1


and it ended with

Starting MySQL [ OK ]
Giving mysqld a few seconds to start up...
This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1

Got a failure from command:
/usr/bin/mysql --no-defaults --force --user=da_admin --host=localhost --password=******* --database=mysql
Please check the above output and try again.
 
Actually i dont remember the rpm command for uninstall a software (google should help you with it) but you should try yum -y remove MySQL-server-4.1.12-1 or yum remove MySQL-Server and then rebuild mysql using custombuild.

Regards
 
same error..

[root@inix custombuild]# yum -y remove MySQL-server-4.1.12-1
Loading "installonlyn" plugin
Setting up Remove Process
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Package MySQL-server.i386 0:4.1.12-1 set to be erased
--> Running transaction check

Dependencies Resolved

=============================================================================
Package Arch Version Repository Size
=============================================================================
Removing:
MySQL-server i386 4.1.12-1 installed 26 M

Transaction Summary
=============================================================================
Install 0 Package(s)
Update 0 Package(s)
Remove 1 Package(s)
Downloading Packages:
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
error reading information on service mysql: No such file or directory
error: %preun(MySQL-server-4.1.12-1.i386) scriptlet failed, exit status 1

Removed: MySQL-server.i386 0:4.1.12-1
Complete!
 
Hi Alex,

It shows the same error :(

[root@inix admin]# rpm -ev --nodeps MySQL-server-4.1.12-1
error reading information on service mysql: No such file or directory
error: %preun(MySQL-server-4.1.12-1.i386) scriptlet failed, exit status 1
 
OK, then try

Code: 
rpm -ivh --force http://files.directadmin.com/services/5/MySQL-server-4.1.12-1.i386.rpm
rpm -ev --nodeps MySQL-server-4.1.12-1
 
You must log in or register to reply here.
Back
Top