-1.7 C
Monday, January 15, 2024

Battle appleaccountd with MAMP mySQL

This morning, I turned on my Macbook to work (Sonoma 14.2.1), turned on MAMP and… the sunshine grew to become orange. So I did some checks, Apache is working in order PHP, however not mySQL. I did have a look within the log and it appears to have an issue (error) “One other course of with pid 1970 is utilizing unix socket file” (on the backside of the log I did copy). This pid is listed in Exercise Monitor as course of “appleaccountd”. Googling a bit, it appears this course of is said to iCloud, Apple ID or one thing, I do not know.

How can I repair this?

The mysql_error log:

2024-01-15T14:25:46.6NZ mysqld_safe Logging to '/Functions/MAMP/logs/mysql_error.log'.
2024-01-15T14:25:46.6NZ mysqld_safe Beginning mysqld daemon with databases from /Functions/MAMP/db/mysql57
2024-01-15T14:25:46.860823Z 0 [Warning] TIMESTAMP with implicit DEFAULT worth is deprecated. Please use --explicit_defaults_for_timestamp server possibility (see documentation for extra particulars).
2024-01-15T14:25:46.862149Z 0 [Note] --secure-file-priv is ready to NULL. Operations associated to importing and exporting knowledge are disabled
2024-01-15T14:25:46.862263Z 0 [Note] /Functions/MAMP/Library/bin/mysqld (mysqld 5.7.39) beginning as course of 15182 ...
2024-01-15T14:25:46.877605Z 0 [Warning] Setting lower_case_table_names=2 as a result of file system for /Functions/MAMP/db/mysql57/ is case insensitive
2024-01-15T14:25:46.880577Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-01-15T14:25:46.880629Z 0 [Note] InnoDB: Makes use of occasion mutexes
2024-01-15T14:25:46.880667Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for reminiscence barrier
2024-01-15T14:25:46.880701Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-01-15T14:25:46.881468Z 0 [Note] InnoDB: Variety of swimming pools: 1
2024-01-15T14:25:46.881760Z 0 [Note] InnoDB: Utilizing CPU crc32 directions
2024-01-15T14:25:46.885433Z 0 [Note] InnoDB: Initializing buffer pool, whole dimension = 128M, situations = 1, chunk dimension = 128M
2024-01-15T14:25:46.916650Z 0 [Note] InnoDB: Accomplished initialization of buffer pool
2024-01-15T14:25:46.941850Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-01-15T14:25:47.025712Z 0 [Note] InnoDB: Creating shared tablespace for momentary tables
2024-01-15T14:25:47.025947Z 0 [Note] InnoDB: Setting file './ibtmp1' dimension to 12 MB. Bodily writing the file full; Please wait ...
2024-01-15T14:25:47.056727Z 0 [Note] InnoDB: File './ibtmp1' dimension is now 12 MB.
2024-01-15T14:25:47.058108Z 0 [Note] InnoDB: 96 redo rollback section(s) discovered. 96 redo rollback section(s) are energetic.
2024-01-15T14:25:47.058167Z 0 [Note] InnoDB: 32 non-redo rollback section(s) are energetic.
2024-01-15T14:25:47.058638Z 0 [Note] InnoDB: Ready for purge to start out
2024-01-15T14:25:47.109019Z 0 [Note] InnoDB: 5.7.39 began; log sequence quantity 5570382
2024-01-15T14:25:47.109395Z 0 [Note] Plugin 'FEDERATED' is disabled.
2024-01-15T14:25:47.109806Z 0 [Note] InnoDB: Loading buffer pool(s) from /Functions/MAMP/db/mysql57/ib_buffer_pool
2024-01-15T14:25:47.120190Z 0 [Warning] InnoDB: Desk mysql/innodb_table_stats has size mismatch within the column title table_name.  Please run mysql_upgrade
2024-01-15T14:25:47.120353Z 0 [Warning] InnoDB: Desk mysql/innodb_index_stats has size mismatch within the column title table_name.  Please run mysql_upgrade
2024-01-15T14:25:47.131917Z 0 [Note] Discovered ca.pem, server-cert.pem and server-key.pem in knowledge listing. Making an attempt to allow SSL assist utilizing them.
2024-01-15T14:25:47.131980Z 0 [Note] Skipping era of SSL certificates as certificates recordsdata are current in knowledge listing.
2024-01-15T14:25:47.132008Z 0 [Warning] A deprecated TLS model TLSv1 is enabled. Please use TLSv1.2 or greater.
2024-01-15T14:25:47.132021Z 0 [Warning] A deprecated TLS model TLSv1.1 is enabled. Please use TLSv1.2 or greater.
2024-01-15T14:25:47.134249Z 0 [Warning] CA certificates ca.pem is self signed.
2024-01-15T14:25:47.134436Z 0 [Note] Skipping era of RSA key pair as key recordsdata are current in knowledge listing.
2024-01-15T14:25:47.135239Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2024-01-15T14:25:47.137383Z 0 [Note] IPv6 is accessible.
2024-01-15T14:25:47.137484Z 0 [Note]   - '::' resolves to '::';
2024-01-15T14:25:47.138463Z 0 [Note] Server socket created on IP: '::'.
2024-01-15T14:25:47.139289Z 0 [ERROR] One other course of with pid 1970 is utilizing unix socket file.
2024-01-15T14:25:47.139341Z 0 [ERROR] Unable to setup unix socket lock file.
2024-01-15T14:25:47.139369Z 0 [ERROR] Aborting

Latest news
Related news


Please enter your comment!
Please enter your name here