4

i've tried to download XAMPP, untar it in /opt/lampp and launch

sudo ./lamp start

but i get this output:

Starting XAMPP for Linux 1.7.7...
XAMPP: Another web server daemon is already running.
XAMPP: Starting MySQL...
XAMPP: Couldn't start MySQL!
XAMPP: XAMPP-ProFTPD is already running.
XAMPP for Linux started.

so i opened synaptic and i have installed mysql server.

now i have 2 problems, if i restart my ubuntu 10.10:

  1. every time i restart my ubuntu i have to retype

    sudo /etc/init.d/mysql stop

  2. if after stop mysql daemon i relaunch lampp i get same message: XAMPP: Couldn't start MySQL!

/var/log/mysql.err and /var/log/mysql.log are empty..

2
  • 2
    This is why I avoid wrappers like xampp, and install Apache, MySQL, and whatever else I need individually. Each of them is easy to install and maintain, but adding another layer around them just makes it more complicated, IMHO. It seems like you already have most of it, so why not use what you have instead of fighting it? Jun 1, 2012 at 17:32
  • 1
    and adding to @MartyFried do not use XAMPP for a production setup. XAMPP has been designed for developers to get on with developing at localhost and not to have the worry about the security mechanics of the server suite and so security has been set in the configuration files as a low priority because the servers have no need to be open to the Internet - your PC firewall correctly configured will block most intruders.
    – Rinzwind
    Nov 23, 2012 at 13:28

3 Answers 3

11

I've resolved in this way:

sudo chmod -R 777 /opt/lampp
sudo chown -hR nobody /opt/lampp
sudo chmod -R 755 /opt/lampp

then I noticed that I have another mysqld instance running and stoped it with:

sudo service mysql stop
1
  • 2
    Thank you for "sudo service mysql stop". Xampp's mysql couldn't start because there was another mysql daemon running. However, running /etc/init.d/mysql stop seemed to stop and immediately start it up again. Your command worked permanently.
    – timetofly
    Sep 20, 2013 at 0:21
6

This post on Stack Overflow helped me:

  1. Open etc folder in the XAMPP installation directory.
  2. Find my.cnf file and open it in any text editor
  3. Change Port from 3306 to 3307 (if you have installed skype or other apps)
  4. Add innodb_force_recovery=1 under myisam_sort_buffer_size=8M
  5. Save my.cnf file
  6. Open xampp: Goto Computer(opt)> Open lampp folder(Search "lampp" if u can't see lampp folder)> Open manager-linux.run
  7. In XAMPP Click on "Manage Server" Tab> Click on "Mysql Database"> Click on "Configure"> Change Port from 3306 to 3307> save and start the mysql database.

You get a message "Starting MySQL SUCCESS!"

2
  • innodb_force_recovery=1, worked for me
    – Ravistm
    Feb 27, 2018 at 6:45
  • change port worked for me Jun 15, 2022 at 22:04
2
sudo service mysql stop
sudo /opt/lampp/lampp restart

It worked for me.

1
  • If your Apache Web Server stopped working after these commands then run the following command sudo apachectl stop then start your apache web Server...It will work... Jun 15, 2021 at 13:28

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .