I'm using a mac. I had problems with xammp not working with phpmyadmin. I'd try browsing to it and it'd say an error and wouldn't show the database. So now I have downloaded mamp and I am experiencing a similar problem. MySql server is red, it wont start up.
My log is:
111108 17:36:32 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
111108 17:36:32 [Warning] You have forced lower_case_table_names to 0 through a command-line option, even though your file system '/Applications/MAMP/db/mysql/' is case insensitive. This means that you can corrupt a MyISAM table by accessing it with different cases. You should consider changing lower_case_table_names to 1 or 2
111108 17:36:32 [Note] Plugin 'FEDERATED' is disabled.
111108 17:36:32 InnoDB: The InnoDB memory heap is disabled
111108 17:36:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
111108 17:36:32 InnoDB: Compressed tables use zlib 1.2.3
111108 17:36:32 InnoDB: Initializing buffer pool, size = 128.0M
111108 17:36:32 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 35
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
......the last 2 lines go on for quite a length
I have got info on mamp root folder and applied permissions to all enclosed items. I have restarted computer and reopened mamp and it works. Aftr about 2 minutes though the following repeated error occurs and then the red light is on again at mysql Server in mamp.
InnoDB: Unable to lock ./ibdata1, error: 35
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
