1. P.Hartung
  2. MAMP - General Discussion
  3. Tuesday, 10 March 2020

2020-03-10T12:30:54.6NZ mysqld_safe Logging to '/Applications/MAMP/logs/mysql_error.log'.
2020-03-10T12:30:54.6NZ mysqld_safe Starting mysqld daemon with databases from /Library/Application Support/appsolute/MAMP PRO/db/mysql57
2020-03-10T12:30:54.904566Z 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.
2020-03-10T12:30:54.904915Z 0 [Note] /Applications/MAMP/Library/bin/mysqld (mysqld 5.7.26) starting as process 3282 ...
2020-03-10T12:30:54.909797Z 0 [Warning] Setting lower_case_table_names=2 because file system for /Library/Application Support/appsolute/MAMP PRO/db/mysql57/ is case insensitive
2020-03-10T12:30:54.912844Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-10T12:30:54.912881Z 0 [Note] InnoDB: Uses event mutexes
2020-03-10T12:30:54.912891Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-10T12:30:54.912899Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-10T12:30:54.912932Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2020-03-10T12:30:54.913445Z 0 [Note] InnoDB: Number of pools: 1
2020-03-10T12:30:54.913809Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-03-10T12:30:54.915202Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-10T12:30:54.923740Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-10T12:30:54.940785Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-10T12:30:54.960641Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-10T12:30:54.960795Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-10T12:30:54.969105Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-10T12:30:54.970241Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-10T12:30:54.970271Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-10T12:30:54.970668Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-10T12:30:55.021121Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2551369
2020-03-10T12:30:55.021388Z 0 [Note] InnoDB: Loading buffer pool(s) from /Library/Application Support/appsolute/MAMP PRO/db/mysql57/ib_buffer_pool
2020-03-10T12:30:55.021554Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-10T12:30:55.030208Z 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-03-10T12:30:55.030271Z 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-03-10T12:30:55.033613Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2020-03-10T12:30:55.034263Z 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.
2020-03-10T12:30:55.037855Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200310 13:30:55
2020-03-10T12:30:55.054680Z 0 [Note] Failed to start slave threads for channel ''
2020-03-10T12:30:55.103691Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-10T12:30:55.103826Z 0 [Note] /Applications/MAMP/Library/bin/mysqld: ready for connections.
Version: '5.7.26' socket: '/Applications/MAMP/tmp/mysql/mysql.sock' port: 0 MySQL Community Server (GPL)
2020-03-10T12:30:55.155031Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:30:55.165653Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:30:55.180315Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:30:55.209530Z 6 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:30:55.584348Z 7 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:30:55.720541Z 8 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-03-10T12:30:55.720601Z 8 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-03-10T12:32:32.513646Z 45 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:35:32.602470Z 50 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:35:35.344570Z 51 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:35:35.428737Z 52 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:35:35.447048Z 53 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:35:35.458325Z 54 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:35:35.469310Z 55 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:35:35.484282Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-03-10T12:35:35.484305Z 0 [Note] Shutting down slave threads
2020-03-10T12:35:35.484334Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-03-10T12:35:35.484346Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-03-10T12:35:35.484415Z 0 [Note] Binlog end
2020-03-10T12:35:35.484830Z 0 [Note] Shutting down plugin 'ngram'
2020-03-10T12:35:35.484852Z 0 [Note] Shutting down plugin 'partition'
2020-03-10T12:35:35.484862Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-03-10T12:35:35.484872Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-03-10T12:35:35.484880Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-03-10T12:35:35.484905Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-03-10T12:35:35.484915Z 0 [Note] Shutting down plugin 'MyISAM'
2020-03-10T12:35:35.484941Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-03-10T12:35:35.484951Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-03-10T12:35:35.484959Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-03-10T12:35:35.484967Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-03-10T12:35:35.484975Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-03-10T12:35:35.484983Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-03-10T12:35:35.484991Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-03-10T12:35:35.484999Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-03-10T12:35:35.485007Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-03-10T12:35:35.485015Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-03-10T12:35:35.485023Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-03-10T12:35:35.485031Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-03-10T12:35:35.485039Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-03-10T12:35:35.485047Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-03-10T12:35:35.485055Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-03-10T12:35:35.485062Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-03-10T12:35:35.485070Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-03-10T12:35:35.485078Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-03-10T12:35:35.485086Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-03-10T12:35:35.485094Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-03-10T12:35:35.485102Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-03-10T12:35:35.485110Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-03-10T12:35:35.485118Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-03-10T12:35:35.485126Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-03-10T12:35:35.485134Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-03-10T12:35:35.485142Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-03-10T12:35:35.485150Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-03-10T12:35:35.485173Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-03-10T12:35:35.485178Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-03-10T12:35:35.485183Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-03-10T12:35:35.485187Z 0 [Note] Shutting down plugin 'InnoDB'
2020-03-10T12:35:35.485256Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-03-10T12:35:35.485311Z 0 [Note] InnoDB: Starting shutdown...
2020-03-10T12:35:35.585927Z 0 [Note] InnoDB: Dumping buffer pool(s) to /Library/Application Support/appsolute/MAMP PRO/db/mysql57/ib_buffer_pool
2020-03-10T12:35:35.586555Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200310 13:35:35
2020-03-10T12:35:36.933364Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2551397
2020-03-10T12:35:36.933741Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-03-10T12:35:36.933759Z 0 [Note] Shutting down plugin 'MEMORY'
2020-03-10T12:35:36.933768Z 0 [Note] Shutting down plugin 'CSV'
2020-03-10T12:35:36.933776Z 0 [Note] Shutting down plugin 'sha256_password'
2020-03-10T12:35:36.933784Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-03-10T12:35:36.933908Z 0 [Note] Shutting down plugin 'binlog'
2020-03-10T12:35:36.934358Z 0 [Note] /Applications/MAMP/Library/bin/mysqld: Shutdown complete

