MySQL Server on MAMP-Windows Will Not Start

I had the same problem. I contacted mamp support, and their answer was the following; it worked for me. Hope this helps you too. Stop all servers in MAMP.

The below assumes your MAMP installation directory is C:\MAMP\.

For MAMP:

  • With Windows Explorer go to folder C:\MAMP\db\mysql\
  • First backup all files that begin with mysql-bin.*, then delete them (including mysql-bin.index file.)
  • Then try starting all MAMP servers again (wait for MySQL to turn light on).
  • After that stop all MAMP servers again.
  • You’ll now try to disable binary log-bin in MAMP (or MAMP PRO)
  • Open up MySQL configuration file in text editor of your choice: C:\MAMP\conf\mysql\my.ini
  • Find following text: log-bin
  • Comment this line by adding # character at start of line.#log-bin=mysql-bin
  • Save and restart servers
  • After that put the mysql-bin.* files back in their place.

Related Posts:

  1. Access denied for user ‘root@localhost’ (using password:NO)
  2. MySQL error 2006: mysql server has gone away
  3. Which MySQL data type to use for storing boolean values
  4. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  5. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  6. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  7. Your password does not satisfy the current policy requirements
  8. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  9. What is the definition of cardinality in SQL
  10. what does “/index.php?admin/admin_dashboard” in my url mean
  11. How to join two tables by multiple columns in SQL?
  12. How to get size of mysql database?
  13. Selecting data from two different tables without using joins
  14. SQL – Update multiple records in one query
  15. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  16. mysqladmin: connect to server at ‘localhost’ failed
  17. mysql update multiple columns with same now()
  18. Usage of MySQL’s “IF EXISTS”
  19. Simple Random Samples from a Sql database
  20. Generating a random & unique 8 character string using MySQL
  21. MySQL > Table doesn’t exist. But it does (or it should)
  22. SQL select only rows with max value on a column
  23. Trying to perform MINUS operation in MySQL
  24. mysql count duplicates
  25. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  26. Repair all tables in one go
  27. MySQL config file location – redhat linux server
  28. Failed building wheel for mysql-python
  29. Create boolean column in MySQL with false as default value?
  30. Is there a naming convention for MySQL?
  31. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  32. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  33. MySql – HAVING vs WHERE 
  34. How to stop mysqld
  35. mysql: connection refused when trying to connect to localhost using remote IP
  36. Is merge statement available in MySQL
  37. GROUP_CONCAT comma separator – MySQL
  38. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  39. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  40. Complex meta query with 3 keys
  41. Set page template for all pages?
  42. Optimize Multiple Taxonomy Term MySQL Query?
  43. WordPress MySQL & PHP Performance
  44. What specific database privileges does WordPress need?
  45. Using source control with WordPress
  46. My WordPress site always displays a cached version of its homepage
  47. Updating User Meta with SQL Query
  48. wpdb prepare syntax
  49. How to run this SQL query of wp_terms database
  50. Configure WordPress to connect to Mysql DB using SSH tunneling
  51. Proper way to work with wpdb to get user’s firstname
  52. How to change post format from Aside to Image for all posts?
  53. Inserting Hundreds of Thousands of Posts at Once
  54. wp_admin edit.php slow with lots of queries
  55. How to add and SQL query of posts only published
  56. Slow Mysql Queries
  57. can database and media folder be moved to a different drive?
  58. Find duplicate posts with same slug and author
  59. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  60. writing inner join in wpdb
  61. How to get data from WordPress site sql file
  62. Unknown collation when I import a dump from an existing site into a development database?
  63. PHP script can’t connect to Database on port 3307
  64. WordPress with php5-fpm and nginx
  65. How to split the a table in database?
  66. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  67. How to translate this mySQL query to $wpdb query
  68. $wpdb to insert html form information
  69. Proper usage of $wpdb->update()?
  70. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  71. Separate DB by yearly archive of WordPress
  72. What should a WordPress developer know about MySQL? [closed]
  73. Copyright: Get first and last date of post type
  74. Update MySQL query so that it functions again
  75. Query posts by custom taxonomy and sort by post_modified
  76. WordPress $wpdb get posts from category and sort by custom meta
  77. WordPress tables and aliases?
  78. What’s the sql for this condition?
  79. Copy usermeta value where ID matches in the same table
  80. Array Formation Issue
  81. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  82. WordPress $wpdb no result
  83. User set date and time from frontend doesn’t get stored into database
  84. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  85. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  86. edit_user_created_user hook – using to update Groups
  87. Mysql Error in querying form entries in Gravity Form plugin
  88. update_option returns false in AJAX, how to debug?
  89. Improving performance of SQL sub-queries in WordPress
  90. Saving custom term value to the database in new table
  91. MySQL errors after a WordPress clone
  92. MYSQL Join on meta key value?
  93. Complicated MySQL Query
  94. problem with quotes on new post
  95. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  96. Why does the MySQL command line tool ignore the –port parameter?
  97. How can I show user’s privileges in MySQL?
  98. Postgres equivalent to MySQL’s \G?
  99. Changing host permissions for MySQL users
  100. Possible SQL injection. How to locate and fix?

Leave a Comment