Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - General
User Name
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.


  Search this Thread
Old 07-31-2005, 01:56 AM   #1
Registered: Mar 2005
Posts: 103

Rep: Reputation: 15
mysql connection problem

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

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, 02:19 AM   #2
Senior Member
Registered: May 2004
Location: In the DC 'burbs
Distribution: Arch, Scientific Linux, Debian, Ubuntu
Posts: 4,265

Rep: Reputation: 369Reputation: 369Reputation: 369Reputation: 369
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, 11:02 PM   #3
LQ Newbie
Registered: Oct 2005
Posts: 4

Rep: Reputation: 0


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


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 09:40 PM
php / mysql connection problem . MikeFoo1 Programming 3 05-02-2004 06:22 PM
mysql connection problem ckamheng Linux - Software 1 05-31-2003 02:30 AM
MySQL connection LINUX domain Socket problem herambshembekar Programming 2 10-18-2002 01:01 PM
MySQL server connection problem aeshley Programming 1 03-05-2002 10:59 PM

All times are GMT -5. The time now is 01:17 AM.

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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration