XAMPP mysql not starting

aur

#1

I’ve installed xampp in the AUR…
then when I lauched
/opt/lampp/lampp restart
…I got this…

`Restarting XAMPP for Linux 7.1.1-0…
XAMPP: Stopping Apache…ok.
XAMPP: Stopping MySQL…not running.
XAMPP: Stopping ProFTPD…ok.
XAMPP: Starting Apache…already running.
XAMPP: Starting MySQL…ok.
XAMPP: Starting ProFTPD…ok.

/opt/lampp/bin/mysqld_safe_helper: Can’t create/write to file ‘/opt/lampp/var/mysql/host.err’ (Errcode: 13 “Permission denied”)`

I already changed the port 3306 with 3307…added innodb_force_recovery=1 and yet…it still occuring this error…


#2

It’s trying to write to a location and is being denied. Check the directory permissions.


#3

this is the output of my ls -l

`

ls -l /opt/lampp/

`

total 12008
drwxr-xr-x  5 root   root      4096 Oct 17 12:18 apache2
drwxrwxr-x  2 root   root     12288 Oct 17 12:19 bin
drwxr-xr-x  2 root   root      4096 Oct 17 12:22 build
drwxr-xr-x  2 root   root      4096 Oct 17 12:18 cgi-bin
-rw-r--r--  1 root   root     86263 Aug  9 21:20 COPYING.thirdparty
-rwxr-xr-x  1 root   root     27400 Oct 17 12:18 ctlscript.sh
drwxr-xr-x  2 root   root      4096 Oct 17 12:21 docs
drwxrwxr-x  3 root   root      4096 Oct 17 12:18 error
drwxr-xr-x  8 root   root      4096 Oct 17 12:21 etc
drwxr-xr-x  6 root   root      4096 Oct 17 20:44 htdocs
drwxr-xr-x  6 root   root      4096 Oct 17 12:03 htdocs_backup
drwxr-xr-x  3 root   root      4096 Oct 17 12:19 icons
drwxr-xr-x  2 root   root      4096 Oct 17 12:18 img
drwxr-xr-x 22 root   root     12288 Oct 17 12:22 include
drwxr-xr-x  2 root   root      4096 Oct 17 12:22 info
lrwxrwxrwx  1 root   root        16 Oct 17 12:21 lampp -> /opt/lampp/xampp
drwxr-xr-x 15 root   root     12288 Oct 17 12:25 lib
drwxr-xr-x  2 root   root      4096 Oct 17 12:18 libexec
drwxr-xr-x  2 root   root      4096 Oct 17 12:18 licenses
drwxr-xr-x  2 daemon daemon    4096 Oct 17 20:55 logs
drwxr-xr-x  7 root   root      4096 Oct 17 12:21 man
-rwx------  1 root   root   3361003 Feb 27  2017 manager-linux-x64.run
drwxr-xr-x 14 root   root     12288 Oct 17 12:22 manual
drwxr-xr-x  2 root   root      4096 Oct 17 12:22 modules
drwxr-xr-x  3 root   root      4096 Oct 17 12:18 mysql
drwxr-xr-x  2 root   root      4096 Oct 17 12:18 pear
drwxr-xr-x  3 root   root      4096 Oct 17 12:18 php
drwxr-xr-x 12 root   root      4096 Oct 17 12:19 phpmyadmin
drwxr-xr-x  3 root   root      4096 Oct 17 12:18 proftpd
-rw-r--r--  1 root   root       904 Oct 17 12:25 properties.ini
-rw-r--r--  1 root   root     19510 Aug  9 21:20 README-wsrep
-rw-r--r--  1 root   root      2067 Sep 18 10:18 RELEASENOTES
drwxr-xr-x  2 root   root      4096 Oct 17 12:21 sbin
drwxr-xr-x 47 root   root      4096 Oct 17 12:21 share
drwxrwxrwx  2 daemon daemon    4096 Oct 17 18:28 temp
-rwx------  1 root   root   8305064 Oct 17 12:26 uninstall
-rw-------  1 root   root    307812 Oct 17 12:27 uninstall.dat
drwxr-xr-x  7 root   root      4096 Oct 17 20:56 var
-rwxr-xr-x  1 root   root     15201 Jul 22  2013 xampp

#4

The directories are owned by root. You can’t alter them as your normal user. You’ll need to either change the directory ownership, or run XAMPP as root.

Read the XAMPP documentation to find out which is recommended.


#5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.