Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 09-07-2003, 07:03 PM   #1
Registered: Sep 2003
Location: Singapore
Distribution: Redhat 8.0
Posts: 93

Rep: Reputation: 15
Unhappy Problems to upgrade MySQL


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.

Edward Han
Old 09-08-2003, 01:56 PM   #2
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 68
Try using "-U" not "-i" this will upgrade not install.
Old 09-08-2003, 08:23 PM   #3
Registered: Sep 2003
Location: Singapore
Distribution: Redhat 8.0
Posts: 93

Original Poster
Rep: Reputation: 15

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!

Edward Han


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with MySQL on SuSE: Can't Connect (/var/lib/mysql/mysql.sock) neocookie Linux - Software 8 02-07-2008 11:48 PM
Do I need to upgrade mysql? clau_bolson Linux - Software 2 08-22-2005 10:09 AM
mysql 4.0.24 to mysql 4.1.12 upgrade problem tuxrules Slackware 7 08-13-2005 06:43 PM
Upgrade MySQL 3.23 to 4.0 Raggit Linux - Software 1 08-07-2005 03:50 PM
Upgrade Mysql, Socket problems!! djkoe Linux - Newbie 1 01-10-2004 07:49 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 11:47 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration