[root@adlkd var]# cat adlkd.err
161009 13:05:50 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                                                 l/mysql/var
161009 13:05:50 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting                                                                                                  as process 30674 ...
161009 13:05:50 [Note] Plugin 'FEDERATED' is disabled.
161009 13:05:50 [Note] Plugin 'InnoDB' is disabled.
161009 13:05:50 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
161009 13:05:50 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
161009 13:05:50 [Note] Server socket created on IP: '0.0.0.0'.
161009 13:05:50 [Note] Event Scheduler: Loaded 0 events
161009 13:05:50 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distributio                                                                                                 n
161009 13:05:51 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown161009 13:05:51 [Note] Event Scheduler: Purging the queue. 0 events
161009 13:05:51 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete161009 13:05:51 mysqld_safe mysqld from pid file /usr/local/mysql/var/150-95-139                                                                                                 -208.pid ended
161009 13:05:52 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                                                 l/mysql/var
161009 13:05:52 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting                                                                                                  as process 31109 ...
161009 13:05:52 [Note] Plugin 'FEDERATED' is disabled.
161009 13:05:52 [Note] Plugin 'InnoDB' is disabled.
161009 13:05:52 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
161009 13:05:52 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
161009 13:05:52 [Note] Server socket created on IP: '0.0.0.0'.
161009 13:05:52 [Note] Event Scheduler: Loaded 0 events
161009 13:05:52 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distributio                                                                                                 n
161009 13:05:53 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown161009 13:05:53 [Note] Event Scheduler: Purging the queue. 0 events
161009 13:05:53 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete161009 13:05:53 mysqld_safe mysqld from pid file /usr/local/mysql/var/150-95-139                                                                                                 -208.pid ended
161009 13:05:54 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                                                 l/mysql/var

