MySQL not getting started after changing user and groups.

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

MySQL not getting started after changing user and groups.

Postby ankurkh1 » 15. March 2021 21:13

Code: Select all
I had to start the xampp server as root every time, otherwise it would say - "this application requires admin privileges". So what I did is, I ran two commands -
Code: Select all
sudo chown ankur lampp -R
and
Code: Select all
sudo chgrp ankur lampp -R
where "ankur" is my username. Now the
Code: Select all
ls -l
showed the following results:

Code: Select all
total 12940
drwxr-xr-x  5 ankur ankur    4096 Mar  1 20:22 apache2
drwxrwxr-x  2 ankur ankur   12288 Mar  1 20:22 bin
drwxr-xr-x  2 ankur ankur    4096 Mar  1 20:25 build
drwxr-xr-x  2 ankur ankur    4096 Mar  1 20:22 cgi-bin
-rwxr-xr-x  1 ankur ankur   25750 Mar  1 20:22 ctlscript.sh
drwxr-xr-x  2 ankur ankur    4096 Mar  1 20:25 docs
drwxrwxr-x  3 ankur ankur    4096 Mar  1 20:22 error
drwxr-xr-x  8 ankur ankur    4096 Mar 14 03:36 etc
drwxr-xr-x  9 ankur ankur    4096 Mar 13 17:09 htdocs
drwxr-xr-x  3 ankur ankur    4096 Mar  1 20:22 icons
drwxr-xr-x  2 ankur ankur    4096 Mar  1 20:22 img
drwxr-xr-x 22 ankur ankur   12288 Mar  1 20:25 include
drwxr-xr-x  2 ankur ankur    4096 Mar  1 20:25 info
lrwxrwxrwx  1 ankur ankur      16 Mar  1 20:25 lampp -> /opt/lampp/xampp
drwxr-xr-x 15 ankur ankur   12288 Mar  1 20:29 lib
drwxr-xr-x  2 ankur ankur    4096 Mar  1 20:22 lib64
drwxr-xr-x  2 ankur ankur    4096 Mar  1 20:22 libexec
drwxr-xr-x  2 ankur ankur    4096 Mar  1 20:22 licenses
drwxr-xr-x  2 ankur ankur    4096 Mar 16 00:47 logs
drwxr-xr-x  7 ankur ankur    4096 Mar  1 20:25 man
-rwxr-xr-x  1 ankur ankur 3361003 Aug 27  2019 manager-linux-x64.run
drwxr-xr-x 14 ankur ankur   12288 Mar  1 20:25 manual
drwxr-xr-x  2 ankur ankur    4096 Mar  1 20:25 modules
drwxr-xr-x  3 ankur ankur    4096 Mar  1 20:22 mysql
drwxr-xr-x  2 ankur ankur    4096 Mar  1 20:22 pear
drwxr-xr-x  3 ankur ankur    4096 Mar  1 20:22 php
drwxr-xr-x 13 ankur ankur    4096 Mar  1 20:30 phpmyadmin
drwxr-xr-x  3 ankur ankur    4096 Mar  1 20:22 proftpd
-rw-r--r--  1 ankur ankur     904 Mar  1 20:29 properties.ini
-rw-r--r--  1 ankur ankur    3102 Nov 10 15:59 README.md
-rw-r--r--  1 ankur ankur   19520 Nov 10 15:59 README-wsrep
-rw-r--r--  1 ankur ankur     647 Feb  9 13:21 RELEASENOTES
drwxr-xr-x  2 ankur ankur    4096 Mar  1 20:25 sbin
drwxr-xr-x 48 ankur ankur    4096 Mar  1 20:25 share
drwxrwxrwx  2 ankur ankur    4096 Mar 16 00:52 temp
-rw-r--r--  1 ankur ankur   86263 Nov 10 15:59 THIRDPARTY
-rwx------  1 ankur ankur 9103604 Mar  1 20:30 uninstall
-rw-------  1 ankur ankur  458842 Mar  1 20:30 uninstall.dat
drwxr-xr-x  7 ankur ankur    4096 Mar 16 00:48 var
-rwxr-xr-x  1 ankur ankur   15201 Jul 22  2013 xampp


After that I tried running the xampp server, the application still said that it requires admin privileges and now even on running as root, the mysql is not getting started.

Can someone please help me in setting the user and groups to default? So that my xampp server can run again as before?
ankurkh1
 
Posts: 1
Joined: 15. March 2021 20:59
XAMPP version: 8.0.2-0
Operating System: Ubuntu 20.10

Re: MySQL not getting started after changing user and groups

Postby Nobbie » 16. March 2021 11:27

Rename the lampp folder to whatever, then install a new Xampp. Finally compare the user and group from each file and folder from your (renamed) installation with the original lampp installation, finally adapt all settings. At last delete lampp and rename your installation back to lampp.

I know that is quite a huge task, its the fine for your crazy action. Sorry, but that was really, really dumb. Maybe its easier to begin from scratch with a new Xampp.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 13 guests

cron