Ubuntu Updated MySQL Failed to Connect

Discussion in 'General' started by kendel, Mar 25, 2013.

  1. kendel

    kendel New Member

    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.
     
  2. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    Any errors in mysql logs?
     
  3. kendel

    kendel New Member

    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
    
    
     
    Last edited: Mar 26, 2013
  4. kendel

    kendel New Member

    SOLVED. Warning be careful of new Ubuntu updates.
     
    Last edited: Mar 28, 2013
  5. kendel

    kendel New Member

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

Share This Page