Problem with MySql on Ubuntu 16.04 (XAMPP for Linux)

rf.rombouts 2019-10-23 18:23:48 UTC #1

When I try to start mysql server, it refuses:

richard@HAL:/opt/lampp$ sudo ./lampp startmysql
XAMPP: Starting MySQL...ok.
richard@HAL:/opt/lampp$ /opt/lampp/bin/mysql.server: 264: kill: No such process

Same when I run /opt/lampp/lampp start.
See more details here: https://stackoverflow.com/questions/58511277/very-persistent-opt-lampp-bin-mysql-server-264-kill-no-such-process-xampp-u.

What does this 264 mean?
There is no error.log in /var/log/mysql

I can access MySql from localhost/phpadmin, that works more or less fine (apart from a minor error I can ignore).

Does anyone know where I can find the file with StartLimitIntervalSec= and StartLimitBurst= for mysql service? When I run
systemctl status mysql.service
I get:

Failed to start MySQL Community Server.
mysql.service: Unit entered failed state.
mysql.service: Failed with result 'exit-code'.
mysql.service: Service hold-off time over, scheduling restart.
Stopped MySQL Community Server.
mysql.service: Start request repeated too quickly.
Failed to start MySQL Community Server.
mysql.service: Unit entered failed state.
mysql.service: Failed with result 'start-limit-hit'.

I will look up details of systemctl reset-failed myself.

Thanks for any help.

novat 2019-10-23 22:58:09 UTC #2

facing same issues. following for help with this one

gongomgra 2019-10-24 07:41:12 UTC #3

Hi @rf.rombouts, @novat,

I was able to reproduce your issue. The error you are getting means that you have another MySQL server running on your server, probably installed from your system package manager. Please run the commands below to stop that server and start the one installed with XAMPP.

sudo service mysql stop
sudo /opt/lampp/xampp start

Now, you can connect to the XAMPP MySQL server (in fact, it is a MariaDB server) with

/opt/lampp/bin/mysql -u root

Also, if you want to prevent the system's MySQL server to be started again, you can disable that service with the commands below

sudo service mysql stop
sudo systemctl disable mysql

Hope it helps,
Gonzalo

rf.rombouts 2019-10-24 09:56:27 UTC #4

Hi, many thanks for your explanation and command lines.
service --status-all gives:
[ - ] mysql
so mysql is not started.

I ran your first two commands:

root@HAL:/run/systemd# sudo service mysql stop
root@HAL:/run/systemd# sudo /opt/lampp/xampp start
Starting XAMPP for Linux 7.3.10-0...
XAMPP: Starting Apache...already running.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...already running.
root@HAL:/run/systemd# /opt/lampp/bin/mysql.server: 264: kill: No such process

so the issue remains.

When I now try /opt/lampp/bin/mysql -u root
I get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' (111)

which makes sense since the starting of the service failed.
I will puzzle for one more hour, before I have to attend a course.
But I think your initial remark about another MySQL server that causes conflicts will turn out to be right.

Thanks for trying to help.

gongomgra 2019-10-24 12:15:11 UTC #5

Hi @rf.rombouts,

Can you run the commands below and paste here the output? With these command we can try to understand what's using the MySQL port and if it is any process running

sudo netstat -tupln | grep 3306
sudo ps aux | grep -i mysql 
sudo ps aux | grep -i mariadb

Can you try to disable the MySQL service as mentioned in my previous post?

rf.rombouts 2019-10-24 14:55:38 UTC #6

root@HAL:/home/richard# netstat -tupln | grep 3306
root@HAL:/home/richard# ps aux | grep -i mysql
root 4400 0.0 0.0 14236 1012 pts/2 S+ 16:55 0:00 grep --color=auto -i mysql
root@HAL:/home/richard# sudo ps aux | grep -i mariadb
root 4403 0.0 0.0 14236 1008 pts/2 S+ 16:55 0:00 grep --color=auto -i mariadb
root@HAL:/home/richard#

gongomgra 2019-10-25 09:32:25 UTC #7

Hi @rf.rombouts,

According to that output, there is no other MySQL service running on your server. Can you try to manually start it by using the command below and posting here the output?

sudo bash /opt/lampp/share/mysql/mysql.server start

As you will see when running the command above, it will mention a log file. Can you check the mentioned file to see which errors do you get? As an example, this is the output I'm getting on my server

$ sudo bash /opt/lampp/share/mysql/mysql.server start
Starting MariaDB.2019-10-25 09:28:58 17568 mysqld_safe Logging to '/opt/lampp/var/mysql/ip-172-31-0-44.err'.
2019-10-25 09:28:58 17568 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
.

So the log file I'd check is /opt/lampp/var/mysql/ip-172-31-0-44.err.

Apart from the above, please note that we do not offer support for the XAMPP products on these community forum. We highly recommend you to ask for help in the official XAMPP's support forums at https://community.apachefriends.org

Please post the info I requested here in the Apachefriends forum so they can help you.

Regards,
Gonzalo

rf.rombouts 2019-10-26 01:09:26 UTC #8

Hi,

thanks for all your help. I will post the err file on apachefriends.org by tomorrow.

Kind regards,

Richard

rf.rombouts 2019-10-26 12:00:25 UTC #9

The err-file has been posted here:

https://community.apachefriends.org/f/viewtopic.php?f=17&t=78648&e=0

Please ignore the spelling error in the subject title.
I am very close to giving up and just install LAMP.

When I do
root@HAL:/var/lib# mysql_upgrade -uadmin (as suggested by the error file)

it fails:
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while connecting to the MySQL server

Also this fails:
MYSQL_PWD=cat /etc/psa/.psa.shadow mysql_upgrade -uadmin
cat: /etc/psa/.psa.shadow: No such file or directory
mysql_upgrade: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) while connecting to the MySQL server
Upgrade process encountered error and will not continue.

It seems to do the upgrade, you must have a running server and to have a running server I must upgrade??? Then why did XAMP choose for MariaDB? Even so, why should this cause conflicts with mysql?

Thanks again for all your help. The easiest way seems to uninstall XAMP and install Apache, PHP and mysql separately.

gongomgra 2019-10-28 14:22:31 UTC #10

Hi @rf.rombouts,

Let see what do the Apachefriends community says about it, but the commands you are trying to run refer to the MySQL server that you have installed on your server from your system packages manager and it won´t work with the MariaDB server included into XAMPP. Note that you will need to run the mysql_upgrade command installed into /opt/lampp/bin and not from your system.

sudo /opt/lampp/bin/mysql_upgrade -u root

As the root user of the MariaDB database doesn't have a password by default, running the command above should be enough.

Regards,
Gonzalo

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!