LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


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

Rep: Reputation: 15
Unhappy 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
 
Old 09-08-2003, 02:56 PM   #2
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

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

Original Poster
Rep: Reputation: 15
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
 
  


Reply


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-08-2008 12:48 AM
Do I need to upgrade mysql? clau_bolson Linux - Software 2 08-22-2005 11:09 AM
mysql 4.0.24 to mysql 4.1.12 upgrade problem tuxrules Slackware 7 08-13-2005 07:43 PM
Upgrade MySQL 3.23 to 4.0 Raggit Linux - Software 1 08-07-2005 04:50 PM
Upgrade Mysql, Socket problems!! djkoe Linux - Newbie 1 01-10-2004 08:49 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 10:44 PM.

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