Registrations: Open.
Please register here.

Mysql not starting. Please help!

All MAMP discussions around troubleshooting and anything related to MAMP. Be as detailed as possible here when posting an issue.
Post Reply
eswanson
Posts: 1
Joined: Fri May 28, 2021 2:49 am

Mysql not starting. Please help!

Post by eswanson »

On a macbook pro with an m1 chip
MAMP Pro

MySql Error Log:
2021-05-28T02:40:48.6NZ mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
2021-05-28T02:44:15.6NZ mysqld_safe Logging to '/Applications/MAMP/logs/mysql_error.log'.
2021-05-28T02:44:15.6NZ mysqld_safe Starting mysqld daemon with databases from /Library/Application Support/appsolute/MAMP PRO/db/mysql57
2021-05-28T02:44:15.642970Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2021-05-28T02:44:15.644305Z 0 [Note] /Applications/MAMP/Library/bin/mysqld (mysqld 5.7.32) starting as process 5857 ...
2021-05-28T02:44:15.654443Z 0 [Warning] Setting lower_case_table_names=2 because file system for /Library/Application Support/appsolute/MAMP PRO/db/mysql57/ is case insensitive
2021-05-28T02:44:15.661407Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-05-28T02:44:15.661441Z 0 [Note] InnoDB: Uses event mutexes
2021-05-28T02:44:15.661448Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-05-28T02:44:15.661484Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-28T02:44:15.661554Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2021-05-28T02:44:15.665253Z 0 [Note] InnoDB: Number of pools: 1
2021-05-28T02:44:15.666858Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-05-28T02:44:15.668719Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-05-28T02:44:15.682815Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-28T02:44:15.704828Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-05-28T02:44:15.740351Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-28T02:44:15.740508Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-28T02:44:15.749746Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-05-28T02:44:15.752389Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-05-28T02:44:15.752437Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-05-28T02:44:15.753137Z 0 [Note] InnoDB: Waiting for purge to start
2021-05-28T02:44:15.808294Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 115785122
2021-05-28T02:44:15.809081Z 0 [Note] InnoDB: Loading buffer pool(s) from /Library/Application Support/appsolute/MAMP PRO/db/mysql57/ib_buffer_pool
2021-05-28T02:44:15.809923Z 0 [Note] Plugin 'FEDERATED' is disabled.
2021-05-28T02:44:15.810558Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210527 20:44:15
mysqld: Table 'mysql.plugin' doesn't exist
2021-05-28T02:44:15.811319Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2021-05-28T02:44:15.814522Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-05-28T02:44:15.829022Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-05-28T02:44:15.829045Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2021-05-28T02:44:15.835171Z 0 [Warning] CA certificate ca.pem is self signed.
2021-05-28T02:44:15.835846Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-05-28T02:44:15.836289Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 8889
2021-05-28T02:44:15.837317Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2021-05-28T02:44:15.837404Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2021-05-28T02:44:15.838541Z 0 [Warning] Insecure configuration for --pid-file: Location '/Applications/MAMP/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2021-05-28T02:44:15.839122Z 0 [Warning] Failed to open optimizer cost constant tables

2021-05-28T02:44:15.839309Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2021-05-28T02:44:15.839607Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2021-05-28T02:44:15.839706Z 0 [ERROR] Aborting

2021-05-28T02:44:15.839738Z 0 [Note] Binlog end
2021-05-28T02:44:15.840043Z 0 [Note] Shutting down plugin 'ngram'
2021-05-28T02:44:15.840052Z 0 [Note] Shutting down plugin 'partition'
2021-05-28T02:44:15.840058Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-05-28T02:44:15.840062Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-05-28T02:44:15.840065Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-05-28T02:44:15.840099Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-05-28T02:44:15.840104Z 0 [Note] Shutting down plugin 'MyISAM'
2021-05-28T02:44:15.840310Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-05-28T02:44:15.840319Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-05-28T02:44:15.840323Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-05-28T02:44:15.840326Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-05-28T02:44:15.840328Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-05-28T02:44:15.840332Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-05-28T02:44:15.840334Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-05-28T02:44:15.840337Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-05-28T02:44:15.840340Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-05-28T02:44:15.840343Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-05-28T02:44:15.840346Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-05-28T02:44:15.840348Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-05-28T02:44:15.840351Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-05-28T02:44:15.840354Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-05-28T02:44:15.840357Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-05-28T02:44:15.840359Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-05-28T02:44:15.840361Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-05-28T02:44:15.840364Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-05-28T02:44:15.840366Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-05-28T02:44:15.840369Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-05-28T02:44:15.840371Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-05-28T02:44:15.840373Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-05-28T02:44:15.840376Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-05-28T02:44:15.840378Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-05-28T02:44:15.840380Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-05-28T02:44:15.840383Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-05-28T02:44:15.840385Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-05-28T02:44:15.840388Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-05-28T02:44:15.840390Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-05-28T02:44:15.840392Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-05-28T02:44:15.840395Z 0 [Note] Shutting down plugin 'InnoDB'
2021-05-28T02:44:15.840578Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-05-28T02:44:15.840606Z 0 [Note] InnoDB: Starting shutdown...
2021-05-28T02:44:15.945943Z 0 [Note] InnoDB: Dumping buffer pool(s) to /Library/Application Support/appsolute/MAMP PRO/db/mysql57/ib_buffer_pool
2021-05-28T02:44:15.946629Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210527 20:44:15
2021-05-28T02:44:17.203798Z 0 [Note] InnoDB: Shutdown completed; log sequence number 115785141
2021-05-28T02:44:17.204439Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-05-28T02:44:17.204501Z 0 [Note] Shutting down plugin 'MEMORY'
2021-05-28T02:44:17.204547Z 0 [Note] Shutting down plugin 'CSV'
2021-05-28T02:44:17.204555Z 0 [Note] Shutting down plugin 'sha256_password'
2021-05-28T02:44:17.204558Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-05-28T02:44:17.204731Z 0 [Note] Shutting down plugin 'binlog'
2021-05-28T02:44:17.205683Z 0 [Note] /Applications/MAMP/Library/bin/mysqld: Shutdown complete

2021-05-28T02:44:17.6NZ mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
Post Reply