Databases
StackOverflow2013
Postsdbo
POconnect to local MySQL server through socket
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POconnect to local MySQL server through socket
    primarykey
    data
    text
    <blockquote> <p>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)</p> </blockquote> <p>I tried everything I found on internet, but cannot solve the problem on Ubuntu 11.04.</p> <p>I tried these things:</p> <ul> <li>started mysqld manually using <code>sudo /usr/sbin/mysqld start</code></li> <li>started mysqld using <code>service mysqld start</code></li> <li>Checked it is running using <code>ps ax | grep mysqld</code> and got result <code>3419 pts/0 S+ 0:00 grep --color=auto mysqld </code></li> <li>created the file manually at<code>/var/run/mysqld/mysqld.sock</code></li> <li>Gave rights to <code>mysql</code> user</li> <li>Tried to remove and re-install but it still do not work</li> <li>Tried <code>tasksel</code> to configure LAMP, every thing else works but mysql generate same error.</li> </ul> <p>When run with <code>mysqld -P 3305</code> it generates the error</p> <pre><code>110630 0:24:24 [Warning] Can't create test file /var/lib/mysql/nazar-studio.lower-test 110630 0:24:24 [Warning] Can't create test file /var/lib/mysql/nazar-studio.lower-test mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13) 110630 0:24:24 [ERROR] Aborting 110630 0:24:24 [Note] mysqld: Shutdown complete </code></pre> <p>Here is the mysql error log</p> <pre><code>10630 0:07:22 [Note] Plugin 'FEDERATED' is disabled. 110630 0:07:22 InnoDB: Initializing buffer pool, size = 8.0M 110630 0:07:22 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 110630 0:07:22 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 110630 0:07:22 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 110630 0:07:22 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 110630 0:07:23 InnoDB: Started; log sequence number 0 0 110630 0:07:23 InnoDB: Starting shutdown... 110630 0:07:28 InnoDB: Shutdown completed; log sequence number 0 44233 110630 0:07:28 [Note] Plugin 'FEDERATED' is disabled. 110630 0:07:28 InnoDB: Initializing buffer pool, size = 8.0M 110630 0:07:28 InnoDB: Completed initialization of buffer pool 110630 0:07:28 InnoDB: Started; log sequence number 0 44233 ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1 110630 0:07:28 [ERROR] Aborting 110630 0:07:28 InnoDB: Starting shutdown... 110630 0:07:34 InnoDB: Shutdown completed; log sequence number 0 44233 110630 0:07:34 [Note] /usr/sbin/mysqld: Shutdown complete 110630 0:07:34 [Note] Plugin 'FEDERATED' is disabled. 110630 0:07:34 InnoDB: Initializing buffer pool, size = 8.0M 110630 0:07:34 InnoDB: Completed initialization of buffer pool 110630 0:07:34 InnoDB: Started; log sequence number 0 44233 110630 0:07:34 InnoDB: Starting shutdown... 110630 0:07:39 InnoDB: Shutdown completed; log sequence number 0 44233 110630 0:07:39 [Note] Plugin 'FEDERATED' is disabled. 110630 0:07:39 InnoDB: Initializing buffer pool, size = 8.0M 110630 0:07:39 InnoDB: Completed initialization of buffer pool 110630 0:07:39 InnoDB: Started; log sequence number 0 44233 ERROR: 1050 Table 'plugin' already exists 110630 0:07:39 [ERROR] Aborting 110630 0:07:39 InnoDB: Starting shutdown... 110630 0:07:44 InnoDB: Shutdown completed; log sequence number 0 44233 110630 0:07:44 [Note] /usr/sbin/mysqld: Shutdown complete 110630 0:18:30 [Note] Plugin 'FEDERATED' is disabled. 110630 0:18:30 InnoDB: Initializing buffer pool, size = 8.0M 110630 0:18:30 InnoDB: Completed initialization of buffer pool 110630 0:18:30 InnoDB: Started; log sequence number 0 44233 mysqld: Too many arguments (first extra is 'start'). Use --verbose --help to get a list of available options 110630 0:18:30 [ERROR] Aborting 110630 0:18:30 InnoDB: Starting shutdown... 110630 0:18:35 InnoDB: Shutdown completed; log sequence number 0 44233 110630 0:18:35 [Note] mysqld: Shutdown complete </code></pre> <p>How can this error be resolved? </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USOMG Ponies
    1. USNazar Hussain
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POconnect to local MySQL server through socket
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POconnect to local MySQL server through socket
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POconnect to local MySQL server through socket
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSuggest editing your question to include the steps you've attempted, lest we duplicate those failed attempts for you!
      singulars
      1. POconnect to local MySQL server through socket
      1. USp.campbell
    2. COupdated the question
      singulars
      1. POconnect to local MySQL server through socket
      1. USNazar Hussain
    3. CO+1 Thorough question, good detail, and you've actually tried to solve it yourself.
      singulars
      1. POconnect to local MySQL server through socket
      1. USLightness Races in Orbit
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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