#MAMP 5 MAC MYSQL SERVER START FAILURE FULL#
I know this is an old thread, but since it popped up now that I experienced the same issue, I figured I'd add the full solution to my own problem. olduser won't be using it any more), then it might be a good idea to also change the ownership of all the files: sudo chown -R newuser:admin /Applications/MAMP If, like in my case, the company laptop was passed from one user to the other (i.e. If newuser is also in the admin group then just add group read and write to the entire MAMP path: sudo chmod -R ug+rw /Applications/MAMP In a typical MAMP installation the ownership is likely set to olduser and the admin group (olduser:admin), with only user read/write permissions. Presumably it is because it was installed by a different user, and all files are owned by that user and write permissions are only set up for the files' owner. mysql/m ( /Applications/MAMP/db/mysql/mysql/m) This issue is related to the current user not having permissions to the file. Please run mysql_upgrade to create it.ġ10803 16:16:26 InnoDB: Started log sequence number 0 396676924ġ10803 16:16:26 /Applications/MAMP/Library/libexec/mysqld: Can't find file: './mysql/m' (errno: 13)ġ10803 16:16:26 Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/m' (errno: 13)ġ10803 16:16:26 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended Applications/MAMP/Library/libexec/mysqld: Can't find file: './mysql/m' (errno: 13)ġ10803 16:16:26 Can't open the ugin table. Here's the mysql log: 110803 16:16:26 Plugin 'FEDERATED' is disabled.ġ10803 16:16:26 Plugin 'ndbcluster' is disabled. I have already restarted the system several times, even checked /etc for the file my.cnf, but there's no my.cnf inside /etcĬouldn't find any form to ask for a support on and am desperately missing my Ubuntu now :-( I have also verified that no other instance of mysqld is running, still it won't run MySql on my system. In my old user, Apache doesn't start and in the new user, MySql doesn't start. You can configure MySQL to automatically start when you turn on your computer using the MySQL Preference Pane.
Start MySQL by clicking Start using the MySQL Preference Pane, which was installed during the default installation.
I am pretty new to Mac itself but managed to find users with similar problems. The MySQL server is installed on the Mac, but it does not load by default. At least I can't find anything in the logs.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. T08:41:24.6NZ mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid endedīut this doesn't seem to do anything at all. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you have in the MySQL server. T08:41:24.356856Z 0 InnoDB: Trying to access page number 606273606 in space 0, space name innodb_system, which is outside the tablespace bounds. Please refer to for information about forcing recovery. T08:41:24.353005Z 0 InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. T08:41:24.352999Z 0 InnoDB: Page log sequence number 1648136734 is in the future! Current system log sequence number 1648136222. T08:41:24.352976Z 0 InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. T08:41:24.352966Z 0 InnoDB: Page log sequence number 1648136393 is in the future! Current system log sequence number 1648136222. I found to delete all log files from /Applications/MAMP/db/mysql57/ib_log* but this generates the following log: T08:41:24.352824Z 0 InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. I already did a ton of research before asking here.Į.g. When I start MAMP (Apache & mysql57), I get the following log: T08:35:38.277831Z 0 InnoDB: Trying to access page number 606273606 in space 0, space name innodb_system, which is outside the tablespace bounds.
#MAMP 5 MAC MYSQL SERVER START FAILURE PRO#
I bought a new MacBook Pro (M1 Pro Chip) and migrated everything from my Mac mini (M1 chip). I've done this in the past already without issues.
0 kommentar(er)
