
Şaka bir yana yine hata çıktı. Aslında hata denemez. Konularda belirttiğim hataları teker teker nasıl olduysa atlatmayı başardım. Ancak MySQL sorunsuz sapasağlam çalışıyor olmasına rağmen bilgisayarımdan veya aynı router'a bağlı olan bilgisayardan giremiyorum sunucuma. Log dosyamı göstereyim önce:
Bu arada belirtmek isterim FreeBSD 9.1 32 Bit Yüklü
130623 10:35:01 mysqld started 130623 10:35:02 InnoDB: Started; log sequence number 0 43655 130623 10:35:02 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95 A mysqld process already exists at Sun Jun 23 10:45:11 EEST 2013 130623 10:45:12 [Note] /usr/local/libexec/mysqld: Normal shutdown 130623 10:45:12 InnoDB: Starting shutdown... 130623 10:45:13 InnoDB: Shutdown completed; log sequence number 0 43655 130623 10:45:13 [Note] /usr/local/libexec/mysqld: Shutdown complete 130623 10:45:13 mysqld ended 130623 10:45:56 mysqld started 130623 10:45:56 InnoDB: Started; log sequence number 0 43655 130623 10:45:56 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95 130623 10:48:02 [Note] /usr/local/libexec/mysqld: Normal shutdown 130623 10:48:02 InnoDB: Starting shutdown... 130623 10:48:03 InnoDB: Shutdown completed; log sequence number 0 43655 130623 10:48:03 [Note] /usr/local/libexec/mysqld: Shutdown complete 130623 10:48:03 mysqld ended 130623 10:56:21 mysqld started /usr/local/libexec/mysqld: Too many arguments (first extra is '.user=mysql'). Use --help to get a list of available options 130623 10:56:21 mysqld ended 130623 10:57:09 mysqld started 130623 10:57:11 InnoDB: Started; log sequence number 0 43655 130623 10:57:12 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95 A mysqld process already exists at Sun Jun 23 10:58:23 EEST 2013 130623 10:58:32 [Note] /usr/local/libexec/mysqld: Normal shutdown 130623 10:58:32 InnoDB: Starting shutdown... 130623 10:58:33 InnoDB: Shutdown completed; log sequence number 0 43655 130623 10:58:33 [Note] /usr/local/libexec/mysqld: Shutdown complete 130623 10:58:33 mysqld ended 130623 10:58:33 mysqld started 130623 10:58:33 InnoDB: Started; log sequence number 0 43655 130623 10:58:33 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95 130623 10:59:14 [Note] /usr/local/libexec/mysqld: Normal shutdown 130623 10:59:14 InnoDB: Starting shutdown... 130623 10:59:14 InnoDB: Shutdown completed; log sequence number 0 43655 130623 10:59:14 [Note] /usr/local/libexec/mysqld: Shutdown complete 130623 10:59:14 mysqld ended 130623 10:59:58 mysqld started 130623 10:59:58 InnoDB: Started; log sequence number 0 43655 130623 10:59:59 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95 130623 11:05:05 [Note] /usr/local/libexec/mysqld: Normal shutdown 130623 11:05:05 InnoDB: Starting shutdown... 130623 11:05:06 InnoDB: Shutdown completed; log sequence number 0 43655 130623 11:05:06 [Note] /usr/local/libexec/mysqld: Shutdown complete 130623 11:05:07 mysqld ended 130623 11:05:07 mysqld started 130623 11:05:07 InnoDB: Started; log sequence number 0 43655 130623 11:05:07 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95 130623 11:14:34 [Note] /usr/local/libexec/mysqld: Normal shutdown 130623 11:14:41 InnoDB: Starting shutdown... 130623 11:14:43 InnoDB: Shutdown completed; log sequence number 0 43655 130623 11:14:43 [Note] /usr/local/libexec/mysqld: Shutdown complete 130623 11:14:43 mysqld ended 130623 11:15:28 mysqld started 130623 11:15:28 InnoDB: Started; log sequence number 0 43655 130623 11:15:29 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95 130623 14:09:57 mysqld ended 130623 14:10:39 mysqld started 130623 14:10:39 InnoDB: Started; log sequence number 0 43655 130623 14:10:39 [Note] Recovering after a crash using mysql-bin 130623 14:10:39 [Note] Starting crash recovery... 130623 14:10:39 [Note] Crash recovery finished. 130623 14:10:39 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95 130623 14:38:07 [Note] /usr/local/libexec/mysqld: Normal shutdown 130623 14:38:07 InnoDB: Starting shutdown... 130623 14:38:08 InnoDB: Shutdown completed; log sequence number 0 43655 130623 14:38:08 [Note] /usr/local/libexec/mysqld: Shutdown complete 130623 14:38:08 mysqld ended 130623 14:38:12 mysqld started 130623 14:38:12 InnoDB: Started; log sequence number 0 43655 130623 14:38:12 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95 130623 14:38:31 [Note] /usr/local/libexec/mysqld: Normal shutdown 130623 14:38:31 InnoDB: Starting shutdown... 130623 14:38:32 InnoDB: Shutdown completed; log sequence number 0 43655 130623 14:38:32 [Note] /usr/local/libexec/mysqld: Shutdown complete 130623 14:38:32 mysqld ended 130623 14:38:32 mysqld started 130623 14:38:32 InnoDB: Started; log sequence number 0 43655 130623 14:38:32 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95 A mysqld process already exists at Sun Jun 23 14:54:31 EEST 2013 130623 14:55:02 [Note] /usr/local/libexec/mysqld: Normal shutdown 130623 14:55:02 InnoDB: Starting shutdown... 130623 14:55:03 InnoDB: Shutdown completed; log sequence number 0 43655 130623 14:55:03 [Note] /usr/local/libexec/mysqld: Shutdown complete 130623 14:55:03 mysqld ended 130623 14:55:45 mysqld started 130623 14:55:45 InnoDB: Started; log sequence number 0 43665 130623 14:55:45 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95 A mysqld process already exists at Sun Jun 23 15:02:21 EEST 2013 130623 15:02:37 [Note] /usr/local/libexec/mysqld: Normal shutdown 130623 15:02:37 InnoDB: Starting shutdown... 130623 15:02:38 InnoDB: Shutdown completed; log sequence number 0 43665 130623 15:02:38 [Note] /usr/local/libexec/mysqld: Shutdown complete 130623 15:02:38 mysqld ended 130623 15:02:39 mysqld started /usr/local/libexec/mysqld: Too many arguments (first extra is '.user=mysql'). Use --help to get a list of available options 130623 15:02:39 mysqld ended 130623 15:02:55 mysqld started 130623 15:02:55 InnoDB: Started; log sequence number 0 43665 130623 15:02:55 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.95-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.95 A mysqld process already exists at Sun Jun 23 15:02:58 EEST 2013Loglar bu şekilde.
Bir de mysql serverin durumuna bakacak olursak:
Uptime: 148 Threads: 1 Questions: 1 Slow queries: 1 Opens: 1 Flush tables: 1 Open tables: 1 Queries per second avg: 0.048