I tried to upload product through magmi. After run import i got an error

enter image description here

SQLSTATE[HY000] [2002] Connection timed out

How can i fix this

  • Does the import fail immediately or partway through the import?
    – MartyS
    Sep 18, 2016 at 13:16
  • it's failed means not import single product also
    – Magento 2
    Sep 18, 2016 at 15:54
  • restart mysql at server and also check your credential in magmi and try again Sep 19, 2016 at 3:50
  • I done restart my sql still same error
    – Magento 2
    Sep 19, 2016 at 17:32
  • 1
    If your magento store is working properly then you have entered the database credentials wrong in the magmi profile
    – Goku
    Sep 21, 2016 at 5:18

2 Answers 2


If you are using a local socket then you should specify that you are using a socket under connectivity other wise you will have to add a tcp route such as localhost or an ip address such as
enter image description here


This is the error because the magmi importer has timed out while uploading data to your database. You can ask your hosting providers to increase the maximum timeout of your sql database and increase maximum memory.

Not the answer you're looking for? Browse other questions tagged or ask your own question.