Where is mysql.sock

This file is created by the MySQL service automatically. Sometimes, changes to your system or your MySQL configuration can result in MySQL being unable to read the socket file, preventing you from gaining access to your databases.

The most common socket error looks like this:. One common cause of this error is that the MySQL service is stopped or did not start to begin with, meaning that it was unable to create the socket file in the first place. Then try accessing the MySQL prompt again. If you still receive the socket error, double check the location where your MySQL installation is looking for the socket file.

This information can be found in the mysqld. Look for the socket parameter in the [mysqld] section of this file. You can specify your drivers for the data source if you do not want to download the provided drivers.

For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

On the Advanced tab, find the serverTimezone parameter in the list of options. Double-click the Value cell and type your server timezone for example, UTC. From the Driver list, select the driver that you created earlier see Step 4. In User and Password fields, specify your user credentials. While you can re-install solutions I have used in the past include: Touch the socket file and make sure it is owned by the mysql group and user. Make sure you are using sudo etc. Improve this answer.

Voltaire Voltaire 1 1 silver badge 3 3 bronze badges. I reinstalled the whole mysql now and I can see mysql. It wasn't there before. So for it has happened twice and I only restore the database by reinstalling mysql altogether. I realise it will be unlikely that you can provide more information after re-installing however. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? The Overflow Blog. Does ES6 make JavaScript frameworks obsolete?

Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile. Related 0. Hot Network Questions. Question feed. Ask Ubuntu works best with JavaScript enabled.