Upgrading MySQL

[lcplgriffin]

Hello out there. I installed FC2 two months ago, and it came with MySQL v3.something...
I would like to upgrade it to the production version 4 since that is what the MySQLAdministrator fully supports. I downloaded the correct rpm from MySQL.com and tried running the upgrade option, and it spat this out.

[root@localhost Applications]# rpm -U MySQL-server-4.0.20-0.i386.rpm
warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.9003-4
libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-20030510-4.1
libmysqlclient.so.10 is needed by (installed) php-mysql-4.3.8-2.1

Should I just uninstall the current version and do a fresh install? I'm afraid of running the install option with a current version on my box, since i hear that leads to more problems...Thanks for any help

[jeru]

that is because those dependancies are built for that version of mysql......

If you upgrade to the 4x series and want to stay as close to home as possible. Read this howto;

http://fedoranews.org/contributors/tony_smith/mysql/

there are a few changes, but they are relatively obvious as to what you need to change to follow that set of instructions. If not, ask.

your other option is to break off completely from the fedora packages and start doing everything yourself. Come FC3 I believe redhat/fedora have now decided that the new license is acceptable to package with the product. Other distro's like Debian have been packaging the 4.x series for some time now.

[nigeledge]

Great link. Thanks for that.

[mbhahn]

ok, If I can step in here.

I upgraded Mysql to 4.x via Tony's artical. everything work out fine. I ran all the tests for Mysql no probs, I installed phpmyadmin -no probs, I can start and stop the server -no probs, I created a simple php script to quary mysql -no probs, I can create databases -no prob,

when I go to install either phpBB, or Pmachine now I have problems.
phpBB errors out saying "cannot connect to the database"
and Pmachine seems to be able to be having the same problems.

I have searched Hi and Low for A solution and have tried various tips. Any insight would be really helpful. I am running FedoraCore2 .

-Mike

[mbhahn]

OK, so I finally figured it out - THANK GOD -

Tony Smiths guide to upgrading Mysql works great- Depending on your system you my need to make some minor tweaks, but all in all it's good stuff. Here are the problems I had:
Everything went great till I had to rebuild the programs I removed, rebuilding php asked for alot of development packages I didnt have, I just used YUM to install them.
It took me a while to figure out that I was trying to rebuild ( hanging head in shame) an older version of PHP then I had on my system- Duh!
After everything was put back in place MySql started and ran like a charm.
Don't forget to follow Mysql's Post-Installation (http://dev.mysql.com/doc/mysql/en/Post-installation.html) guide afterwards.

The problem I was having as stated in my previous post was a Host error. For phpBB I needed to create a host that matched the name of my sever, and not use localhost like I could under BSD. As for both of these programs I had to manually create the database before I installed them, unlike other setups where they could be created by the install script.

-Mike

[jeru]

is it saying 'permission denied'?

Some applications with come into the hostname or serverip and some will use the loopback/localhost/127.0.0.1. Depending on the mysql account permissions you made for phpbb.... You might just have 2 things trying to get in on 2 different interfaces. One has permission and one does not.

EDIT: ooops, guess you figured out that this was the case while I was replying ;)