Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
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
Subject
Written By
Posted
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
July 13, 2012 09:30PM
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.