StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>From the mysql docs: <a href="http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html" rel="nofollow">C.5.2.2. Can't connect to [local] MySQL server</a></p> <p>The error (2002) Can't connect to ... normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service. </p> <p>Does the "/var/run/mysqld/mysqld.sock" file exist?</p> <p>Is the mysql server running on the same server as the python daemon process?</p> <p>Have you looked at the mysql log?</p> <p>It should be located in <code>/var/log/</code></p> <p>Named something like:<br /> mysql.log<br /> mysql.err<br /> mysqld.log<br /> mysqld.err<br /></p> <pre><code>$ sudo ls -l /var/log/ // when you have the name try $ sudo tail -n 50 /var/log/LogName </code></pre> <p>One possibility is that you're out of disk space, try:</p> <pre><code>$ sudo df -h </code></pre> <p>Look at the 4th column "Avail"</p> <p>Another possibility is the folder permissions, try:</p> <pre><code>$ sudo ls -l /var/lib/ </code></pre> <p>You should see something like this:</p> <pre><code>drwxr-xr-x 33 mysql mysql 4096 May 22 10:02 mysql </code></pre> <p>You most likely want the owner and group to be "mysql", if they aren't, you could try:</p> <pre><code>$ sudo chown -R mysql:mysql /var/lib/mysql </code></pre> <p>Make a note of the original settings first so you can change it back if it doesn't help. The "-R" means change ownership recursively for the sub folders and files.</p> <p>The permissions should be rwxr-xr-x (755), if not you can try:</p> <pre><code>$sudo chmod 755 /var/lib/mysql </code></pre> <p>I wouldn't do that recursively, most of the files and folders should only be accessible to the mysql user, possibly the mysql group and only read/write not executable.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload