Help - Search - Members - Calendar
Full Version: mysql error on connect
The Planet Forums > Control Panels > cPanel/WHM
yi0221
My MySQL can't connect any more after I update WHM and Apache.
I did't change any file.

What's the problem?

Regard
eth00
What error are you getting? Are you sure mysql is running? Quick and easy fix is probably to just run /scripts/upcp --force and then recompile apache.
yi0221
yes,I did that

/scripts/upcp --force

and mysql is working properly, I am able to connect to mysql.

-------------------------------------------------------------------
root@ [/]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 4.0.20-standard

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql>
-------------------------------------------------------------------

I still have problem to connect to database.
My XOOPS php was working fine on my server,
http://69.57.148.83/~goqootv/xoops/html/
But I got following messages:
Error [Xoops]: Unable to connect to database in file class/database/databasefactory.php line 34
I check the databasefactory.php and there was no changed.

Any ideas on how to connect to database and running again!

Regards,
eth00
Look in phpmyadmin and make sure the database exists, perhaps the permissions were changed or it was somehow deleted? That error makes it sound like the database just simply does not exist rather then mysql having trouble. If it does you should start looking at your server logs and see if it reports more information.
yi0221
The database are exists and permissions didn't changed or deleted.
Which server logs should I looking at?

Thanks for your help
cjc305
I have exactly the same problem. Any ideas, anyone?

Regards,
Jung
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.