MySQL does not start.

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

MySQL does not start.

Postby pt3r » 10. December 2012 11:35

Hello everybody,

I just tried to install the XAMPP 10.7.3 dmg on my macbook pro running macos 10.7.5.

I manange to start and stop the apache server from the xampp control app but whenever I try to launch mysql I receive a popup window stating

The operation couldn’t be completed. (XAMPPErrorDomain error 1.)

I also tried to start the mysql.server from a terminal an there I get the following error message

Peters-MacBook-Pro:mysql pt3r$ sudo /Applications/XAMPP/xamppfiles/bin/mysql.server start
Password:
Starting MySQL
. ERROR! Manager of pid-file quit without updating file.
Peters-MacBook-Pro:mysql pt3r$


Did I forget an installation step?
pt3r
 
Posts: 2
Joined: 10. December 2012 11:27
Operating System: mac osx 10.7.6

Re: MySQL does not start.

Postby pt3r » 10. December 2012 12:41

The error log contains following info

121210 12:40:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121210 12:40:16 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
121210 12:40:16 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
121210 12:40:16 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive
/Applications/XAMPP/xamppfiles/sbin/mysqld: File './mysql-bin.index' not found (Errcode: 13)
121210 12:40:16 [ERROR] Aborting

121210 12:40:16 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld: Shutdown complete

121210 12:40:16 mysqld_safe mysqld from pid file /var/lib/mysql/Peters-MacBook-Pro.local.pid ended
pt3r
 
Posts: 2
Joined: 10. December 2012 11:27
Operating System: mac osx 10.7.6

Re: MySQL does not start.

Postby gerumato » 04. January 2013 16:48

Hi! In my case, XAMPP is installed in /Applications/XAMPP, and what I did was something like this:
cd /Applications/XAMPP/xamppfiles/bin/

ls -liah | grep mysql.server

"XXXXXXX lrwxr-xr-x X userowner groupowner 55B Feb 27 2010 mysql.server ->
/Applications/xampp/xamppfiles/share/mysql/mysql.server"


sudo mv mysql.server mysql.server.brkn
sudo ln -s /Applications/XAMPP/xamppfiles/share/mysql/mysql.server mysql.server
sudo chown nobody mysql.server

...and voila! mysql starts ok, hope this helps.
Cheers
gerumato
 
Posts: 1
Joined: 04. January 2013 16:42
Operating System: Mac osx Lion


Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 39 guests