Sharley wrote:MySQL in XAMPP uses port 3306 so check if something else is using this port - netstat may help.
MySQL in XAMPP can't share ports and so if it is already in use it can't load MySQL.
I checked netstat as you suggested, but nothing was using 3306, but I did find something else...
I FINALLY found MySQL's log, and it isn't pretty
(note, I'm running DLS in Virtual Box on my main computer to figure out how to set it up before I do the real thing with my computer
, so I am retyping the log and it may have spelling and syntax errors).
- Code: Select all
110411 17:19:30 mysql_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
110411 17:19:30 [Note] Plugin 'FEDERATED' is disabled.
ยบ/opt/lampp/sbin/mysqld: Can't find file: './mysql/plugin.frm (errno:13)
110411 17:19:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use InnoDB's own implementation
InnoDB: Compressed tables use zlib 1.2.3
110411 17:19:30 InnoDB: Initializing buffer pool, size = 16.0M
110411 17:19:30 InnoDB: Completed initialization of buffer pool
110411 17:19:30 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld doesn't not have the access rights to
InnoDB: the directory.
InnoDB: File name /opt/lampp/var/mysql/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
110411 17:19:30 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/box.pid ended
It seems that the root of the problem comes from InnoDB not having access to the system files, but if I'm running as super user, how can this be.
This is way too confusing
EDIT: this problem may be very deep rooted in the fact that DSL is so light by missing things that you wouldn't expect it to (it didn't even have GCC :O). Even Cherokee didn't like it (not only was MySQL not working (according to the install), the entire system didn't work). If you can figure out what's wrong from this, tell me. Otherwise, I learned my lesson: never use DSL as a webserver
(now I'm glad I used VirtualBox
).