Page 1 of 1
Error 2002 at Login Screen
Posted:
23. February 2005 18:38
by Philip G. Duffy
I have successfully installed XAMPP on a Linux machine and done an opt/lampp/lampp start to start the servers, but received the following when attempting to login to phpMyAdmin:
Error 2002: Can't connect to local MySQL Server through socket '/opt/lampp/var/mysql/mysqlsock' (2)
I would not expect this message to result from a simple failed login attempt.
Have I failed to set an appropriate conguration option?
Posted:
23. February 2005 19:35
by Oswald
Dear Philip!
Looks like your MySQL didn't came up. There are many reasons. Please take a look into the .err file in /opt/lampp/var/mysql/
Are there any error like messages at the end of this file?
Greetings
Oswald
Error 2002 at Login Screen
Posted:
23. February 2005 23:40
by Philip G. Duffy
Oswald,
Thanks for your guidance. I reviewed the error log and determined that in the past /opt/lampp/lampp start had consistently opened the MySQL server. Today I had an error as follows:
[ERROR] /opt/lampp/sbin/mysqld: unknown option '--Set .._log_file_size to 25% of buffer pool size' <mysql then ended>
Does this narrow the possibilities?
Phil
Posted:
23. February 2005 23:48
by Oswald
Dear Philip!
Did you made any changes to the file /opt/lampp/etc/my.cnf?
I assume you missed a # in front of a line containing Set .._log_file_size to 25 % of buffer pool size
Best regards
Oswald
Error 2002 at Login Screen at Login Screen Solved
Posted:
24. February 2005 02:08
by Philip G. Duffy
Oswald,
You were on target. Mystery solved. I looked in the offending statement in etc/my.cnf and commented it. I had uncommented a series of these statements in the section which directed,
# Uncomment the following if you are using InnoDB tables.
I left the skip-inno-db statement uncommented so my Server believes that I am ready for InnoDB. Frankly I doubt that. But the important thing is that I can get to the phpMyAdmin interface.
But I may be missing an understanding of the correct setup for InnoDB if I proceed. I did not find an explanation in Delisle's Mastering phpMyAdmin (otherwise this text appears to be excellent), so I wonder how I proceed. I suspect that I should also install the Linked Tables Infrastructure to gain the full benefits of phpMyAdmin.
Vielen Dank fuer deine Hilfe.
Phil
Posted:
24. February 2005 02:24
by Wiedmann
I left the skip-inno-db statement uncommented so my Server believes that I am ready for InnoDB.
That's right. Only uncommenting this statement "skip-inno-db" and InnoDB is running well with the standard (compiled) settings.
But I may be missing an understanding of the correct setup for InnoDB if I proceed. I did not find an explanation in...
MySQL have an excellent online manual...
http://dev.mysql.com/doc/mysql/en/innod ... ation.html
Error 2002 at Login Screen
Posted:
24. February 2005 23:43
by Philip G. Duffy
You were right again. I had commented the skip-inno-db statement, left an audit trail, so I understand this part of the system's behavior. I checked the documentation you referenced and it all ties together. This thread should be considered successfully closed. I have an earlier thread still open, and will provide feedback as I go through the next step here.
Vielen Dank und guten Abend (if I get in under the wire as I understand German custom requires).
Phil