0

I downloaded mysql, run it, and used popSQL to connect to my database...

somehow comes this error when i try to test the connection or run my code...

Uh oh :( Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

please advise.. I tried the suggestions on a similar post here onstackexchange but its still not working...

what should i do? I am using windows 10.

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' -- Missing /var/run/mysqld/mysqld.sock

QUTADAH
  • 11
  • 6
  • seems that the server is not running, but question needs more details ... how do you connect, what is the server environment (how is it installed) etc. – Flash Thunder Oct 08 '21 at 17:38
  • I run the mySQL Command Line Client and created a database with the same name that I am trying to connect to... I used hostname as "localhost" – QUTADAH Oct 08 '21 at 17:39
  • using the default port 3306, and using using my username and password as entered on mysql – QUTADAH Oct 08 '21 at 17:40
  • what do you mean how the server environment is installed, im pretty new to SQL.. – QUTADAH Oct 08 '21 at 17:41
  • how did you create a database then? and that error seems to be a `unix` one, as windows mysql doesn't use `/run/mysqld/mysqld.sock` afaik – Flash Thunder Oct 08 '21 at 17:41
  • I went to Command Line Client and typed create database giraffe – QUTADAH Oct 08 '21 at 17:41
  • command line where? are you trying to connect mysql server on linux machine by `localhost` from windows? – Flash Thunder Oct 08 '21 at 17:42
  • I followed the steps in this tutorial https://www.youtube.com/watch?v=HXV3zeQKqGY – QUTADAH Oct 08 '21 at 17:42
  • can't chat with you, because u got too few points of rep, but seems that you are getting it wrong... is your server in different machine than your client? – Flash Thunder Oct 08 '21 at 17:43
  • I dont know how can it be on a different machine, it is all local to my windows pc .. – QUTADAH Oct 08 '21 at 17:44
  • but the server is on linux, not windows, it wouldn't throw such an error if it would be on windows – Flash Thunder Oct 08 '21 at 17:44
  • I'm sorry, but I can't help you if you don't know the basics about the client-side configuration. And if you have created a database, means you did connect to it. – Flash Thunder Oct 08 '21 at 17:47
  • ok i will read into it a bit and come back to you thanks! I followed the tutorial as explained for windows configuration for your reference – QUTADAH Oct 08 '21 at 17:48

0 Answers0