Saturday, March 24, 2012

Mysql Error – SQLSTATE[HY000] [2002]

I have come across the following error:
Mysql Error – SQLSTATE[HY000] [2002] No such file or directory
To solve this, you need to open up your php.ini file (mine was in /etc/). Look for the following line:
pdo_mysql.default_socket=/var/mysql/mysql.sock

If that line exists for you, try changing it to:
pdo_mysql.default_socket=/tmp/mysql.sock

Restart apache after saving, and that’s all I had to do.
See the book OpenCart 1.4 Template Design Cookbook.
See the book Joomla Mobile Development Beginners Guide




List of my works:

Opencart Extensions:

  1. Product Based Quantity Wise Shipping: Find it here.
  2. OpenSSLCOMMERZ: integrate SSLCOMMERZ with opencart: Find it here.
  3. Fine Search v.1.0 - Improves Opencart search feature to find relevant: Find it here.
  4. Opensweetcaptcha - An easy way to generate attractive captcha for your system!: Find it here.
  5. Custom Field Product - add unlimited custom fields to the product form: Find it here.
  6. Formcaptcha - add captcha on the register page: Find it here.

My Books:

  1. OpenCart 1.4 Template Design Cookbook.
  2. Joomla Mobile Development Beginners Guide

1 comment:

Nabeel said...

this post solved a problem which is very common for a site.your way to understanding this(Mysql Error) problem is very easy. i hope like me everyone solve his problem to watch this post.
open cart