2002 Error

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

2002 Error

Postby cjg » 24. August 2006 15:51

Any time I try to connect to my MySQL database from dreamweaver I get a 2002 error "Can't connect to local MySQL server through socket '/Applications/xampp/xamppfiles/var/mysql/mysql.sock' (13)"

MySQL is running; I can access the databases through PHPMyAdmin.

The mysql.sock file is also present in the directory as the path shows in the error.

The error file from that directory shows the following:

060824 09:41:02 mysqld started
060824 9:41:03 [Warning] Setting lower_case_table_names=2 because file system for /Applications/xampp/xamppfiles/var/mysql/ is case insensitive
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
060824 9:41:03 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060824 9:41:03 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
060824 9:41:03 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060824 9:41:03 InnoDB: Started; log sequence number 0 0
060824 9:41:03 [Note] /Applications/xampp/xamppfiles/sbin/mysqld: ready for connections.
Version: '5.0.15' socket: '/Applications/xampp/xamppfiles/var/mysql/mysql.sock' port: 3306 Source distribution
060824 9:42:30 [Note] /Applications/xampp/xamppfiles/sbin/mysqld: Normal shutdown

060824 9:42:30 InnoDB: Starting shutdown...
060824 9:42:33 InnoDB: Shutdown completed; log sequence number 0 43655
060824 9:42:33 [Note] /Applications/xampp/xamppfiles/sbin/mysqld: Shutdown complete

060824 09:42:33 mysqld ended

060824 09:53:05 mysqld started
060824 9:53:05 [Warning] Setting lower_case_table_names=2 because file system for /Applications/xampp/xamppfiles/var/mysql/ is case insensitive
060824 9:53:06 InnoDB: Started; log sequence number 0 43655
060824 9:53:06 [Note] /Applications/xampp/xamppfiles/sbin/mysqld: ready for connections.
Version: '5.0.15' socket: '/Applications/xampp/xamppfiles/var/mysql/mysql.sock' port: 3306 Source distribution


Anyone have ideas as to what's going wrong?
cjg
 
Posts: 3
Joined: 24. August 2006 15:45

Postby cjg » 24. August 2006 16:01

Ok, well I just tried to connect through PHPMyAdmin again and I get the same error now. ( MySQL said: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) )

But I was definitely able to access it before.
cjg
 
Posts: 3
Joined: 24. August 2006 15:45

Postby cjg » 28. August 2006 13:26

I found my error and thought I might post it in case other people run into the same problem.

In order to copy my site into the appropriate folder I had been changing the owner of the whole XAMPP installation to me. This is what cause the install to be unable to access the .sock file.

I was able to solve the problem by leaving the system as the owner for the majority of the install and simply changing the htdocs folder to be owned by me.
cjg
 
Posts: 3
Joined: 24. August 2006 15:45

cjg

Postby oblidat » 08. November 2006 01:27

Hi CJG!
I have the same problem (( MySQL said: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured))), ! How did you resolve?

Thank you!
oblidat
 
Posts: 1
Joined: 08. November 2006 01:14


Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 16 guests