Couldn't start MySQL!

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Couldn't start MySQL!

Postby lukai » 23. April 2009 17:28

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)
lukai
 
Posts: 6
Joined: 23. April 2009 17:15

Re: Couldn't start MySQL!

Postby Wiedmann » 23. April 2009 18:05

Any suggestion?

Read the MySQL error log.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Couldn't start MySQL!

Postby tekila » 23. April 2009 20:17

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
 
Posts: 2
Joined: 23. April 2009 13:34

Re: Couldn't start MySQL!

Postby lukai » 24. April 2009 14:15

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

Unfortunately I haven't it in /etc/init.d/ folder.
lukai
 
Posts: 6
Joined: 23. April 2009 17:15

Re: Couldn't start MySQL!

Postby lukai » 24. April 2009 14:41

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!?
lukai
 
Posts: 6
Joined: 23. April 2009 17:15

Re: Couldn't start MySQL!

Postby Wiedmann » 24. April 2009 14:45

That's the Apache error.log, not the error log from MySQL.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Couldn't start MySQL!

Postby lukai » 11. May 2009 10:56

where can I find it?
lukai
 
Posts: 6
Joined: 23. April 2009 17:15

Re: Couldn't start MySQL!

Postby Wiedmann » 11. May 2009 10:59

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
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Couldn't start MySQL!

Postby lukai » 11. May 2009 11:21

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?
lukai
 
Posts: 6
Joined: 23. April 2009 17:15

Re: Couldn't start MySQL!

Postby Wiedmann » 11. May 2009 11:30

After installing Xampp in /opt I start

You have done this (installing/starting) all as user "root" (or with sudo)?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Couldn't start MySQL!

Postby lukai » 11. May 2009 13:57

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


I have used Sudo.
lukai
 
Posts: 6
Joined: 23. April 2009 17:15

Re: Couldn't start MySQL!

Postby Red Dragon » 24. July 2009 01:24

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.
Red Dragon
 
Posts: 20
Joined: 24. July 2009 01:15

Re: Couldn't start MySQL!

Postby thegrilledcheese » 06. August 2009 08:15

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
 
Posts: 1
Joined: 06. August 2009 08:12

Re: Couldn't start MySQL!

Postby s235421702 » 13. August 2009 13:36

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
s235421702
 
Posts: 1
Joined: 13. August 2009 13:28

Re: Couldn't start MySQL!

Postby kufio » 18. August 2009 12:48

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
kufio
 
Posts: 1
Joined: 18. August 2009 12:40

Next

Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 5 guests