XAMPPErrorDomain error 1 for changin MySQL data dirs

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

XAMPPErrorDomain error 1 for changin MySQL data dirs

Postby petruza » 08. December 2009 15:10

Hi, I tried to move my mysql data dir from one disk to another, I modified the `datadir` parameter in my.cnf, but when XAMPP, and more precisely, MySQL starts, this error is displayed and MySQL doesn't run.

Operation could not be completed.
(XAMPPErrorDomain error 1.)

What's the problem here? I correctly specified the new path.
petruza
 
Posts: 8
Joined: 27. September 2009 19:29

Re: XAMPPErrorDomain error 1 for changin MySQL data dirs

Postby catalin.dumitru » 10. July 2010 18:45

I had the same problem until I changed the permissions to "Read & Write" for the "XAMPP/xamppfiles/var" folder, and all enclosed items.

After that was done, MySQL started working again :).
catalin.dumitru
 
Posts: 1
Joined: 10. July 2010 18:42

Re: XAMPPErrorDomain error 1 for changin MySQL data dirs

Postby meusgastos » 05. December 2011 02:33

I spent weeks before figure this out. XAMPP stores its my.cnf files into /Applications/XAMPP/xamppfiles/etc/my.cnf

Sometimes (specially if you install mysql workbench) it will generate a new file into /etc/my.cnf file. Just delete this second one (or fullfill it correctly) and everything will work again. Finder will not show you this folder, so you should use terminal or finder`s menu "go".
meusgastos
 
Posts: 1
Joined: 05. December 2011 02:03
XAMPP Version: 1.8.3-2
Operating System: windows vista & os X Lion

Re: XAMPPErrorDomain error 1 for changin MySQL data dirs

Postby angela_zou » 06. December 2011 04:49

Hi guys,

I'm having the same issue here, except that I didn't move MySQL files nor do I have a extra copy of /etc/my.cnf file. But I think it may be related to how I inappropriately shut down XAMPP yesterday (just quit the application). And interestingly, now by default, the application runs with Apache on, even if I turned it off before quitting the application and start it again. Could this be a bug?

Angela

PS: I found a couple other posts related to this issue, but no one seems to have the answer. I tried everything, I even made the entire XAMPP folder readable/writable via my user account and applied the settings to all enclosing items. Even after, I was not able to start up MySQL

Here is the content of the error_log starting from yesterday. However, I didn't see mentions of the error 1


[Mon Dec 05 11:04:06 2011] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Mon Dec 05 11:04:08 2011] [notice] Digest: generating secret for digest authentication ...
[Mon Dec 05 11:04:08 2011] [notice] Digest: done
[Mon Dec 05 11:04:09 2011] [notice] Apache/2.2.14 (Unix) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l PHP/5.3.1 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Mon Dec 05 22:57:42 2011] [notice] caught SIGTERM, shutting down
[Tue Dec 06 11:39:51 2011] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Tue Dec 06 11:39:59 2011] [notice] Digest: generating secret for digest authentication ...
[Tue Dec 06 11:39:59 2011] [notice] Digest: done
[Tue Dec 06 11:40:02 2011] [notice] Apache/2.2.14 (Unix) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l PHP/5.3.1 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
angela_zou
 
Posts: 13
Joined: 30. November 2011 06:28
XAMPP Version: 1.8.3-2
Operating System: Mac OS X Leopard

Re: XAMPPErrorDomain error 1 for changin MySQL data dirs

Postby angela_zou » 06. December 2011 05:18

I found another error log in xamppfiles/var/mysql/angela-zous-macbook.local.err. I tried to enable the MySQL service many times, so there are quit a few entries, most of them are similar, but there are many weird errors.

Code: Select all
111206 11:39:51 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
111206 11:39:52 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
111206 11:39:52 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
111206 11:39:52 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
111206 11:39:52 [Note] Plugin 'FEDERATED' is disabled.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Table 'mysql.plugin' doesn't exist
111206 11:39:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
111206 11:39:53  InnoDB: Started; log sequence number 0 44243
111206 11:39:53 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
111206 11:39:53 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/angela-zous-macbook.local.pid ended
111206 11:39:58 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
111206 11:39:58 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
111206 11:39:58 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
111206 11:39:58 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
111206 11:39:58 [Note] Plugin 'FEDERATED' is disabled.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Table 'mysql.plugin' doesn't exist
111206 11:39:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
111206 11:39:58  InnoDB: Started; log sequence number 0 44243
111206 11:39:58 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
111206 11:39:58 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/angela-zous-macbook.local.pid ended
111206 11:40:01 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
111206 11:40:01 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
111206 11:40:01 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
111206 11:40:01 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
111206 11:40:01 [Note] Plugin 'FEDERATED' is disabled.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Table 'mysql.plugin' doesn't exist
111206 11:40:01 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
111206 11:40:01  InnoDB: Started; log sequence number 0 44243
111206 11:40:01 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
111206 11:40:01 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/angela-zous-macbook.local.pid ended
111206 11:40:31 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
111206 11:40:31 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
111206 11:40:31 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
111206 11:40:31 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
111206 11:40:31 [Note] Plugin 'FEDERATED' is disabled.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Table 'mysql.plugin' doesn't exist
111206 11:40:31 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
111206 11:40:31  InnoDB: Started; log sequence number 0 44243
111206 11:40:31 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
111206 11:40:31 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/angela-zous-macbook.local.pid ended
111206 11:40:48 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
111206 11:40:48 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
111206 11:40:48 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
111206 11:40:48 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
111206 11:40:48 [Note] Plugin 'FEDERATED' is disabled.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Table 'mysql.plugin' doesn't exist
111206 11:40:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
111206 11:40:48  InnoDB: Started; log sequence number 0 44243
111206 11:40:48 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
111206 11:40:48 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/angela-zous-macbook.local.pid ended
111206 11:40:52 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
111206 11:40:52 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
111206 11:40:52 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
111206 11:40:52 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
111206 11:40:52 [Note] Plugin 'FEDERATED' is disabled.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Table 'mysql.plugin' doesn't exist
111206 11:40:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
111206 11:40:52  InnoDB: Started; log sequence number 0 44243
111206 11:40:52 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
111206 11:40:52 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/angela-zous-macbook.local.pid ended
111206 11:45:20 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
111206 11:45:20 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
111206 11:45:20 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
111206 11:45:20 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
111206 11:45:20 [Note] Plugin 'FEDERATED' is disabled.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Table 'mysql.plugin' doesn't exist
111206 11:45:20 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
111206 11:45:20  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
111206 11:45:20 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/angela-zous-macbook.local.pid ended
111206 11:54:07 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
111206 11:54:07 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
111206 11:54:07 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
111206 11:54:07 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
111206 11:54:07 [Note] Plugin 'FEDERATED' is disabled.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Table 'mysql.plugin' doesn't exist
111206 11:54:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Can't create/write to file '/Applications/XAMPP/xamppfiles/temp/ib2h0zr9' (Errcode: 13)
111206 11:54:07  InnoDB: Error: unable to create temporary file; errno: 13
111206 11:54:07 [ERROR] Plugin 'InnoDB' init function returned error.
111206 11:54:07 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111206 11:54:07 [ERROR] Can't start server : Bind on unix socket: Permission denied
111206 11:54:07 [ERROR] Do you already have another mysqld server running on socket: /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock ?
111206 11:54:07 [ERROR] Aborting

111206 11:54:07 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld: Shutdown complete

111206 11:54:07 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/angela-zous-macbook.local.pid ended
111206 12:00:16 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
111206 12:00:16 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
111206 12:00:16 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
111206 12:00:16 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
111206 12:00:16 [Note] Plugin 'FEDERATED' is disabled.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Table 'mysql.plugin' doesn't exist
111206 12:00:16 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Can't create/write to file '/Applications/XAMPP/xamppfiles/temp/iboe48Vs' (Errcode: 13)
111206 12:00:16  InnoDB: Error: unable to create temporary file; errno: 13
111206 12:00:16 [ERROR] Plugin 'InnoDB' init function returned error.
111206 12:00:16 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111206 12:00:16 [ERROR] Can't start server : Bind on unix socket: Permission denied
111206 12:00:16 [ERROR] Do you already have another mysqld server running on socket: /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock ?
111206 12:00:16 [ERROR] Aborting

111206 12:00:16 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld: Shutdown complete

111206 12:00:16 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/angela-zous-macbook.local.pid ended
111206 12:03:47 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
111206 12:03:47 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
111206 12:03:47 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
111206 12:03:47 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
111206 12:03:47 [Note] Plugin 'FEDERATED' is disabled.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Table 'mysql.plugin' doesn't exist
111206 12:03:47 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Can't create/write to file '/Applications/XAMPP/xamppfiles/temp/ibR2Qj8Z' (Errcode: 13)
111206 12:03:47  InnoDB: Error: unable to create temporary file; errno: 13
111206 12:03:47 [ERROR] Plugin 'InnoDB' init function returned error.
111206 12:03:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111206 12:03:47 [ERROR] Can't start server : Bind on unix socket: Permission denied
111206 12:03:47 [ERROR] Do you already have another mysqld server running on socket: /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock ?
111206 12:03:47 [ERROR] Aborting

111206 12:03:47 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld: Shutdown complete

111206 12:03:47 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/angela-zous-macbook.local.pid ended
111206 12:11:57 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
111206 12:11:57 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
111206 12:11:57 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072
111206 12:11:58 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
111206 12:11:58 [Note] Plugin 'FEDERATED' is disabled.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Table 'mysql.plugin' doesn't exist
111206 12:11:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Can't create/write to file '/Applications/XAMPP/xamppfiles/temp/ibrXnx4U' (Errcode: 13)
111206 12:11:58  InnoDB: Error: unable to create temporary file; errno: 13
111206 12:11:58 [ERROR] Plugin 'InnoDB' init function returned error.
111206 12:11:58 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111206 12:11:58 [ERROR] Can't start server : Bind on unix socket: Permission denied
111206 12:11:58 [ERROR] Do you already have another mysqld server running on socket: /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock ?
111206 12:11:58 [ERROR] Aborting

111206 12:11:58 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld: Shutdown complete

111206 12:11:58 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/angela-zous-macbook.local.pid ended
angela_zou
 
Posts: 13
Joined: 30. November 2011 06:28
XAMPP Version: 1.8.3-2
Operating System: Mac OS X Leopard

Re: XAMPPErrorDomain error 1 for changin MySQL data dirs

Postby angela_zou » 07. December 2011 01:40

Help? I really need to know what's going on with MySQL
angela_zou
 
Posts: 13
Joined: 30. November 2011 06:28
XAMPP Version: 1.8.3-2
Operating System: Mac OS X Leopard

Re: XAMPPErrorDomain error 1 for changin MySQL data dirs

Postby JonB » 07. December 2011 04:31

@ OP

I correctly specified the new path.


and what would that be??? ---

if its not on 'your Mac', that's likely the problem

8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: XAMPPErrorDomain error 1 for changin MySQL data dirs

Postby JonB » 07. December 2011 04:36

@ angela -

I have read that finder/shell can't handle this operation correctly and it should only be done in term - good luck

8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Mac OS X

Who is online

Users browsing this forum: No registered users and 2 guests