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

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've been trying to reset the root password, and have been following these instructions: http://www.coolestguyplanet.net/how-to-change-the-mysql-root-password/

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/*********-********-MacBook-Pro.local.pid 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 stackoverflow.com Dec 18 '11 at 9:28

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

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 !!! laughingsquid.com/… – RolandoMySQLDBA Dec 19 '11 at 18:30

This question might fare better on http://serverfault.com.

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

Your Answer

 
discard

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