MySQL not starting in MAMP PRO

Right, so i’ve been playing with MAMP and use it to mess around with wordpress plugins and themes. However, I’ve been forced to keep MAMP running at all times because the moment I restart the server (after the first install of MAMP), mySql doesnt start. It works immediately after reinstalling MAMP, but anytime I stop it, it simply gives me an error. The exact error log is:

150812 10:31:33 mysqld_safe Starting mysqld daemon with databases
from /Library/Application Support/appsolute/MAMP PRO/db/mysql 150812
10:31:33 [Warning] Setting lower_case_table_names=2 because file
system for /Library/Application Support/appsolute/MAMP PRO/db/mysql/
is case insensitive 150812 10:31:33 [Note] Plugin ‘FEDERATED’ is
disabled. /Applications/MAMP/Library/bin/mysqld: Table ‘mysql.plugin’
doesn’t exist 150812 10:31:33 [ERROR] Can’t open the mysql.plugin
table. Please run mysql_upgrade to create it. 150812 10:31:33 InnoDB:
The InnoDB memory heap is disabled 150812 10:31:33 InnoDB: Mutexes
and rw_locks use GCC atomic builtins 150812 10:31:33 InnoDB:
Compressed tables use zlib 1.2.3 150812 10:31:33 InnoDB: Initializing
buffer pool, size = 128.0M 150812 10:31:33 InnoDB: Completed
initialization of buffer pool 150812 10:31:33 InnoDB: highest
supported file format is Barracuda. 150812 10:31:33 InnoDB: Waiting
for the background threads to start 150812 10:31:34 InnoDB: 5.5.42
started; log sequence number 346953327 150812 10:31:34 [ERROR] Fatal
error: Can’t open and lock privilege tables: Table ‘mysql.host’
doesn’t exist 150812 10:31:34 mysqld_safe mysqld from pid file
/Applications/MAMP/tmp/mysql/mysql.pid ended

I’ve literally tried everything from killing all mysql processes, to changing port numbers, to restarting both MAMP and the Computer… Nothing seems to work. I even changed the file permission of host.frm to allow all users read&write access.

I have spent hours and hours looking to no avail 🙁 Any suggestions would be HUGELY appreciated!

Thank you!

Shayne


Source: wordpress

Leave a Reply