up vote 1 down vote favorite
share [g+] share [fb]

I had MAMP successfully running in one of the user, but since I have created a new user to separate things between two developers, its throwing tantrums. I am pretty new to Mac itself but managed to find users with similar problems.

In my old user, Apache doesn't start and in the new user, MySql doesn't start. I have also verified that no other instance of mysqld is running, still it won't run MySql on my system. I have already restarted the system several times, even checked /etc for the file my.cnf, but there's no my.cnf inside /etc

Couldn't find any form to ask for a support on mamp.info and am desperately missing my Ubuntu now :-(

Here's the mysql log:

110803 16:16:26 [Note] Plugin 'FEDERATED' is disabled.
110803 16:16:26 [Note] Plugin 'ndbcluster' is disabled.
/Applications/MAMP/Library/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
110803 16:16:26 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110803 16:16:26  InnoDB: Started; log sequence number 0 396676924
110803 16:16:26 [ERROR] /Applications/MAMP/Library/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
110803 16:16:26 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
110803 16:16:26 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended

What can be the problem?

link|improve this question
What do your logs have to say? – womble Aug 3 '11 at 11:26
The mysql log says this: gist.github.com/1122537 But I don't understand why my question was downvoted – Sheikh Aman Aug 4 '11 at 11:12
Put question data in the question, not on a third-party site. – womble Aug 4 '11 at 11:17
strange, we on stackoverflow prefer using gist for long text/code. Anyway, I have updated the question with the logs – Sheikh Aman Aug 4 '11 at 12:50
7 lines is "long text"? – womble Aug 4 '11 at 23:30
feedback

1 Answer

up vote 0 down vote

The problem is that your MySQL data is owned by a different user than the one that is trying to access it. chown your MySQL data directory to the new user, or perhaps (if you want to continue to allow multiple people to run MySQL in the future) create a separate MySQL data directory for the new user, and modify the configuration file for the second user appropriately.

link|improve this answer
this sounds nice. configuration file means my.cnf ? can you please tell what settings should I change in it? – Sheikh Aman Aug 5 '11 at 5:52
datadir, which you could have discovered by looking through your my.cnf for the name of your existing data directory. – womble Aug 5 '11 at 6:33
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.