HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=25)
-   -   Ubuntu Updated MySQL Failed to Connect (http://www.howtoforge.com/forums/showthread.php?t=61133)

kendel 25th March 2013 17:42

Ubuntu Updated MySQL Failed to Connect
 
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.

till 25th March 2013 23:15

Any errors in mysql logs?

kendel 26th March 2013 07:06

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


kendel 28th March 2013 06:04

SOLVED. Warning be careful of new Ubuntu updates.

kendel 21st April 2013 19:39

:mad: 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.


All times are GMT +2. The time now is 07:07.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.