Arch Linux

Major 25

Member

Registered: 2020-03-05

Posts: 1

Xampp starting MySQL Error[SOLVED]

UPDATE: FIXED BY DOWNLOADING AND INSTALLING STRAIGHT FROM THE WEBSITE

After installing Xampp and also installing all the dependencies i have encountered this error while trying to start Xampp.

Starting XAMPP for Linux ...
XAMPP: Starting Apache...ok.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...ok.
/opt/lampp/bin/mysql.server: line 264: kill: (2865) - No such process

I have already tried the following:

1. Reinstalling Xampp completely.
2. The following commands :

• sudo chmod -R 755 /opt/lampp

• sudo chown -hR nobody /opt/lampp

• sudo chmod -R 777 /opt/lampp

3. Checked the service list for mysql.service nothing showed up
4. Tried to access log files in /opt/lampp/var/mysql, tried to access the following files: ib_logfile0, ib_logfile1, aria_log.00000001 with the following command : sudo nano [filename]. What i got was gibberish text.

The error has been persistent and nothing seems to work do you guys have any suggestions on how to fix the error? I need the program for university work so picking an equivalent one is not an option.

UPDATE: FIXED BY DOWNLOADING AND INSTALLING STRAIGHT FROM THE WEBSITE

Last edited by Major 25 (2020-06-20 19:06:57)

WorMzy

Administrator

From: Scotland

Registered: 2010-06-16

Posts: 12,414

Website

Re: Xampp starting MySQL Error[SOLVED]

Mod note: moving to AUR Issues.

---

Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.

e_Irbis

Member

Registered: 2015-12-09

Posts: 3

Re: Xampp starting MySQL Error[SOLVED]

I think I found a solution.

Maria DB uses port 3306.

mysqld[44734]: Version: '10.4.12-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Arch Linux

The same port 3306 is specified in the configuration file /opt/lampp/etc/my.cnf for the XAMPP MySQL server.
I changed the port number to another in the configuration file /opt/lampp/etc/my.cnf

And the XAMPP bug is gone

sudo /opt/lampp/lampp status
Version: XAMPP for Linux 7.4.3-0
Apache is running.
MySQL is running.
ProFTPD is running.

WorMzy

Administrator

From: Scotland

Registered: 2010-06-16

Posts: 12,414

Website

Re: Xampp starting MySQL Error[SOLVED]

That doesn't seem to be the cause of the issue in OP's case, but thank you for sharing in any case.

Major 25, please remember to mark your thread as solved: https://wiki.archlinux.org/index.php/Co … ow_to_post

---

Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.

avasam

Member

Registered: 2020-01-26

Posts: 71

Website

Re: Xampp starting MySQL Error[SOLVED]

I tested many ways
Finally : 
I solved this problem by removing xampp completely :
yay -Rns xampp

Then i download Xampp from apachefriends.org and install it again.
Now problem solved.

Last edited by avasam (2020-06-20 18:21:51)