解决方案 »

  1.   

    161009 13:05:54 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting                                                                                                  as process 31554 ...
    161009 13:05:54 [Note] Plugin 'FEDERATED' is disabled.
    161009 13:05:54 [Note] Plugin 'InnoDB' is disabled.
    161009 13:05:54 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    161009 13:05:54 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    161009 13:05:54 [Note] Server socket created on IP: '0.0.0.0'.
    161009 13:05:54 [Note] Event Scheduler: Loaded 0 events
    161009 13:05:54 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
    Version: '5.5.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distributio                                                                                                 n
    161009 13:05:55 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown161009 13:05:55 [Note] Event Scheduler: Purging the queue. 0 events
    161009 13:05:55 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete161009 13:05:55 mysqld_safe mysqld from pid file /usr/local/mysql/var/150-95-139                                                                                                 -208.pid ended
    161009 13:13:45 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                                                 l/mysql/var
    161009 13:13:45 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting                                                                                                  as process 14370 ...
    161009 13:13:45 [Note] Plugin 'FEDERATED' is disabled.
    161009 13:13:45 [Note] Plugin 'InnoDB' is disabled.
    161009 13:13:45 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    161009 13:13:45 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    161009 13:13:45 [Note] Server socket created on IP: '0.0.0.0'.
    161009 13:13:45 [Note] Event Scheduler: Loaded 0 events
    161009 13:13:45 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
    Version: '5.5.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distributio                                                                                                 n
    161009 20:10:55 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown161009 20:10:55 [Note] Event Scheduler: Purging the queue. 0 events
    161009 20:10:57 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 5                                                                                                 5  user: 'pan'161009 20:10:57 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete161009 20:10:57 mysqld_safe mysqld from pid file /usr/local/mysql/var/150-95-139                                                                                                 -208.pid ended
    161009 20:10:58 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                                                 l/mysql/var
    161009 20:10:58 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting                                                                                                  as process 31861 ...
    161009 20:10:58 [Note] Plugin 'FEDERATED' is disabled.
    161009 20:10:58 [Note] Plugin 'InnoDB' is disabled.
    161009 20:10:58 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default-c                                                                                                 haracter-set=utf8'
    161009 20:10:58 [ERROR] Aborting161009 20:10:58 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete161009 20:10:58 mysqld_safe mysqld from pid file /usr/local/mysql/var/150-95-139                                                                                                 -208.pid ended
    161009 20:22:00 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                                                 l/mysql/var
    161009 20:22:00 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting                                                                                                  as process 32359 ...
    161009 20:22:00 [Note] Plugin 'FEDERATED' is disabled.
    161009 20:22:00 [Note] Plugin 'InnoDB' is disabled.
    161009 20:22:00 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default-c                                                                                                 haracter-set=utf8'
    161009 20:22:00 [ERROR] Aborting161009 20:22:00 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete161009 20:22:00 mysqld_safe mysqld from pid file /usr/local/mysql/var/150-95-139                                                                                                 -208.pid ended
    161009 20:23:07 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                                                 l/mysql/var
    161009 20:23:07 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting                                                                                                  as process 332 ...
    161009 20:23:07 [Note] Plugin 'FEDERATED' is disabled.
    161009 20:23:07 [Note] Plugin 'InnoDB' is disabled.
    161009 20:23:07 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default_c                                                                                                 haracter_set=utf8'
    161009 20:23:07 [ERROR] Aborting161009 20:23:07 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete161009 20:23:07 mysqld_safe mysqld from pid file /usr/local/mysql/var/150-95-139                                                                                                 -208.pid ended
    161009 20:24:12 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                                                 l/mysql/var
    161009 20:24:12 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting                                                                                                  as process 797 ...
    161009 20:24:12 [Note] Plugin 'FEDERATED' is disabled.
    161009 20:24:12 [Note] Plugin 'InnoDB' is disabled.
    161009 20:24:12 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    161009 20:24:12 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    161009 20:24:12 [Note] Server socket created on IP: '0.0.0.0'.
    161009 20:24:12 [Note] Event Scheduler: Loaded 0 events
    161009 20:24:12 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
    Version: '5.5.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distributio                                                                                                 n
    161009 20:24:25 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown161009 20:24:25 [Note] Event Scheduler: Purging the queue. 0 events
    161009 20:24:25 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete161009 20:24:25 mysqld_safe mysqld from pid file /usr/local/mysql/var/150-95-139                                                                                                 -208.pid ended
    161009 20:24:26 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                                                 l/mysql/var
    161009 20:24:26 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting                                                                                                  as process 1231 ...
    161009 20:24:26 [Note] Plugin 'FEDERATED' is disabled.
    161009 20:24:26 [Note] Plugin 'InnoDB' is disabled.
    161009 20:24:26 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    161009 20:24:26 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    161009 20:24:26 [Note] Server socket created on IP: '0.0.0.0'.
    161009 20:24:26 [Note] Event Scheduler: Loaded 0 events
    161009 20:24:26 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
    Version: '5.5.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distributio                                                                                                 n
    161010  7:10:58 [Warning] IP address '121.199.14.23' could not be resolved: Name                                                                                                  or service not known
    161010  7:31:30 [Warning] IP address '222.186.58.81' could not be resolved: Name                                                                                                  or service not known
    161010  8:57:23 [Warning] IP address '113.108.21.16' could not be resolved: Name                                                                                                  or service not known
      

  2.   

    最简单的办法  你把爬虫插入数据库的sql输出到文件里  然后去看看这个sql是否有问题
      

  3.   

    没有启动成功,反复报错:161009 20:22:00 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                                                 l/mysql/var
    161009 20:22:00 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting                                                                                                  as process 32359 ...
    161009 20:22:00 [Note] Plugin 'FEDERATED' is disabled.
    161009 20:22:00 [Note] Plugin 'InnoDB' is disabled.
    161009 20:22:00 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default-c                                                                                                 haracter-set=utf8'
    161009 20:22:00 [ERROR] Aborting161009 20:22:00 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete161009 20:22:00 mysqld_safe mysqld from pid file /usr/local/mysql/var/150-95-139                                                                                                 -208.pid ended
    161009 20:23:07 mysqld_safe Starting mysqld daemon with databases from /usr/loca                                                                                                 l/mysql/var
    161009 20:23:07 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.5.48-log) starting                                                                                                  as process 332 ...
    161009 20:23:07 [Note] Plugin 'FEDERATED' is disabled.
    161009 20:23:07 [Note] Plugin 'InnoDB' is disabled.
    161009 20:23:07 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'default_c                                                                                                 haracter_set=utf8'
    161009 20:23:07 [ERROR] Aborting
    161009 20:23:07 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete