I am using Ubuntu 14.04 and Xampp 5.6.3-0. I cannot get the MySQL server to run. I have tried executing these commands so far (run in this order):
sudo chmod 755 /opt/lampp/etc/my.cnf
sudo chmod -R 777 /opt/lampp/var/mysql
sudo chown -hR root/opt/lampp
This produced: chown: missing operand after ‘root/opt/lampp’
sudo chown -hR root:root /opt/lampp
sudo chmod 755 /opt/lampp/etc/my.cnf
sudo chmod 777 /opt/lampp/var/mysql -R
sudo /opt/lampp/lampp restart
Which produced: (running this commend twice in a row produces the same result)
Restarting XAMPP for Linux 5.6.3-0...
XAMPP: Stopping Apache...ok.
XAMPP: Stopping MySQL...not running.
XAMPP: Stopping ProFTPD...ok.
XAMPP: Starting Apache...ok.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...ok.
But the server will still not start after this, how do I get the server to start?
Edit:
$ sudo lsof -i TCP:3306
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 1222 mysql 10u IPv4 10907 0t0 TCP localhost:mysql (LISTEN)`
and
$ sudo /etc/init.d/mysql status
* /usr/bin/mysqladmin Ver 8.42 Distrib 5.5.40, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Server version 5.5.40-0ubuntu0.14.04.1
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 1 day 4 hours 35 min 35 sec
With all this when trying to connect to phpmyadmin I get:
lsof -i TCP:3306
and/etc/init.d/mysql status
Because it really looks like MySQL worksStarting MySQL...ok
sudo lsof...
andsudo /etc/init.d/mys....
without root permission it will not be relevant