Página 1 de 4 1234 ÚltimoÚltimo
+ Responder ao Tópico



  1. #1
    grilo
    Tou tentando fazer uma conexao remota no mysql.

    no servidor eu digito
    #mysql -u root -p

    dai funciona legal.
    mas qd eu tento restarta o mysql ele da uma flha dai nao consegui acessa-lo remoto.

    net256:~# /etc/init.d/mysql stop
    Starting MySQL database server: mysql...failed.
    net256:~#

    vejam o log

    net256:/var/log# cat mysql.log |more

    mysqld, Version: 3.23.49-log, started with:
    Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    mysqld, Version: 3.23.49-log, started with:
    Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    041221 9:16:54 1 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    2 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:16:56 3 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:16:57 4 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:16:58 5 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:17:00 6 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:17:01 7 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:17:02 8 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:17:03 9 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)


    net256:/var/log/mysql# cat mysql.err
    A mysqld process already exists at Tue Dec 21 08:29:30 BRST 2004
    A mysqld process already exists at Tue Dec 21 08:31:30 BRST 2004
    A mysqld process already exists at Tue Dec 21 08:31:48 BRST 2004
    A mysqld process already exists at Tue Dec 21 08:37:18 BRST 2004
    A mysqld process already exists at Tue Dec 21 08:59:31 BRST 2004
    A mysqld process already exists at Tue Dec 21 09:08:05 BRST 2004
    A mysqld process already exists at Tue Dec 21 09:09:45 BRST 2004
    A mysqld process already exists at Tue Dec 21 09:11:33 BRST 2004
    A mysqld process already exists at Tue Dec 21 09:13:38 BRST 2004
    A mysqld process already exists at Tue Dec 21 09:16:57 BRST 2004
    041221 09:58:44 mysqld ended

    041221 09:59:33 mysqld started
    /usr/sbin/mysqld: ready for connections
    A mysqld process already exists at Tue Dec 21 11:59:28 BRST 2004
    net256:/var/log/mysql#

    alguem pode me ajudar?


    obrigado.

  2. Mate todos os processos que estao rodando o mysql.

    daí tenta "startar" ele, caso ele não "start" manda o log.


    Pedro Henrique



  3. Digita:
    ps aux | grep mysql
    observa o nome do executável do mysql que está em memória
    pode ser mysqld, mysqld-max, etc ...

    e depois dá um killall -9 nome_executavel_mysql

    service mysqld start

  4. #4
    grilo
    meu mysql.err

    Number of processes running now: 0
    041223 15:48:55 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:49:17 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:49:24 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:49:50 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 2
    mysqld process hanging, pid 10231 - killed
    mysqld process hanging, pid 10230 - killed
    041223 15:50:05 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 2
    mysqld process hanging, pid 10264 - killed
    mysqld process hanging, pid 10263 - killed
    041223 15:50:21 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:50:50 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 2
    mysqld process hanging, pid 10318 - killed
    mysqld process hanging, pid 10317 - killed
    041223 15:51:09 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:51:35 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:51:58 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 3
    mysqld process hanging, pid 10388 - killed
    mysqld process hanging, pid 10387 - killed
    mysqld process hanging, pid 10386 - killed
    041223 15:53:23 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:53:53 mysqld restarted
    /usr/sbin/mysqld: ready for connections
    041223 16:09:14 mysqld started
    /usr/sbin/mysqld: ready for connections

    ##############################
    mysql.log

    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    041223 16:09:15 1 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)
    041223 16:09:16 2 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)
    041223 16:09:17 3 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)
    041223 16:09:18 4 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)
    041223 16:09:19 5 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)
    041223 16:09:20 6 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)
    041223 16:10:10 7 Connect root@localhost on
    7 Init DB mural
    7 Query select count(*) from mural ORDER BY id DESC
    7 Query SELECT * FROM mural ORDER BY id DESC limit 0,10
    7 Query SELECT * FROM mural
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Quit


    o erro ainda persiste...
    net256:~# /etc/init.d/mysql start
    Starting MySQL database server: mysql...failed.
    net256:~#



  5. manda a saida do comando ps auxw






Tópicos Similares

  1. Squid - ipcache_init: DNS name lookup tests failed.
    Por no fórum Servidores de Rede
    Respostas: 2
    Último Post: 08-10-2003, 13:16
  2. Directory sread (sector 0x20) failed !?
    Por no fórum Servidores de Rede
    Respostas: 0
    Último Post: 21-08-2003, 08:20
  3. NAGIOS-AUTH FAILED
    Por no fórum Servidores de Rede
    Respostas: 4
    Último Post: 10-04-2003, 11:42
  4. Authorization Failed - Vpopmail
    Por no fórum Servidores de Rede
    Respostas: 0
    Último Post: 24-03-2003, 11:09
  5. Eth0 FAILED..
    Por no fórum Servidores de Rede
    Respostas: 0
    Último Post: 27-01-2003, 09:01

Visite: BR-Linux ·  VivaOLinux ·  Dicas-L