I have Mysql server on my pc and mini 2440 devices. Devices is disconnect to server. Ihave error to Unable to connect to any of the specified MySQL hosts. Another computer can connect to my computer but devices project is have a error... How do I this problem solve? please help me!!!
I have mysqlserver-5.1 on installed debian squeeze in tiny-210 not connected to remote access. I have see the syslog following error Aug 6 13:00:07 localhost mysqld: 120806 13:00:07 [Note] /usr/sbin/mysqld: Normal shutdown Aug 6 13:00:07 localhost mysqld: Aug 6 13:00:07 localhost mysqld: 120806 13:00:07 [Note] Event Scheduler: Purging the queue. 0 events Aug 6 13:00:07 localhost mysqld: 120806 13:00:07 InnoDB: Starting shutdown... Aug 6 13:00:12 localhost mysqld: 120806 13:00:12 InnoDB: Shutdown completed; log sequence number 0 2450348 Aug 6 13:00:12 localhost mysqld: 120806 13:00:12 [Note] /usr/sbin/mysqld: Shutdown complete Aug 6 13:00:12 localhost mysqld: Aug 6 13:00:12 localhost mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Aug 6 13:06:45 localhost mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Aug 6 13:06:45 localhost mysqld: 120806 13:06:45 [Note] Plugin 'FEDERATED' is disabled. Aug 6 13:06:45 localhost mysqld: 120806 13:06:45 InnoDB: Initializing buffer pool, size = 8.0M Aug 6 13:06:45 localhost mysqld: 120806 13:06:45 InnoDB: Completed initialization of buffer pool Aug 6 13:06:45 localhost mysqld: 120806 13:06:45 InnoDB: Started; log sequence number 0 2450348 Aug 6 13:06:45 localhost mysqld: 120806 13:06:45 [ERROR] Can't create IP socket: Permission denied Aug 6 13:06:45 localhost mysqld: 120806 13:06:45 [ERROR] Aborting Aug 6 13:06:45 localhost mysqld: Aug 6 13:06:45 localhost mysqld: 120806 13:06:45 InnoDB: Starting shutdown... Aug 6 13:06:51 localhost mysqld: 120806 13:06:51 InnoDB: Shutdown completed; log sequence number 0 2450348 Aug 6 13:06:51 localhost mysqld: 120806 13:06:51 [Note] /usr/sbin/mysqld: Shutdown complete Aug 6 13:06:51 localhost mysqld: Aug 6 13:06:51 localhost mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Aug 6 13:07:00 localhost /etc/init.d/mysql[7483]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Aug 6 13:07:00 localhost /etc/init.d/mysql[7483]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Aug 6 13:07:00 localhost /etc/init.d/mysql[7483]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Aug 6 13:07:00 localhost /etc/init.d/mysql[7483]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Aug 6 13:07:00 localhost /etc/init.d/mysql[7483]: I have search on google http://linux.bigresource.com/Ubuntu-Android-and-Chrooted-mysqld-can-039-... i dont understand pls help me
Hi Jenifer, This is either a firewall issue or a grant permission issue (from MySQL server). For the firewall side (assuming windows), open up windows firewall and add an exception for all ports. The other one is grant permission, which you can read here: http://dev.mysql.com/doc/refman/5.1/en/grant.html I've ran into the same problem before, and it was due to both of these issues. Hope it helps.
How to solve - mysql Restarting Problem Mysql Problem Ubuntu 10.04 - in /var/log/messages kernel: [431675.645208] type=1505 audit(1347364113.772:30): operation="profile_replace" pid=14835 name="/usr/sbin/mysqld" in /var/log/mysql/error.log 120911 17:18:27 [Note] /usr/sbin/mysqld: Normal shutdown 120911 17:18:27 [Note] Event Scheduler: Purging the queue. 0 events 120911 17:18:29 InnoDB: Starting shutdown... 120911 17:18:33 InnoDB: Shutdown completed; log sequence number 0 3645953335 120911 17:18:33 [Note] /usr/sbin/mysqld: Shutdown complete 120911 17:18:33 [Note] Plugin 'FEDERATED' is disabled. 120911 17:18:33 InnoDB: Initializing buffer pool, size = 8.0M 120911 17:18:33 InnoDB: Completed initialization of buffer pool 120911 17:18:33 InnoDB: Started; log sequence number 0 3645953335 120911 17:18:33 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=ikmsvr024-relay-bin' to avoid this problem. 120911 17:18:33 [Note] Event Scheduler: Loaded 0 events 120911 17:18:33 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.63-0ubuntu0.10.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)