I saved a few updates for a while, and finally updated. But now nothing is able to connect to mysql. I created a database using ispconfig and noticed that it did not get created in mysql. Then I started checking around and noticed that MySQL server listening address was set back to default, so I commented it out. but none of my databases connect, not even root but all password check out and webmin still has access.
Trying to connect I get: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 Then: mysql.log Code: 130325 10:21:57 [Note] Plugin 'FEDERATED' is disabled. 130325 10:21:57 InnoDB: The InnoDB memory heap is disabled 130325 10:21:57 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130325 10:21:57 InnoDB: Compressed tables use zlib 1.2.3.4 130325 10:21:57 InnoDB: Initializing buffer pool, size = 128.0M 130325 10:21:57 InnoDB: Completed initialization of buffer pool 130325 10:21:58 InnoDB: highest supported file format is Barracuda. 130325 10:21:58 InnoDB: Waiting for the background threads to start 130325 10:21:59 InnoDB: 1.1.8 started; log sequence number 34782103 130325 10:21:59 InnoDB: Starting shutdown... 130325 10:21:59 InnoDB: Shutdown completed; log sequence number 34782103 130325 10:21:59 [Note] Plugin 'FEDERATED' is disabled. 130325 10:21:59 InnoDB: The InnoDB memory heap is disabled 130325 10:21:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130325 10:21:59 InnoDB: Compressed tables use zlib 1.2.3.4 130325 10:21:59 InnoDB: Initializing buffer pool, size = 128.0M 130325 10:21:59 InnoDB: Completed initialization of buffer pool 130325 10:21:59 InnoDB: highest supported file format is Barracuda. 130325 10:22:00 InnoDB: Waiting for the background threads to start 130325 10:22:01 InnoDB: 1.1.8 started; log sequence number 34782103 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 lin$ 130325 10:22:01 [ERROR] Aborting 130325 10:22:01 InnoDB: Starting shutdown... 130325 10:22:01 InnoDB: Shutdown completed; log sequence number 34782103 130325 10:22:01 [Note] /usr/sbin/mysqld: Shutdown complete 130325 10:22:01 [Note] Plugin 'FEDERATED' is disabled. 130325 10:22:01 InnoDB: The InnoDB memory heap is disabled 130325 10:22:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130325 10:22:01 InnoDB: Compressed tables use zlib 1.2.3.4 130325 10:22:01 InnoDB: Initializing buffer pool, size = 128.0M 130325 10:22:01 InnoDB: Completed initialization of buffer pool 130325 10:22:01 InnoDB: highest supported file format is Barracuda. 130325 10:22:01 InnoDB: Waiting for the background threads to start 130325 10:22:02 InnoDB: 1.1.8 started; log sequence number 34782103 130325 10:22:02 InnoDB: Starting shutdown... 130325 10:22:03 InnoDB: Shutdown completed; log sequence number 34782103 130325 10:22:03 [Note] Plugin 'FEDERATED' is disabled. 130325 10:22:03 InnoDB: The InnoDB memory heap is disabled 130325 10:22:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130325 10:22:03 InnoDB: Compressed tables use zlib 1.2.3.4 130325 10:22:03 InnoDB: Initializing buffer pool, size = 128.0M 130325 10:22:03 InnoDB: Completed initialization of buffer pool 130325 10:22:03 InnoDB: highest supported file format is Barracuda. 130325 10:22:03 InnoDB: Waiting for the background threads to start 130325 10:22:04 InnoDB: 1.1.8 started; log sequence number 34782103 ERROR: 1050 Table 'plugin' already exists 130325 10:22:04 [ERROR] Aborting 130325 10:22:04 InnoDB: Starting shutdown... 130325 10:22:05 InnoDB: Shutdown completed; log sequence number 34782103 130325 10:22:05 [Note] /usr/sbin/mysqld: Shutdown complete 130325 10:22:05 [Note] Plugin 'FEDERATED' is disabled. 130325 10:22:05 InnoDB: The InnoDB memory heap is disabled 130325 10:22:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130325 10:22:05 InnoDB: Compressed tables use zlib 1.2.3.4 130325 10:22:05 InnoDB: Initializing buffer pool, size = 128.0M 130325 10:22:05 InnoDB: Completed initialization of buffer pool 130325 10:22:05 InnoDB: highest supported file format is Barracuda. 130325 10:22:05 InnoDB: Waiting for the background threads to start 130325 10:22:06 InnoDB: 1.1.8 started; log sequence number 34782103 130325 10:22:06 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 130325 10:22:06 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 130325 10:22:06 [Note] Server socket created on IP: '127.0.0.1'. 130325 10:22:06 [Note] Event Scheduler: Loaded 0 events 130325 10:22:06 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-0ubuntu0.12.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 130325 10:37:42 [Note] /usr/sbin/mysqld: Normal shutdown 130325 10:37:42 [Note] Event Scheduler: Purging the queue. 0 events 130325 10:37:42 InnoDB: Starting shutdown... 130325 10:37:43 InnoDB: Shutdown completed; log sequence number 34782103 130325 10:37:43 [Note] /usr/sbin/mysqld: Shutdown complete 130325 10:38:14 [Note] Plugin 'FEDERATED' is disabled. 130325 10:38:14 InnoDB: The InnoDB memory heap is disabled 130325 10:38:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130325 10:38:14 InnoDB: Compressed tables use zlib 1.2.3.4 130325 10:38:14 InnoDB: Initializing buffer pool, size = 128.0M 130325 10:38:14 InnoDB: Completed initialization of buffer pool 130325 10:38:14 InnoDB: highest supported file format is Barracuda. 130325 10:38:15 InnoDB: Waiting for the background threads to start 130325 10:38:16 InnoDB: 1.1.8 started; log sequence number 34782103 130325 10:38:16 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 130325 10:38:16 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 130325 10:38:16 [Note] Server socket created on IP: '127.0.0.1'. 130325 10:38:16 [Note] Event Scheduler: Loaded 0 events 130325 10:38:16 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-0ubuntu0.12.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 130325 10:54:15 [Note] /usr/sbin/mysqld: Normal shutdown 130325 10:54:15 [Note] Event Scheduler: Purging the queue. 0 events 130325 10:54:15 InnoDB: Starting shutdown... 130325 10:54:17 InnoDB: Shutdown completed; log sequence number 34782103 130325 10:54:17 [Note] /usr/sbin/mysqld: Shutdown complete 130325 10:54:19 [Note] Plugin 'FEDERATED' is disabled. 130325 10:54:19 InnoDB: The InnoDB memory heap is disabled 130325 10:54:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130325 10:54:19 InnoDB: Compressed tables use zlib 1.2.3.4 130325 10:54:19 InnoDB: Initializing buffer pool, size = 128.0M 130325 10:54:19 InnoDB: Completed initialization of buffer pool 130325 10:54:19 InnoDB: highest supported file format is Barracuda. 130325 10:54:20 InnoDB: Waiting for the background threads to start 130325 10:54:21 InnoDB: 1.1.8 started; log sequence number 34782103 130325 10:54:21 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 130325 10:54:21 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 130325 10:54:21 [Note] Server socket created on IP: '127.0.0.1'. 130325 10:54:21 [Note] Event Scheduler: Loaded 0 events 130325 10:54:21 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-0ubuntu0.12.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 130325 11:44:50 [Note] /usr/sbin/mysqld: Normal shutdown 130325 11:44:50 [Note] Event Scheduler: Purging the queue. 0 events 130325 11:44:50 InnoDB: Starting shutdown... 130325 11:44:51 InnoDB: Shutdown completed; log sequence number 34782103 130325 11:44:51 [Note] /usr/sbin/mysqld: Shutdown complete 130325 11:45:19 [Note] Plugin 'FEDERATED' is disabled. 130325 11:45:19 InnoDB: The InnoDB memory heap is disabled 130325 11:45:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130325 11:45:19 InnoDB: Compressed tables use zlib 1.2.3.4 130325 11:45:19 InnoDB: Initializing buffer pool, size = 128.0M 130325 11:45:19 InnoDB: Completed initialization of buffer pool 130325 11:45:19 InnoDB: highest supported file format is Barracuda. 130325 11:45:20 InnoDB: Waiting for the background threads to start 130325 11:45:21 InnoDB: 1.1.8 started; log sequence number 34782103 130325 11:45:21 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 130325 11:45:21 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 130325 11:45:21 [Note] Server socket created on IP: '127.0.0.1'. 130325 11:45:21 [Note] Event Scheduler: Loaded 0 events 130325 11:45:21 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-0ubuntu0.12.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 130325 12:07:09 [Note] /usr/sbin/mysqld: Normal shutdown 130325 12:07:09 [Note] Event Scheduler: Purging the queue. 0 events 130325 12:07:11 [Warning] /usr/sbin/mysqld: Forcing close of thread 164 user: 'ispconfig' 130325 12:07:11 InnoDB: Starting shutdown... 130325 12:07:12 InnoDB: Shutdown completed; log sequence number 34782103 130325 12:07:12 [Note] /usr/sbin/mysqld: Shutdown complete 130325 12:07:14 [Note] Plugin 'FEDERATED' is disabled. 130325 12:07:14 InnoDB: The InnoDB memory heap is disabled 130325 12:07:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130325 12:07:14 InnoDB: Compressed tables use zlib 1.2.3.4 130325 12:07:14 InnoDB: Initializing buffer pool, size = 128.0M 130325 12:07:14 InnoDB: Completed initialization of buffer pool 130325 12:07:14 InnoDB: highest supported file format is Barracuda. 130325 12:07:14 InnoDB: Waiting for the background threads to start 130325 12:07:15 InnoDB: 1.1.8 started; log sequence number 34782103 130325 12:07:15 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130325 12:07:15 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130325 12:07:15 [Note] Server socket created on IP: '0.0.0.0'. 130325 12:07:15 [Note] Event Scheduler: Loaded 0 events 130325 12:07:15 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-0ubuntu0.12.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 130325 12:08:55 [Warning] IP address '192.168.10.1' could not be resolved: Name or service not known 130325 12:12:03 [Note] /usr/sbin/mysqld: Normal shutdown 130325 12:12:03 [Note] Event Scheduler: Purging the queue. 0 events 130325 12:12:05 [Warning] /usr/sbin/mysqld: Forcing close of thread 126 user: 'ispconfig' 130325 12:12:05 InnoDB: Starting shutdown... 130325 12:12:06 InnoDB: Shutdown completed; log sequence number 34782103 130325 12:12:06 [Note] /usr/sbin/mysqld: Shutdown complete 130325 12:12:06 [Note] Plugin 'FEDERATED' is disabled. 130325 12:12:06 InnoDB: The InnoDB memory heap is disabled 130325 12:12:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130325 12:12:06 InnoDB: Compressed tables use zlib 1.2.3.4 130325 12:12:06 InnoDB: Initializing buffer pool, size = 128.0M 130325 12:12:06 InnoDB: Completed initialization of buffer pool 130325 12:12:06 InnoDB: highest supported file format is Barracuda. 130325 12:12:07 InnoDB: Waiting for the background threads to start 130325 12:12:08 InnoDB: 1.1.8 started; log sequence number 34782103 130325 12:12:08 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130325 12:12:08 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130325 12:12:08 [Note] Server socket created on IP: '0.0.0.0'. 130325 12:12:08 [Note] Event Scheduler: Loaded 0 events 130325 12:12:08 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-0ubuntu0.12.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 130325 12:16:15 [Warning] IP address '192.168.10.1' could not be resolved: Name or service not known 130325 13:46:34 [Note] /usr/sbin/mysqld: Normal shutdown 130325 13:46:34 [Note] Event Scheduler: Purging the queue. 0 events 130325 13:46:34 InnoDB: Starting shutdown... 130325 13:46:36 InnoDB: Shutdown completed; log sequence number 34782103 130325 13:46:36 [Note] /usr/sbin/mysqld: Shutdown complete 130325 13:46:38 [Note] Plugin 'FEDERATED' is disabled. 130325 13:46:38 InnoDB: The InnoDB memory heap is disabled 130325 13:46:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130325 13:46:38 InnoDB: Compressed tables use zlib 1.2.3.4 130325 13:46:38 InnoDB: Initializing buffer pool, size = 128.0M 130325 13:46:38 InnoDB: Completed initialization of buffer pool 130325 13:46:38 InnoDB: highest supported file format is Barracuda. 130325 13:46:38 InnoDB: Waiting for the background threads to start 130325 13:46:39 InnoDB: 1.1.8 started; log sequence number 34782103 130325 13:46:39 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 130325 13:46:39 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 130325 13:46:39 [Note] Server socket created on IP: '0.0.0.0'. 130325 13:46:39 [Note] Event Scheduler: Loaded 0 events 130325 13:46:39 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.29-0ubuntu0.12.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 130325 14:06:15 [Warning] IP address '192.168.10.1' could not be resolved: Name or service not known 130325 23:03:07 [Warning] IP address '61.160.223.112' could not be resolved: Name or service not known grep: Code: root@db:~# grep mysql /var/log/syslog Mar 25 10:21:57 db mysqld_safe[24045]: Mar 25 10:21:57 db mysqld_safe[24045]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Mar 25 10:21:57 db mysqld_safe[24045]: To do so, start the server, then issue th e following commands: Mar 25 10:21:57 db mysqld_safe[24045]: Mar 25 10:21:57 db mysqld_safe[24045]: /usr/bin/mysqladmin -u root password 'new -password' Mar 25 10:21:57 db mysqld_safe[24045]: /usr/bin/mysqladmin -u root -h db.lampxse rver.com password 'new-password' Mar 25 10:21:57 db mysqld_safe[24045]: Mar 25 10:21:57 db mysqld_safe[24045]: Alternatively you can run: Mar 25 10:21:57 db mysqld_safe[24045]: /usr/bin/mysql_secure_installation Mar 25 10:21:57 db mysqld_safe[24045]: Mar 25 10:21:57 db mysqld_safe[24045]: which will also give you the option of re moving the test Mar 25 10:21:57 db mysqld_safe[24045]: databases and anonymous user created by d efault. This is Mar 25 10:21:57 db mysqld_safe[24045]: strongly recommended for production serve rs. Mar 25 10:21:57 db mysqld_safe[24045]: Mar 25 10:21:57 db mysqld_safe[24045]: See the manual for more instructions. Mar 25 10:21:57 db mysqld_safe[24045]: Mar 25 10:21:57 db mysqld_safe[24045]: Please report any problems with the /usr/ scripts/mysqlbug script! Mar 25 10:21:57 db mysqld_safe[24045]: Mar 25 10:22:07 db /etc/mysql/debian-start[24262]: Upgrading MySQL tables if nec essary. Mar 25 10:22:07 db /etc/mysql/debian-start[24266]: /usr/bin/mysql_upgrade: the ' --basedir' option is always ignored Mar 25 10:22:07 db /etc/mysql/debian-start[24266]: Looking for 'mysql' as: /usr/ bin/mysql Mar 25 10:22:07 db /etc/mysql/debian-start[24266]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Mar 25 10:22:07 db /etc/mysql/debian-start[24266]: This installation of MySQL is already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade Mar 25 10:22:07 db /etc/mysql/debian-start[24277]: Checking for insecure root ac counts. Mar 25 10:22:07 db /etc/mysql/debian-start[24282]: Triggering myisam-recover for all MyISAM tables Mar 25 10:38:17 db /etc/mysql/debian-start[1047]: Upgrading MySQL tables if nece ssary. Mar 25 10:38:17 db /etc/mysql/debian-start[1050]: /usr/bin/mysql_upgrade: the '- -basedir' option is always ignored Mar 25 10:38:17 db /etc/mysql/debian-start[1050]: Looking for 'mysql' as: /usr/b in/mysql Mar 25 10:38:17 db /etc/mysql/debian-start[1050]: Looking for 'mysqlcheck' as: / usr/bin/mysqlcheck Mar 25 10:38:17 db /etc/mysql/debian-start[1050]: This installation of MySQL is already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade Mar 25 10:38:17 db /etc/mysql/debian-start[1061]: Checking for insecure root acc ounts. Mar 25 10:38:17 db /etc/mysql/debian-start[1066]: Triggering myisam-recover for all MyISAM tables Mar 25 10:54:21 db /etc/mysql/debian-start[1860]: Upgrading MySQL tables if nece ssary. Mar 25 10:54:21 db /etc/mysql/debian-start[1863]: /usr/bin/mysql_upgrade: the '- -basedir' option is always ignored Mar 25 10:54:21 db /etc/mysql/debian-start[1863]: Looking for 'mysql' as: /usr/b in/mysql Mar 25 10:54:21 db /etc/mysql/debian-start[1863]: Looking for 'mysqlcheck' as: / usr/bin/mysqlcheck Mar 25 10:54:21 db /etc/mysql/debian-start[1863]: This installation of MySQL is already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade Mar 25 10:54:21 db /etc/mysql/debian-start[1874]: Checking for insecure root acc ounts. Mar 25 10:54:21 db /etc/mysql/debian-start[1879]: Triggering myisam-recover for all MyISAM tables Mar 25 11:45:21 db /etc/mysql/debian-start[1038]: Upgrading MySQL tables if nece ssary. Mar 25 11:45:21 db /etc/mysql/debian-start[1041]: /usr/bin/mysql_upgrade: the '- -basedir' option is always ignored Mar 25 11:45:21 db /etc/mysql/debian-start[1041]: Looking for 'mysql' as: /usr/b in/mysql Mar 25 11:45:21 db /etc/mysql/debian-start[1041]: Looking for 'mysqlcheck' as: / usr/bin/mysqlcheck Mar 25 11:45:21 db /etc/mysql/debian-start[1041]: This installation of MySQL is already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade Mar 25 11:45:21 db /etc/mysql/debian-start[1052]: Checking for insecure root acc ounts. Mar 25 11:45:21 db /etc/mysql/debian-start[1057]: Triggering myisam-recover for all MyISAM tables Mar 25 12:07:16 db /etc/mysql/debian-start[2060]: Upgrading MySQL tables if nece ssary. Mar 25 12:07:16 db /etc/mysql/debian-start[2063]: /usr/bin/mysql_upgrade: the '- -basedir' option is always ignored Mar 25 12:07:16 db /etc/mysql/debian-start[2063]: Looking for 'mysql' as: /usr/b in/mysql Mar 25 12:07:16 db /etc/mysql/debian-start[2063]: Looking for 'mysqlcheck' as: / usr/bin/mysqlcheck Mar 25 12:07:16 db /etc/mysql/debian-start[2063]: This installation of MySQL is already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade Mar 25 12:07:16 db /etc/mysql/debian-start[2074]: Checking for insecure root acc ounts. Mar 25 12:07:16 db /etc/mysql/debian-start[2079]: Triggering myisam-recover for all MyISAM tables Mar 25 12:12:08 db /etc/mysql/debian-start[2662]: Upgrading MySQL tables if nece ssary. Mar 25 12:12:08 db /etc/mysql/debian-start[2665]: /usr/bin/mysql_upgrade: the '- -basedir' option is always ignored Mar 25 12:12:08 db /etc/mysql/debian-start[2665]: Looking for 'mysql' as: /usr/b in/mysql Mar 25 12:12:08 db /etc/mysql/debian-start[2665]: Looking for 'mysqlcheck' as: / usr/bin/mysqlcheck Mar 25 12:12:08 db /etc/mysql/debian-start[2665]: This installation of MySQL is already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade Mar 25 12:12:08 db /etc/mysql/debian-start[2676]: Checking for insecure root acc ounts. Mar 25 12:12:08 db /etc/mysql/debian-start[2681]: Triggering myisam-recover for all MyISAM tables Mar 25 13:46:40 db /etc/mysql/debian-start[6376]: Upgrading MySQL tables if nece ssary. Mar 25 13:46:40 db /etc/mysql/debian-start[6379]: /usr/bin/mysql_upgrade: the '- -basedir' option is always ignored Mar 25 13:46:40 db /etc/mysql/debian-start[6379]: Looking for 'mysql' as: /usr/b in/mysql Mar 25 13:46:40 db /etc/mysql/debian-start[6379]: Looking for 'mysqlcheck' as: / usr/bin/mysqlcheck Mar 25 13:46:40 db /etc/mysql/debian-start[6379]: This installation of MySQL is already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade Mar 25 13:46:40 db /etc/mysql/debian-start[6390]: Checking for insecure root acc ounts. Mar 25 13:46:40 db /etc/mysql/debian-start[6395]: Triggering myisam-recover for all MyISAM tables
After a long while it seems this problem is still around. I keep having to FLUSH each time which seems to be a temp fix. Not sure what happened, there was an update and since then its been like this. Databases are not being created.
