mysql on lampp can't be activated in any way
Posted: 08. August 2006 15:11
he problem happened on lampp, but i can not handle it to work right, please help me,thank you.
after download lampp 1.5.3,the following steps were carried out:
then,the services were checked out
but, when browsing from http://localhost, the status looked like this
so, i had to restart lampp:
but, it's so mazing: 'XAMPP: Another MySQL daemon is already running." and phpmyqdmin didn't worked well:
my.cnf looked like this:
i have chmod /opt/lampp as nobody:nogroup, now what and how to do?
after download lampp 1.5.3,the following steps were carried out:
- Code: Select all
root@BioInfoServ:/home/biowee# /opt/lampp/lampp start
Starting XAMPP for Linux 1.5.3...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Another MySQL daemon is already running.
XAMPP: Starting ProFTPD...
XAMPP for Linux started.
then,the services were checked out
- Code: Select all
root@BioInfoServ:/home/biowee# ps -ef | grep mysqld
root 17396 1 0 17:07 pts/1 00:00:00 /bin/sh /opt/lampp/bin/mysqld_safe --datadir=/opt/lampp/var/mysql --pid-file=/opt/lampp/var/run/mysqld.pid
mysql 17468 17396 0 17:07 pts/1 00:00:00 /opt/lampp/sbin/mysqld --basedir=/opt/lampp --datadir=/opt/lampp/var/mysql --user=mysql --pid-file=/opt/lampp/var/run/mysqld.pid --skip-locking --port=3306 --socket=/opt/lampp/var/run/mysqld.sock
root 18549 1 0 17:35 ? 00:00:02 gedit file:///opt/lampp/var/run/mysqld.pid
root 23096 17194 0 20:01 pts/1 00:00:00 grep mysqld
but, when browsing from http://localhost, the status looked like this
- Code: Select all
Component Status Hint
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
so, i had to restart lampp:
- Code: Select all
root@BioInfoServ:/home/biowee# /opt/lampp/lampp start
Starting XAMPP for Linux 1.5.3...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Another MySQL daemon is already running.
XAMPP: Starting ProFTPD...
XAMPP for Linux started.
but, it's so mazing: 'XAMPP: Another MySQL daemon is already running." and phpmyqdmin didn't worked well:
- Code: Select all
welcome to phpMyAdmin 2.8.1
MySQL said:
#2002 - Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock'
my.cnf looked like this:
- Code: Select all
[client]
#password = your_password
port = 3306
socket = /opt/lampp/var/run/mysqld.sock
[mysqld_safe]
socket = /opt/lampp/var/run/mysqld.sock
nice = 0
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /opt/lampp/var/run/mysqld.sock
user = mysql
pid-file = /opt/lampp/var/run/mysqld.pid
basedir = /opt/lampp
datadir = /opt/lampp/var/mysql
tmpdir = /opt/lampp/tmp
i have chmod /opt/lampp as nobody:nogroup, now what and how to do?