MySQL Forums
Forum List  »  Newbie

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Posted by: Peter Lauren
Date: July 13, 2012 09:30PM

Thanks again for your reply. I was able to do everything that you suggested except for

sudo service mysql start

It just hung forever. I was able to do

sudo start mysql

It returned

mysql start/running

ls /var/run/mysqld | grep mysqld.sock

returned nothing.

sudo cat /var/log/mysql/error.log

returned

120713 23:18:20 [Note] Plugin 'FEDERATED' is disabled.
120713 23:18:20 InnoDB: Initializing buffer pool, size = 8.0M
120713 23:18:20 InnoDB: Completed initialization of buffer pool
120713 23:18:20 InnoDB: Started; log sequence number 0 44233
120713 23:18:20 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
120713 23:18:20 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120713 23:18:20 [ERROR] Aborting

120713 23:18:20 InnoDB: Starting shutdown...
120713 23:18:25 InnoDB: Shutdown completed; log sequence number 0 44233
120713 23:18:25 [Note] /usr/sbin/mysqld: Shutdown complete

120713 23:18:50 [Note] Plugin 'FEDERATED' is disabled.
120713 23:18:50 InnoDB: Initializing buffer pool, size = 8.0M
120713 23:18:50 InnoDB: Completed initialization of buffer pool
120713 23:18:50 InnoDB: Started; log sequence number 0 44233
120713 23:18:50 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
120713 23:18:50 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120713 23:18:50 [ERROR] Aborting

120713 23:18:50 InnoDB: Starting shutdown...
120713 23:18:55 InnoDB: Shutdown completed; log sequence number 0 44233
120713 23:18:55 [Note] /usr/sbin/mysqld: Shutdown complete

120713 23:19:20 [Note] Plugin 'FEDERATED' is disabled.
120713 23:19:20 InnoDB: Initializing buffer pool, size = 8.0M
120713 23:19:20 InnoDB: Completed initialization of buffer pool
120713 23:19:20 InnoDB: Started; log sequence number 0 44233
120713 23:19:20 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
120713 23:19:20 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120713 23:19:20 [ERROR] Aborting

120713 23:19:20 InnoDB: Starting shutdown...
120713 23:19:26 InnoDB: Shutdown completed; log sequence number 0 44233
120713 23:19:26 [Note] /usr/sbin/mysqld: Shutdown complete

120713 23:19:50 [Note] Plugin 'FEDERATED' is disabled.
120713 23:19:50 InnoDB: Initializing buffer pool, size = 8.0M
120713 23:19:50 InnoDB: Completed initialization of buffer pool
120713 23:19:50 InnoDB: Started; log sequence number 0 44233
120713 23:19:50 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
120713 23:19:50 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120713 23:19:50 [ERROR] Aborting

120713 23:19:50 InnoDB: Starting shutdown...
120713 23:19:56 InnoDB: Shutdown completed; log sequence number 0 44233
120713 23:19:56 [Note] /usr/sbin/mysqld: Shutdown complete

120713 23:20:20 [Note] Plugin 'FEDERATED' is disabled.
120713 23:20:20 InnoDB: Initializing buffer pool, size = 8.0M
120713 23:20:20 InnoDB: Completed initialization of buffer pool
120713 23:20:20 InnoDB: Started; log sequence number 0 44233
120713 23:20:20 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
120713 23:20:20 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120713 23:20:20 [ERROR] Aborting

120713 23:20:20 InnoDB: Starting shutdown...
120713 23:20:26 InnoDB: Shutdown completed; log sequence number 0 44233
120713 23:20:26 [Note] /usr/sbin/mysqld: Shutdown complete

120713 23:20:50 [Note] Plugin 'FEDERATED' is disabled.
120713 23:20:50 InnoDB: Initializing buffer pool, size = 8.0M
120713 23:20:50 InnoDB: Completed initialization of buffer pool
120713 23:20:51 InnoDB: Started; log sequence number 0 44233
120713 23:20:51 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
120713 23:20:51 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120713 23:20:51 [ERROR] Aborting

120713 23:20:51 InnoDB: Starting shutdown...
120713 23:20:56 InnoDB: Shutdown completed; log sequence number 0 44233
120713 23:20:56 [Note] /usr/sbin/mysqld: Shutdown complete

120713 23:21:20 [Note] Plugin 'FEDERATED' is disabled.
120713 23:21:20 InnoDB: Initializing buffer pool, size = 8.0M
120713 23:21:20 InnoDB: Completed initialization of buffer pool
120713 23:21:21 InnoDB: Started; log sequence number 0 44233
120713 23:21:21 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
120713 23:21:21 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120713 23:21:21 [ERROR] Aborting

120713 23:21:21 InnoDB: Starting shutdown...
120713 23:21:26 InnoDB: Shutdown completed; log sequence number 0 44233
120713 23:21:26 [Note] /usr/sbin/mysqld: Shutdown complete

120713 23:21:51 [Note] Plugin 'FEDERATED' is disabled.
120713 23:21:51 InnoDB: Initializing buffer pool, size = 8.0M
120713 23:21:51 InnoDB: Completed initialization of buffer pool
120713 23:21:51 InnoDB: Started; log sequence number 0 44233
120713 23:21:51 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
120713 23:21:51 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120713 23:21:51 [ERROR] Aborting

120713 23:21:51 InnoDB: Starting shutdown...
120713 23:21:56 InnoDB: Shutdown completed; log sequence number 0 44233
120713 23:21:56 [Note] /usr/sbin/mysqld: Shutdown complete

120713 23:22:21 [Note] Plugin 'FEDERATED' is disabled.
120713 23:22:21 InnoDB: Initializing buffer pool, size = 8.0M
120713 23:22:21 InnoDB: Completed initialization of buffer pool
120713 23:22:21 InnoDB: Started; log sequence number 0 44233
120713 23:22:21 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
120713 23:22:21 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120713 23:22:21 [ERROR] Aborting

120713 23:22:21 InnoDB: Starting shutdown...
120713 23:22:26 InnoDB: Shutdown completed; log sequence number 0 44233
120713 23:22:26 [Note] /usr/sbin/mysqld: Shutdown complete

120713 23:22:51 [Note] Plugin 'FEDERATED' is disabled.
120713 23:22:51 InnoDB: Initializing buffer pool, size = 8.0M
120713 23:22:51 InnoDB: Completed initialization of buffer pool
120713 23:22:51 InnoDB: Started; log sequence number 0 44233
120713 23:22:51 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
120713 23:22:51 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120713 23:22:51 [ERROR] Aborting

120713 23:22:51 InnoDB: Starting shutdown...
120713 23:22:56 InnoDB: Shutdown completed; log sequence number 0 44233
120713 23:22:56 [Note] /usr/sbin/mysqld: Shutdown complete

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.