I attempted to set up a dev environment on my mac a couple of years ago but only got as far as getting apache set up. I made a start on setting up MySQL including setting passwords but didn't complete the process.
I have today got hold of MAMP and am trying to set up my dev environment using this. Again, Apache is working fine but with my previous tinkerings I set a root password that I cannot remember.
I came accross this post: http://blog.innovativethought.net/2007/05/17/resetting-your-forgotten-mysql-password/ which seems to be everything I need, however I have fallen at the first hurdle... When I execute /usr/local/mysql/bin/mysqld_safe --skip-grant-tables I get a permission denied error (I have tried this logged in on my user account and my admin account). Commenter richard on the above page also reports this problem but the solution in the link provided in the answer didn't seem to make any difference.
I have zero experience in terminal. It seems that I need to add my account to the sudoers file to grant myself permission to execute the above command. Could someone kindly give me a complete idiots guide to how to do this please. I have tried a number of things suggested by various forums and websites and even (I think) managed to open the sudoers file in terminal but was unsure where I had to add an entry or in what form.
Many many thanks.
I have today got hold of MAMP and am trying to set up my dev environment using this. Again, Apache is working fine but with my previous tinkerings I set a root password that I cannot remember.
I came accross this post: http://blog.innovativethought.net/2007/05/17/resetting-your-forgotten-mysql-password/ which seems to be everything I need, however I have fallen at the first hurdle... When I execute /usr/local/mysql/bin/mysqld_safe --skip-grant-tables I get a permission denied error (I have tried this logged in on my user account and my admin account). Commenter richard on the above page also reports this problem but the solution in the link provided in the answer didn't seem to make any difference.
I have zero experience in terminal. It seems that I need to add my account to the sudoers file to grant myself permission to execute the above command. Could someone kindly give me a complete idiots guide to how to do this please. I have tried a number of things suggested by various forums and websites and even (I think) managed to open the sudoers file in terminal but was unsure where I had to add an entry or in what form.
Many many thanks.