• 23-06-2013, 15:12:00
    #1
    Yakın zamanda bayağı bir konu açtım. Eski MySQL, Eski FreeBSD ne güzeldi tık tık kuruyorduk. Nedense bunda hata yapıyorum ya da hata görüyorum. [Yaşlı Kurt]

    Ş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 2013
    Loglar 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
  • 23-06-2013, 18:00:30
    #2
    aynı hatayı ben 7.2 de de alıyorum oyunun mysql dosyalarını kurunca tmp klasöründeki mysql.sock siliniyor nedense kopyalama vs de olmuyor