2020-03-10T12:35:36.6NZ mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
2020-03-10T12:35:38.6NZ mysqld_safe Logging to '/Applications/MAMP/logs/mysql_error.log'.
2020-03-10T12:35:39.6NZ mysqld_safe Starting mysqld daemon with databases from /Library/Application Support/appsolute/MAMP PRO/db/mysql57
2020-03-10T12:35:39.211074Z 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.
2020-03-10T12:35:39.211317Z 0 [Note] /Applications/MAMP/Library/bin/mysqld (mysqld 5.7.26) starting as process 4655 ...
2020-03-10T12:35:39.214782Z 0 [Warning] Setting lower_case_table_names=2 because file system for /Library/Application Support/appsolute/MAMP PRO/db/mysql57/ is case insensitive
2020-03-10T12:35:39.217324Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-03-10T12:35:39.217363Z 0 [Note] InnoDB: Uses event mutexes
2020-03-10T12:35:39.217374Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-03-10T12:35:39.217384Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-10T12:35:39.217406Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2020-03-10T12:35:39.217696Z 0 [Note] InnoDB: Number of pools: 1
2020-03-10T12:35:39.217816Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-03-10T12:35:39.219278Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-03-10T12:35:39.229146Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-10T12:35:39.251818Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-03-10T12:35:39.271665Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-10T12:35:39.271848Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-10T12:35:39.280699Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-03-10T12:35:39.281415Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-03-10T12:35:39.281439Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-03-10T12:35:39.281599Z 0 [Note] InnoDB: Waiting for purge to start
2020-03-10T12:35:39.333324Z 0 [Note] InnoDB: 5.7.26 started; log sequence number 2551397
2020-03-10T12:35:39.333829Z 0 [Note] InnoDB: Loading buffer pool(s) from /Library/Application Support/appsolute/MAMP PRO/db/mysql57/ib_buffer_pool
2020-03-10T12:35:39.333901Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-03-10T12:35:39.340692Z 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-03-10T12:35:39.340845Z 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-03-10T12:35:39.341086Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200310 13:35:39
2020-03-10T12:35:39.341111Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2020-03-10T12:35:39.341720Z 0 [Warning] Insecure configuration for --pid-file: Location '/Applications/MAMP/tmp/mysql' in the path is accessible to all OS users. Consider choosing a different directory.
2020-03-10T12:35:39.348211Z 0 [Note] Failed to start slave threads for channel ''
2020-03-10T12:35:39.360360Z 0 [Note] Event Scheduler: Loaded 0 events
2020-03-10T12:35:39.360506Z 0 [Note] /Applications/MAMP/Library/bin/mysqld: ready for connections.
Version: '5.7.26' socket: '/Applications/MAMP/tmp/mysql/mysql.sock' port: 0 MySQL Community Server (GPL)
2020-03-10T12:35:39.464290Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:35:39.477205Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:35:39.489992Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:35:39.516927Z 6 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:35:39.922917Z 7 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2020-03-10T12:35:39.958289Z 8 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-03-10T12:35:39.958376Z 8 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade



Accepted Answer Pending Moderation
0
Votes
Undo

Your issue is in the log, run MySQL upgrade. I'm assuming you're using a newer version of MAMP which has a MySQL 5.7 update

 

Tools -> Upgrade MySQL Databases...

 

2020-03-10T12:35:39.958289Z 8 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade
2020-03-10T12:35:39.958376Z 8 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

  1. more than a month ago
  2. MAMP - General Discussion
  3. # 1
Accepted Answer Pending Moderation
1
Votes
Undo

The solution proposed above didn't work for me because the menu Tools -> Upgrade MySQL Databases was not acessible (as MySQL could not start...). Some kind of never ending loop there.

However, this worked for me:

1. Open MAMP Pro.

2. Stop servers if they are running.

3. Open the MySQL template from the menu: File > Edit Template > MySQL (mysql.cnf) > 5.7.26

4. Add user = root in the [client] and [mysqld] sections:

....
[client]
user = root
...

[client]
user = root
...

5.restart servers

I found the solution on stackoverflow.

  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!