Apache Friends Support Forum

Hi, I just installled XAMPP, but when I start it, there is no connection to the MYSQL.The XAMPP status looks as given below.

MySQL database DEACTIVATED
PHP ACTIVATED
Perl ACTIVATED
Common Gateway Interface (CGI) ACTIVATED
Server Side Includes (SSI) ACTIVATED
PHP extension »eAccelerator« DEACTIVATED see FAQ
PHP extension »OCI8/Oracle« DEACTIVATED see FAQ

How do I resolve this? Please note that before xampp,I had already installed php,mysql and apache, and because php could not connect to the MYSQL I installed XAMPP.Also, when I start the xampp, it says that some mysql agent is already running.Is there a conflict? What should I do to resolve this?

but when I start it,

How did you do this?

Like this:

sudo /opt/lampp/lampp start

I work in Ubuntu btw.

Did you see anything in the logfiles?

What should I look for in the logfiles? Where are they probably located?

This is what I saw in error_log file:

[Thu Aug 16 12:51:07 2007] [notice] Digest: generating secret for digest authentication ...
[Thu Aug 16 12:51:07 2007] [notice] Digest: done
[Thu Aug 16 12:51:08 2007] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Aug 16 12:51:08 2007] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Thu Aug 16 12:51:08 2007] [notice] Apache/2.2.2 (Unix) DAV/2 mod_ssl/2.2.2 OpenSSL/0.9.8b PHP/5.1.4 mod_apreq2-20051231/2.5.7 mod_perl/2.0.2 Perl/v5.8.7 configured -- resuming normal operations
[Thu Aug 16 12:59:08 2007] [notice] caught

I have exactly the same problem; xampp has been installed yesterday. Everything went well. Today mysql doesn't want start. Or it is started but there is the message 'MySQL database DEACTIVATED

When i try to log in on the phpmyadmin page i get this:

Error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

same error message in the logfile as 'truth_seeker'

The things i have done yesterday is running this security command 'lampp security' and filling in some passwords.
Afterwards i imported a Joomla database and everything was working fine. For one day.

Is it possible that i changed some settings that should bot have been changed?

Please see this thread - it might help you as well.

Thanks. I am not using xampp now. I just connected PHP directly to MYSQL.Also, I think xampp is not so useful for big projects.