I seem to have trouble starting MySQL. I've done a bit of research in this forum but I'm still a bit lost...
My configuration is:
- Ubuntu 12.04 LTS 32bits
- xampp 1.8.1
What happens in my terminal is this:
- Code: Select all
lucien@lucien-AOD257:~$ sudo /opt/lampp/lampp start
Starting XAMPP for Linux 1.8.1...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
[b]XAMPP: Couldn't start MySQL![/b]
XAMPP: Starting ProFTPD...
XAMPP for Linux started.
EDIT: just skip this part, my first intuition was wrong. The solution is at the end of the post.
I looked into /opt/lampp/etc/my.cnf and found this :
[...]
# 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 = nobody
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
skip-external-locking
[...]
So I checked the directory/opt/lampp/var/mysql and there was no such document as "mysql.sock" (it was not hidden, I checked that too). I entered "mysql.sock" in the search engine and found nothing on my computer. I think that it might be the reason I can't MySQL.
There is one thing I did "my way" but I don't think it causes any issue: instead of using the terminal to extract the archive into /opt, I extracted the files into my Deskop, entered "sudo nautilus" in a terminal to open nautilus with administrator rights, and move the "lampp" directory into "/opt". When I start lampp and then access http://localhost I see the splashscreen but can't interact with it (because of the MySQL thing).
Can you help me and are the pieces of information I wrote here helpful? Thanks!
EDIT: Solution
When the line "XAMPP: Couldn't start MySQL!" appears, the details are written in /opt/lampp/var/mysql/localhost.localdomain.err (the name of the file can be different, but the extensions is ".err". For me it was /opt/lampp/var/mysql/lucien-AOD257.err)
If you see some lines starting with "InnoDB", and things like "InnoDB: The error means mysqld does not have the access rights" etc. then it probably is a permission issue. To fix it, the owner of the files in /opt/lampp must be nobody:root (user:group).
Thank you JonB!
By the way, if I wrote something completely wrong in this solution, feel free to edit it