Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: 100119 22:26:54 [Warning] Forcing shutdown of 2 plugins Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: 100119 22:26:54 [Warning] Forcing shutdown of 2 plugins Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: To do so, start the server, then issue the following commands: Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: /usr/bin/mysqladmin -u root password 'new-password' Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: /usr/bin/mysqladmin -u root -h amit-desktop password 'new-password' Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: Alternatively you can run: Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: /usr/bin/mysql_secure_installation Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: which will also give you the option of removing the test Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: databases and anonymous user created by default. This is Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: strongly recommended for production servers. Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: See the manual for more instructions. Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: Please report any problems with the /usr/scripts/mysqlbug script! Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: The latest information about MySQL is available at http://www.mysql.com/ Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: Support MySQL by buying support/licenses from http://shop.mysql.com/ Jan 19 22:26:54 amit-desktop mysqld_safe[5150]: Jan 19 22:26:54 amit-desktop mysqld_safe[5193]: 100119 22:26:54 [Note] Plugin 'FEDERATED' is disabled. Jan 19 22:26:54 amit-desktop mysqld_safe[5193]: InnoDB: The first specified data file ./ibdata1 did not exist: Jan 19 22:26:54 amit-desktop mysqld_safe[5193]: InnoDB: a new database to be created! Jan 19 22:26:54 amit-desktop mysqld_safe[5193]: 100119 22:26:54 InnoDB: Setting file ./ibdata1 size to 10 MB Jan 19 22:26:54 amit-desktop mysqld_safe[5193]: InnoDB: Database physically writes the file full: wait... Jan 19 22:26:55 amit-desktop mysqld_safe[5193]: 100119 22:26:55 InnoDB: Log file ./ib_logfile0 did not exist: new to be created Jan 19 22:26:55 amit-desktop mysqld_safe[5193]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB Jan 19 22:26:55 amit-desktop mysqld_safe[5193]: InnoDB: Database physically writes the file full: wait... Jan 19 22:26:55 amit-desktop mysqld_safe[5193]: 100119 22:26:55 InnoDB: Log file ./ib_logfile1 did not exist: new to be created Jan 19 22:26:55 amit-desktop mysqld_safe[5193]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB Jan 19 22:26:55 amit-desktop mysqld_safe[5193]: InnoDB: Database physically writes the file full: wait... Jan 19 22:26:55 amit-desktop mysqld_safe[5193]: InnoDB: Doublewrite buffer not found: creating new Jan 19 22:26:56 amit-desktop mysqld_safe[5193]: InnoDB: Doublewrite buffer created Jan 19 22:26:56 amit-desktop mysqld_safe[5193]: InnoDB: Creating foreign key constraint system tables Jan 19 22:26:56 amit-desktop mysqld_safe[5193]: InnoDB: Foreign key constraint system tables created Jan 19 22:26:56 amit-desktop mysqld_safe[5193]: 100119 22:26:56 InnoDB: Started; log sequence number 0 0 Jan 19 22:26:56 amit-desktop mysqld_safe[5193]: 100119 22:26:56 InnoDB: Starting shutdown... Jan 19 22:26:57 amit-desktop mysqld_safe[5193]: 100119 22:26:57 InnoDB: Shutdown completed; log sequence number 0 44233 Jan 19 22:26:57 amit-desktop mysqld_safe[5193]: 100119 22:26:57 [Warning] Forcing shutdown of 1 plugins Jan 19 22:26:59 amit-desktop mysqld_safe[5223]: 100119 22:26:59 [Note] Plugin 'FEDERATED' is disabled. Jan 19 22:26:59 amit-desktop mysqld_safe[5223]: 100119 22:26:59 InnoDB: Started; log sequence number 0 44233 Jan 19 22:26:59 amit-desktop mysqld_safe[5223]: 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 line 1 Jan 19 22:26:59 amit-desktop mysqld_safe[5223]: 100119 22:26:59 [ERROR] Aborting Jan 19 22:26:59 amit-desktop mysqld_safe[5223]: Jan 19 22:26:59 amit-desktop mysqld_safe[5223]: 100119 22:26:59 InnoDB: Starting shutdown... Jan 19 22:27:00 amit-desktop mysqld_safe[5223]: 100119 22:27:00 InnoDB: Shutdown completed; log sequence number 0 44233 Jan 19 22:27:00 amit-desktop mysqld_safe[5223]: 100119 22:27:00 [Warning] Forcing shutdown of 1 plugins Jan 19 22:27:00 amit-desktop mysqld_safe[5223]: 100119 22:27:00 [Note] /usr/sbin/mysqld: Shutdown complete Jan 19 22:27:00 amit-desktop mysqld_safe[5223]: Jan 19 22:27:00 amit-desktop mysqld_safe[5236]: 100119 22:27:00 [Note] Plugin 'FEDERATED' is disabled. Jan 19 22:27:00 amit-desktop mysqld_safe[5236]: 100119 22:27:00 InnoDB: Started; log sequence number 0 44233 Jan 19 22:27:00 amit-desktop mysqld_safe[5236]: 100119 22:27:00 InnoDB: Starting shutdown... Jan 19 22:27:02 amit-desktop mysqld_safe[5236]: 100119 22:27:02 InnoDB: Shutdown completed; log sequence number 0 44233 Jan 19 22:27:02 amit-desktop mysqld_safe[5236]: 100119 22:27:02 [Warning] Forcing shutdown of 1 plugins Jan 19 22:27:02 amit-desktop mysqld_safe[5250]: 100119 22:27:02 [Note] Plugin 'FEDERATED' is disabled. Jan 19 22:27:02 amit-desktop mysqld_safe[5250]: 100119 22:27:02 InnoDB: Started; log sequence number 0 44233 Jan 19 22:27:02 amit-desktop mysqld_safe[5250]: ERROR: 1050 Table 'plugin' already exists Jan 19 22:27:02 amit-desktop mysqld_safe[5250]: 100119 22:27:02 [ERROR] Aborting Jan 19 22:27:02 amit-desktop mysqld_safe[5250]: Jan 19 22:27:02 amit-desktop mysqld_safe[5250]: 100119 22:27:02 InnoDB: Starting shutdown... Jan 19 22:27:03 amit-desktop mysqld_safe[5250]: 100119 22:27:03 InnoDB: Shutdown completed; log sequence number 0 44233 Jan 19 22:27:03 amit-desktop mysqld_safe[5250]: 100119 22:27:03 [Warning] Forcing shutdown of 1 plugins Jan 19 22:27:03 amit-desktop mysqld_safe[5250]: 100119 22:27:03 [Note] /usr/sbin/mysqld: Shutdown complete Jan 19 22:27:03 amit-desktop mysqld_safe[5250]: Jan 19 22:27:04 amit-desktop mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Jan 19 22:27:04 amit-desktop mysqld: 100119 22:27:04 [Note] Plugin 'FEDERATED' is disabled. Jan 19 22:27:04 amit-desktop mysqld: 100119 22:27:04 InnoDB: Started; log sequence number 0 44233 Jan 19 22:27:04 amit-desktop mysqld: 100119 22:27:04 [Note] Event Scheduler: Loaded 0 events Jan 19 22:27:04 amit-desktop mysqld: 100119 22:27:04 [Note] /usr/sbin/mysqld: ready for connections. Jan 19 22:27:04 amit-desktop mysqld: Version: '5.1.37-1ubuntu5' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: Status information: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: Current dir: /var/lib/mysql/ Jan 19 22:27:05 amit-desktop mysqld: Running threads: 1 Stack size: 196608 Jan 19 22:27:05 amit-desktop mysqld: Current locks: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd61446198: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd61443d68: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd61441618: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd6143f238: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd6143d2a8: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd6143c1b0: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd6142ee18: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd61428838: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd61426138: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd61422188: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd6141e908: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd6141bcc8: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd61418848: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd61408690: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd613d2bd8: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd613fc1b8: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd613f15e8: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd613e6a38: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd613ddae8: write Jan 19 22:27:05 amit-desktop mysqld: write : 0x7ffd613de358 (6:7); Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd613c4148: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: lock: 0x7ffd613b65c8: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: Key caches: Jan 19 22:27:05 amit-desktop mysqld: default Jan 19 22:27:05 amit-desktop mysqld: Buffer_size: 16777216 Jan 19 22:27:05 amit-desktop mysqld: Block_size: 1024 Jan 19 22:27:05 amit-desktop mysqld: Division_limit: 100 Jan 19 22:27:05 amit-desktop mysqld: Age_limit: 300 Jan 19 22:27:05 amit-desktop mysqld: blocks used: 1 Jan 19 22:27:05 amit-desktop mysqld: not flushed: 0 Jan 19 22:27:05 amit-desktop mysqld: w_requests: 4 Jan 19 22:27:05 amit-desktop mysqld: writes: 1 Jan 19 22:27:05 amit-desktop mysqld: r_requests: 3 Jan 19 22:27:05 amit-desktop mysqld: reads: 0 Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: handler status: Jan 19 22:27:05 amit-desktop mysqld: read_key: 0 Jan 19 22:27:05 amit-desktop mysqld: read_next: 0 Jan 19 22:27:05 amit-desktop mysqld: read_rnd 0 Jan 19 22:27:05 amit-desktop mysqld: read_first: 3 Jan 19 22:27:05 amit-desktop mysqld: write: 55 Jan 19 22:27:05 amit-desktop mysqld: delete 0 Jan 19 22:27:05 amit-desktop mysqld: update: 0 Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: Table status: Jan 19 22:27:05 amit-desktop mysqld: Opened tables: 37 Jan 19 22:27:05 amit-desktop mysqld: Open tables: 21 Jan 19 22:27:05 amit-desktop mysqld: Open files: 43 Jan 19 22:27:05 amit-desktop mysqld: Open streams: 0 Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: Alarm status: Jan 19 22:27:05 amit-desktop mysqld: Active alarms: 0 Jan 19 22:27:05 amit-desktop mysqld: Max used alarms: 2 Jan 19 22:27:05 amit-desktop mysqld: Next alarm time: 0 Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: Thread database.table_name Locked/Waiting Lock_type Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: 6 mysql.columns_priv Locked - write Write lock, but allow reading Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: last message repeated 3 times Jan 19 22:27:05 amit-desktop mysqld: Begin safemalloc memory dump: Jan 19 22:27:05 amit-desktop mysqld: Jan 19 22:27:05 amit-desktop mysqld: End safemalloc memory dump.