LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 07-31-2005, 12:56 AM   #1
I_AM
Member
 
Registered: Mar 2005
Posts: 103

Rep: Reputation: 15
mysql connection problem


Specs:
MySQL 4.11
cpanel 10.4 current
centos 4.1

I just did a restore of ALL accounts, many with mysql databases.

None of the databases are connecting and so they are not working server wide but mysql server is up and running ok itself.

I don't know where to start here

I have old-passwords in my.cnf and compiled apache with system mysql as well, still no good.

I tried (from another thread suggestion) upgrading ot EDGE, retrying to restore - no good. I'm back on CURRENT.

I restarted mysql a few times, /scripts/mysqlup --force and still doesn't work

/scripts/perlinstaller --force DBD::mysql
still doesn't work

/var/lib/mysql all owned by mysql as well which is good

reran /scripts/securetmp and that also did not fix it

Some example messages

DATABASE CONNECTION COULD NOT BE INITIALIZED!
ERROR: Could not select database. Please report this message to


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/spirit/public_html/iwant/act.php on line 44


No database selected


Critical database error - Selecting Database


Any one?
 
Old 07-31-2005, 01:19 AM   #2
btmiller
Senior Member
 
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,082

Rep: Reputation: 299Reputation: 299Reputation: 299
Did you restore the MYSQL database, which contains MySQL accounts, passwords, privilege levels, etc.? Can you connect as the MySQL root user?
 
Old 10-27-2005, 10:02 PM   #3
Maxman
LQ Newbie
 
Registered: Oct 2005
Posts: 4

Rep: Reputation: 0
My.cnf

edited

Last edited by Maxman; 10-27-2005 at 10:20 PM.
 
  


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 On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL/Java connection problem hudy Programming 3 06-23-2004 08:40 PM
php / mysql connection problem . MikeFoo1 Programming 3 05-02-2004 05:22 PM
mysql connection problem ckamheng Linux - Software 1 05-31-2003 01:30 AM
MySQL connection LINUX domain Socket problem herambshembekar Programming 2 10-18-2002 12:01 PM
MySQL server connection problem aeshley Programming 1 03-05-2002 09:59 PM


All times are GMT -5. The time now is 09:28 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration