Apache Friends Support Forum

Hi, I'm using a xubuntu 8.10 Usb version.

After installing Xampp in /opt I start it and ... everything start correctly but ... Xampp: Coulden't start MySQL!
If I try /opt/lampp/lampp status I see:
Apache is running.
MySQL is not running.
ProFTPD is running.

Any suggestion?

P.S. I am a new linux user (2 week)

Any suggestion?

Read the MySQL error log.

I have faced the same problem with MySQL when I configured Xampp :
The problem I come to find is conflict created with other distribution of MySQL.
I have solved it in this way:
I have stopped the already running MySQL from other distribution installed as apt-get....
/etc/init.d/mysql stop

Then I started MySQL server from Xampp as follows

/opt/lampp/lampp start

And it worked fine

hope it will help you too

tekila wrote:/etc/init.d/mysql stop

Unfortunately I haven't it in /etc/init.d/ folder.

Wiedmann wrote:Read the MySQL error log.

I hope someone understand it ... I don't

Code: Select all

 [Fri Apr 24 13:13:23 2009] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Fri Apr 24 13:13:23 2009] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Fri Apr 24 13:13:23 2009] [notice] Digest: generating secret for digest authentication ...
[Fri Apr 24 13:13:23 2009] [notice] Digest: done
[Fri Apr 24 13:13:25 2009] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Fri Apr 24 13:13:25 2009] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?


That's the Apache error.log, not the error log from MySQL.

where can I find it?

where can I find it?

That's a "*.err" file. IMHO somewhere in "/opt/lampp/var/db/mysql", or something like that. (Sorry, don't have Linux)

Wiedmann wrote:That's a "*.err" file. IMHO somewhere in "/opt/lampp/var/db/mysql", or something like that. (Sorry, don't have Linux)

Right ... /opt/lampp/var/mysql
I have this error:

Code: Select all

090511 09:53:58 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
090511  9:53:59 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090511  9:53:59  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
090511 09:53:59 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/ubuntu.pid ended

Any idea?

After installing Xampp in /opt I start

You have done this (installing/starting) all as user "root" (or with sudo)?

You have done this (installing/starting) all as user "root" (or with sudo)?

I have used Sudo.

i just had the same problem. Its with the file primssions. I think you need to change the file primssions to read and write for everything.

I have the exact same problem with the exact same .err output. Using Ubuntu 9.04. This seems to be a permissions problem but I'm somewhat of a noob in that regard so if anyone can tell me the correct commands to fix the permissions so mysql will start I would much appreciate it.

result of $> ls -la /opt/lampp/var/mysql

total 40
drwxr-xr-x 6 jeff jeff 4096 2009-08-06 00:09 .
drwxr-xr-x 5 jeff jeff 4096 2009-08-06 00:09 ..
drwx------ 2 jeff jeff 4096 2007-03-23 11:54 cdcol
-rw-rw-rw- 1 jeff jeff 5769 2009-08-06 00:09 dingle.err
-rw-r----- 1 jeff jeff 1759 2009-04-13 09:57 freeside.err-old
drwx------ 2 jeff jeff 4096 2008-12-30 04:16 mysql
-rw-r--r-- 1 jeff jeff 6 2008-12-02 00:52 mysql_upgrade_info
drwx------ 2 jeff jeff 4096 2007-12-25 02:13 phpmyadmin
drwx------ 2 jeff jeff 4096 2009-02-01 03:44 test


Anyone able to help? Thanks ahead of time

thegrilledcheese wrote:I have the exact same problem with the exact same .err output. Using Ubuntu 9.04. This seems to be a permissions problem but I'm somewhat of a noob in that regard so if anyone can tell me the correct commands to fix the permissions so mysql will start I would much appreciate it.

result of $> ls -la /opt/lampp/var/mysql

total 40
drwxr-xr-x 6 jeff jeff 4096 2009-08-06 00:09 .
drwxr-xr-x 5 jeff jeff 4096 2009-08-06 00:09 ..
drwx------ 2 jeff jeff 4096 2007-03-23 11:54 cdcol
-rw-rw-rw- 1 jeff jeff 5769 2009-08-06 00:09 dingle.err
-rw-r----- 1 jeff jeff 1759 2009-04-13 09:57 freeside.err-old
drwx------ 2 jeff jeff 4096 2008-12-30 04:16 mysql
-rw-r--r-- 1 jeff jeff 6 2008-12-02 00:52 mysql_upgrade_info
drwx------ 2 jeff jeff 4096 2007-12-25 02:13 phpmyadmin
drwx------ 2 jeff jeff 4096 2009-02-01 03:44 test


Anyone able to help? Thanks ahead of time

I solved this problem by change the owner of "/opt/lampp/var/mysql/mysql" to "nobody"

Code: Select all

sudo chown nobody /opt/lampp/var/mysql/mysql

Below I post the error log I have,mysql can't start, tried to change ownership to /opt/lampp/var/mysql/mysql but no luck, can you suggest anything?

/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
090818 13:36:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090818 13:36:52 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
090818 13:36:52 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/kufio-desktop.pid ended