I am new to using SQL and MySQL. I recently installed MySQL Server 8.0.27 on Windows 10. Everything appeared to be going fine at first, since I started the server for port 3306 (I checked on services and the status says 'running') and ran the command line client with no problems. I opened the command line client, entered my password and used the command 'create database database name;'. This seemed to work as below it read "Query OK, 1 row affected (1.82 sec)".

I signed up to PopSQL and created a new connection for my database. I used an arbitrary nickname, "localhost" for hostname, 3306 for port number, the correct database name, root for username and the correct password. When I tested this connection I received the error: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2).

I've been searching online for solutions, and tried using 127.0.0.1 as hostname instead. After testing again I received the error: Can't connect to MySQL server on '127.0.0.1' (115). Additionally, I searched through the 'MySQL Server 8.0' folder and couldn't find a .sock file anywhere in any of the folders inside. Please help me with this :)

1

5 Answers

1.Select 'Connect directly from my computer' button option.

2.Put username to root.

0

Im new to SQL, and I had a similar problem to you. I was able to fix it by going to preference > connections > managing connection > advance options: selecting Connect directly from my computer PopSQL servers won't have access to your database. This method worked for me.

1

I had the same error with popsql and when i changed my username to root everything worked. Also make sure you enter your database name (the one you create from mysql command line client) correctly .

I solved the same error just by restarting my PC*.

*It was a fresh install of both PopSQL and MySQL Server so perhaps it was due to that.

I just set every name as root and it works for mesee this image

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.