This my first time setting a MySQL server on debian. I was trying to install Joomla! using this tutorial: docs.joomla.org/Installing_Joomla_on_Debian_Linux
I ended up installing bitnami and everything went fine until the demo ended. Since then for some reason mysql stopped working.
I did quite a mess there trying to fix the issue by myself so i figured i would ask for some help.
Also I got the error Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
for a while and it changed when edited my.cnf
that way. (socket used to be at /opt/lampp/var/mysql/
)
[mysqld]
user = mysql
port=3306
socket = /var/lib/mysql/mysql.sock
So here is the error i got (details with systemctl status mysql.service):
mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled)
Active: activating (start) since lun. 2016-08-22 11:09:35 CEST; 2s ago
Process: 25694 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Control: 25698 (mysqld)
CGroup: /system.slice/mysql.service
└─25698 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
And the "journalctl -xn
" result:
-- Logs begin at lun. 2016-08-22 10:15:10 CEST, end at lun. 2016-08-22 11:11:03 CEST. --
août 22 11:10:55 tarte systemd[1]: Unit mysql.service entered failed state.
août 22 11:10:58 tarte systemd[1]: mysql.service: control process exited, code=exited status=2
août 22 11:10:58 tarte systemd[1]: Failed to start MySQL Community Server.
-- Subject: L'unité (unit) mysql.service a échoué
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
Finally here is my /etc/mysql/my.cnf
(part of it at least):
The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
user = mysql
port=3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
I have no clue has what i should do now, ask for more info if necessary. Be specific please since i have a hard time understanding all this.