Problems to upgrade MySQL
 

Hi

I have decided to upgrade the current version 3.25 to 4.0 of MySQL. I have downloaded the new version of MySQL.

When I tried to install:

rpm -i MySQL-server-4.0.14-0.i386.rpm MySQL-client-4.0.14-0.i386.rpm

It gave me error saying that there is a conflict with my old version of MySQL at that location. How can I resolve it?

I am now using RH8.0 with MySQL version 3.25 that comes with it. So, am I downloading the right one for RH8.0 to upgrade? I tried downloading mysql-standard-4.0.14-pc-linux-i686.tar to install also, is that meant for RH8.0 ? Or is it the other one called mysql-standard-4.0.14-unknown-linux-alphaev6.tar ?

Sorry for asking as I am new to Linux.

Thank you.

Regards
Edward Han

Try using "-U" not "-i" this will upgrade not install.

Hi

Finally I found out that Webmin has a section where you can install the software packages. I tried it and force it to over-write all existing software old version when upgrading. Seems like all the php, php-mysql, mysql-server, mysql-develop, mysql-shared, etc have successfully installed.

Now I am only facing with one last problem. That is getting mysql to work with my existing database. I can't seem to get it to work with username [mysql].

I had tried all these commands to change the password, given all the permissions [user, table] and yet still unable to work.

These are the commands I had tried:
mysql_safe --skip-grant-tables & [this is ok]
mysqladmin -u root password 'newpassword' [can't work]
killall mysqld [this is ok]
mysql-permission -u root [can't work]
mysql -u root -p [this is ok]

I have already created a user [mysql] and using the Webmin, I have created this user [mysql] to have all the permissions and rights for the database. How can I add this user to be the one accessing the database with a password instead of the root currently accessing without any password. I have tried the module config in Webmin using mysql as the username, it can login without password. But my php still can't work. I have checked with phpinfo.php, everything is displayed and seems to work for php.

Please advice if you can help. I am greatly appreciated!

Regards
Edward Han