8.2.0 new install, MySQL won't start

[mboudreau]

I am installing XAMPP 8.2.0 on an iMac running macOS 13.2.1 Ventura. After installation, I ran 'xampp security', which behaved as described in the FAQ. When I start or restart all the XAMPP servers, Apache and ProFTPD run, but MySQL shuts down. The MySQL error log shows this:

Code: Select all

2023-03-08 20:54:02 18545 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/Michaels-iMac.local.pid ended
2023-03-08 20:54:30 18 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2023-03-08 20:54:30 18976 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
2023-03-08 20:54:30 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2023-03-08 20:54:30 0 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld (mysqld 10.4.27-MariaDB) starting as process 19129 ...
2023-03-08 20:54:30 0 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
2023-03-08 20:54:30 0 [ERROR] mysqld: Can't lock aria control file '/Applications/XAMPP/xamppfiles/var/mysql/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds
2023-03-08 20:55:01 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/Applications/XAMPP/xamppfiles/var/mysql/aria_log_control'
2023-03-08 20:55:01 0 [ERROR] Plugin 'Aria' init function returned error.
2023-03-08 20:55:01 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2023-03-08 20:55:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-08 20:55:01 0 [Note] InnoDB: Uses event mutexes
2023-03-08 20:55:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-03-08 20:55:01 0 [Note] InnoDB: Number of pools: 1
2023-03-08 20:55:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-03-08 20:55:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-03-08 20:55:01 0 [Note] InnoDB: Completed initialization of buffer pool
2023-03-08 20:55:01 0 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1 error: 35
2023-03-08 20:55:01 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2023-03-08 20:55:01 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-03-08 20:55:01 0 [Note] InnoDB: Starting shutdown...
2023-03-08 20:55:01 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-03-08 20:55:01 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-03-08 20:55:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-03-08 20:55:01 0 [ERROR] Failed to initialize plugins.
2023-03-08 20:55:01 0 [ERROR] Aborting
2023-03-08 20:55:01 18976 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/Michaels-iMac.local.pid ended


[angelaivey]

I am installing XAMPP 8.2.0 on an iMac running macOS 13.2.1 Ventura. After installation, I ran 'xampp security', which behaved as described in the FAQ. When I start or restart all the XAMPP servers, Apache and ProFTPD run, but MySQL shuts down. The MySQL error log shows this:

Code: Select all

2023-03-08 20:54:02 18545 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/Michaels-iMac.local.pid ended
2023-03-08 20:54:30 18 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2023-03-08 20:54:30 18976 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
2023-03-08 20:54:30 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2023-03-08 20:54:30 0 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld (mysqld 10.4.27-MariaDB) starting as process 19129 ...
2023-03-08 20:54:30 0 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
2023-03-08 20:54:30 0 [ERROR] mysqld: Can't lock aria control file '/Applications/XAMPP/xamppfiles/var/mysql/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds
2023-03-08 20:55:01 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/Applications/XAMPP/xamppfiles/var/mysql/aria_log_control'
2023-03-08 20:55:01 0 [ERROR] Plugin 'Aria' init function returned error.
2023-03-08 20:55:01 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2023-03-08 20:55:01 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-08 20:55:01 0 [Note] InnoDB: Uses event mutexes
2023-03-08 20:55:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-03-08 20:55:01 0 [Note] InnoDB: Number of pools: 1
2023-03-08 20:55:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-03-08 20:55:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-03-08 20:55:01 0 [Note] InnoDB: Completed initialization of buffer pool
2023-03-08 20:55:01 0 [ERROR] InnoDB: Unable to lock /Applications/XAMPP/xamppfiles/var/mysql/ibdata1 error: 35
2023-03-08 20:55:01 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2023-03-08 20:55:01 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-03-08 20:55:01 0 [Note] InnoDB: Starting shutdown...
2023-03-08 20:55:01 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-03-08 20:55:01 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-03-08 20:55:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-03-08 20:55:01 0 [ERROR] Failed to initialize plugins.
2023-03-08 20:55:01 0 [ERROR] Aborting
2023-03-08 20:55:01 18976 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/Michaels-iMac.local.pid ended


Hi,
I want to suggest a solution. Hope that it works.
1. Stop the MySQL server.

2. Make a backup copy of the entire MySQL data directory.

3. Restart the MySQL server with the --innodb_force_recovery option set to a value of 1 or higher. This option disables certain InnoDB features to allow for recovery to proceed.

4. Dump all InnoDB tables to a backup file using mysqldump.

5. Stop the MySQL server again.

6. Remove all files in the MySQL data directory except for the following: ibdata1, ib_logfile0, and ib_logfile1.

7. Restart the MySQL server normally.

8. Reload the InnoDB tables from the backup file created in step 4 using the mysql command.

Note that there is a risk of data loss during this process, so it is important to make sure you have a backup of your data before proceeding.

[mboudreau]

Thanks! Removing the problematic files did the trick.