Mysql no socket file

Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search. I had both mysql and postgres serving fine until I upgraded to natty a little while ago; I have spent hours walking through both databases trying to figure out what is going on.

I can give up on postgres, but I cannot work without a working copy of mysql. The weirdest part: I use Kubuntu, and my understanding is that KDE uses mysql to store user permissions, etc. I am not experiencing any weird permissions issues; can I take this to mean that somehow? MySQL is actually working? Maybe these socket files live in a different place in natty? Would it be easier to just reinstall the os fresh?

At this point, I am open to any suggestions that will stop wasting my time. A socket file doesnt actually contain data, it transports it.. It is not an ordinary file. It is like a pipe the server and the clients can use to connect and exchange requests and data. Also, it is only used locally. Its significance is merely as an agreed rendezvous location in the filesystem.

Creating a plain old file and putting it in that location may actually interfere with the server creating it My recommendation is to remove any file you put in the location. The special socket file is created by the server. Community Control Panel. Hacktoberfest Contribute to Open Source. About the authors. Mark Drake. Still looking for an answer? Ask a question Search for more help. Comments Follow-Up Questions. Before you can do that To complete this action, sign in to your Community account or create a new one.

Another method is to create a symlink from the location of mysqld. Note: Learn how to create symbolic links with our guide to the Linux ln command. Setting the permission to allows the root user to read, write, and execute the directory, while other users can only read and execute. Note: You can change permissions for files and folders with the chmod command in Linux. Note: Check out our guide to learn how to use the grep command in Linux. After reading this tutorial, you should have identified the cause of the 'Can't connect to local MySQL server through socket ' error and applied the appropriate solution.

Was this article helpful? After, ensure that the database user has the proper permissions over the directory. Setting these to 75 will not be a solution in most cases. Try to access the MySQL prompt again. Rick Taylor. As an example, the most current socket error is something like this: output.