Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I've been trying to reset the root password, and have been following these instructions:

However, when I use the command:

/usr/local/mysql/bin/mysqld_safe --skip-grant-tables

I receive the following output:

111217 10:00:42 mysqld_safe Logging to '/usr/local/mysql/data/******-********-MacBook-Pro.local.err'.
111217 10:00:42 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/bin/mysqld_safe: line 107: /usr/local/mysql/data/********-********-MacBook-Pro.local.err: Permission denied
/usr/local/mysql/bin/mysqld_safe: line 144: /usr/local/mysql/data/*******-**********-MacBook-Pro.local.err: Permission denied
111217 10:00:42 mysqld_safe mysqld from pid file /usr/local/mysql/data/*********-******** ended
/usr/local/mysql/bin/mysqld_safe: line 107: /usr/local/mysql/data/*******-*********-MacBook-Pro.local.err: Permission denied
**********-*********-MacBook-Pro:~ myname$ 

Why would my permission be denied and how can I fix it?

share|improve this question

migrated from Dec 18 '11 at 9:28

This question came from our site for professional and enthusiast programmers.

2 Answers 2

This question might fare better on

It looks like you don't have the correct permissions set for the /usr/local/mysql folder. Be sure it exists and is owned by the mysql user (assuming mysql is the user the mysqld is running as).

share|improve this answer
up vote 2 down vote accepted

Just do it with sudo:

sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
share|improve this answer
ReverendPete, this was the key, thank you! – user1072337 Dec 18 '11 at 1:58
OMG that was simple. +1 !!!… – RolandoMySQLDBA Dec 19 '11 at 18:30

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.