LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 12-09-2002, 10:00 AM   #1
rosko
Member
 
Registered: Sep 2002
Distribution: RH8
Posts: 93

Rep: Reputation: 15
Mysql is hosed....can someone plz help


Hey all,
I have a big problem with my system. Last night I was trying to get phpmyadmin to work, and it told me I didn't have the mysql extensions installed. I found the php-mysql rpm off my RH8 cd and installed it....it worked fine. Then my problem was mysql. I can't login to my server from a bash at all. If I go to the mysql directory and attempt to login ./bin/mysql -u root -p and it tells me that it cannot connect to sock....basically tells me the server is not running when in fact it is. I tryed just using mysql safe, and it says there is already a mysql server running. How the hell do I completely uninstall and reinstall mysql? or Stop this "ghost" of mysql from using 3306? Please give me any advice, I'm at the end of my rope here.

oh...and now it tells me I don't have the php extentions for mysql installed....but if I try to reinstall them it says "package already installed".
 
Old 12-09-2002, 11:42 AM   #2
rosko
Member
 
Registered: Sep 2002
Distribution: RH8
Posts: 93

Original Poster
Rep: Reputation: 15
I tried doing the following.

rpm -qa | grep mysql

that command returned:
mysql-3.23..52-3
php-mysql-4.2.2-8.0.5


Then I tried rpm -e mysql-3.23..52-3
It said it cannot erase because of the dependency of php-mysql.

Then I tried rpm -e php-mysql-4.2.2-8.0.5

It returned the following:
cannot get exclusive lock on /var/lib/rpm/Packages
cannot open Packages index using db3 - Operation no permitted (1)
cannot open Packages database in /var/lib/rpm

Does this indicate I do not have enough priveleges to run the erase on a package?

THanks again.
 
Old 12-09-2002, 12:16 PM   #3
rosko
Member
 
Registered: Sep 2002
Distribution: RH8
Posts: 93

Original Poster
Rep: Reputation: 15
OK....so now I'm logged in as root and tried rpm -e on the php-mysql package.....and I get no response from my SSH client. It acts like it's doing something.....but never gives me my # back.....any ideas?
 
Old 12-09-2002, 04:21 PM   #4
lintadsl
LQ Newbie
 
Registered: Oct 2002
Posts: 25

Rep: Reputation: 15
Check your ps and make sure mysqld is not running.
Then you can do rpm -e.
Sounds like you want to make PHP works with Mysql DB.

Once you make your mysql runs and can access to DB without error, you can just complie PHP with enable mysql db.

Lint.
 
Old 12-09-2002, 04:44 PM   #5
rosko
Member
 
Registered: Sep 2002
Distribution: RH8
Posts: 93

Original Poster
Rep: Reputation: 15
Lint, I have no idea how to solve this...being a newb.

I have unistalled mysql and deleted all directories.....then reinstalled it and it will not let me start it up. It always throws the error that there is another mysql server running. What's more disturbing is I check the processes....and there is not one related to mysql. Any ideas??

Much appreciated
 
Old 12-09-2002, 06:17 PM   #6
rosko
Member
 
Registered: Sep 2002
Distribution: RH8
Posts: 93

Original Poster
Rep: Reputation: 15
Ok, I finally got php-mysql removed and mysql completely gone. I reinstalled mysql 4.0.5 beta from tar, and it works now, but php once again doesn't work. phpmyadmin says it needs the mysql extensions installed, but when I try to load the php-mysql rpm it doesn't work, it fails dependencies.
mysql is needed by php-mysql.x.x.x
libmysqlclient.so.10 is needed by php-mysql.x.x....

How can I get the php-mysql rpm to see that I already have mysql installed?
 
  


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
MySql Problems :( Help Plz NemoTheFish Linux - Software 18 02-17-2006 05:16 AM
plz plz solve my route mapping problem nedian123 Linux - Networking 1 07-12-2004 10:41 PM
mysql::DBD make problems - help plz pigsy Linux - Software 15 04-17-2004 03:48 PM
How can i create mysql.sock... plz HELP saeed Programming 1 08-16-2003 01:24 PM
PHP / MySQL problems, plz help! TIA! jerome187 Linux - Software 6 04-01-2003 04:15 PM


All times are GMT -5. The time now is 02:34 AM.

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