XAMPP MySQL server won't start on Mac OS High Sierra

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: egami, macek, gesf

Post Reply
rickproaATyahoo
New php-forum User
New php-forum User
Posts: 2
Joined: Thu Nov 05, 2020 10:07 am

Thu Nov 05, 2020 10:14 am

Hello everyone,
I've spent several days on this problem, I've been searching every forum to see if anyone has a solution. I need to run an older version of XAMPP (5.6) and the MySQL server fails to start on Mac OS X. The XAMPP application manager will not start the MySQL server, so I used Terminal:

sudo /Applications/XAMPP/bin/mysql.server start

to force the server to run. But I got an error message:

"Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
/Applications/XAMPP/xamppfiles/bin/mysqld_safe_helper: Can't create/write to file '/Applications/XAMPP/xamppfiles/var/mysql/UserName.local.err' (Errcode: 13 "Permission denied")
/Applications/XAMPP/bin/mysql.server: line 260: kill: (3256) - No such process
ERROR!"

Get the same error when logging into Terminal as ROOT.

The privileges for the "UserName.local.err" file was:

-rwxrwx--- 1 UserName admin 2500041 Oct 28 16:22 UserName-MacBook-Pro.local.err

So I gave the file all privileges - I will delete the entire XAMPP folder after printing out the SQL table structure and data. The privileges for the file are now:
-rwxrwxrwx 1 UserName admin 2500041 Oct 28 16:22 UserName-MacBook-Pro.local.err

The error message has now changed a bit:

"Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
/Applications/XAMPP/bin/mysql.server: line 260: kill: (4738) - No such process
ERROR!"

Any idea as to getting this server to run? Thanks so much for your help!
Cheers,
Rick
User avatar
hyper
php-forum GURU
php-forum GURU
Posts: 1206
Joined: Mon Feb 22, 2016 5:52 pm

Thu Nov 05, 2020 1:25 pm

Permissions can be quite confusing, your MySQL application runs under a user name and looking at the errors, it would seem that this may be the problem, does the MySQL application have permission to read and write to files?
rickproaATyahoo
New php-forum User
New php-forum User
Posts: 2
Joined: Thu Nov 05, 2020 10:07 am

Thu Nov 05, 2020 2:07 pm

Thank you very much, I thought it was a permissions problem. I cycled through this problem over and over again with fresh copies of the old XAMPP version. I tried one more time to re-install the app and to start the mysql.server and this time it worked. I would like to be able to share some insight as to how this happened, but I don't have a clue. It works now, thanks again!
Rick
Post Reply