mysqld...failed

[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.

[pmuniz]

Mate todos os processos que estao rodando o mysql.

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


Pedro Henrique

[fred_m]

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

[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:~#

[fred_m]

manda a saida do comando ps auxw

[grilo]

manda a saida do comando ps auxw

ps auxw

USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.1 1272 436 ? S Dec21 0:06 init [2]
root 2 0.0 0.0 0 0 ? SW Dec21 0:00 [keventd]
root 3 0.0 0.0 0 0 ? SWN Dec21 0:00 [ksoftirqd_CPU0]
root 4 0.0 0.0 0 0 ? SW Dec21 0:02 [kswapd]
root 5 0.0 0.0 0 0 ? SW Dec21 0:00 [bdflush]
root 6 0.0 0.0 0 0 ? SW Dec21 0:00 [kupdated]
root 7 0.0 0.0 0 0 ? SW Dec21 0:00 [i2oevtd]
root 43 0.0 0.0 0 0 ? SW Dec21 0:00 [khubd]
root 102 0.0 0.0 0 0 ? SW Dec21 0:00 [eth0]
daemon 107 0.0 0.2 1384 524 ? S Dec21 0:00 /sbin/portmap
root 262 0.0 0.3 2036 776 ? S Dec21 0:00 /sbin/syslogd
root 265 0.0 0.4 2060 1224 ? S Dec21 0:00 /sbin/klogd
root 272 0.0 0.3 2008 880 ? S Dec21 0:00 /usr/sbin/pppd call dsl-provider
root 274 0.0 0.1 1272 468 ? S Dec21 1:04 /usr/sbin/pppoe -I eth1 -T 80 -m 1452
root 278 0.0 0.2 1444 692 ? S Dec21 0:00 /sbin/rpc.statd
root 284 0.0 0.0 0 0 ? SW Dec21 0:00 [kapmd]
root 286 0.0 0.1 1268 480 ? S Dec21 0:00 /usr/sbin/apmd -P /etc/apm/apmd_proxy
root 310 0.0 0.2 2228 716 ? S Dec21 0:00 /usr/sbin/couriertcpd -address=0 -stderrlogger=/usr/sbin/courierlogger -maxprocs=40 -maxperip=4 -pid=/var/run/courier/imapd.pid -nodnslookup -noidentlookup 143 /usr/lib/courier/courier/imaplogin /usr/lib/courier/authlib/authdaemon /usr/bin/imapd Maildir
root 314 0.0 0.1 1424 320 ? S Dec21 0:00 /usr/sbin/courierlogger imaplogin
root 318 0.0 0.2 2228 720 ? S Dec21 0:00 /usr/sbin/couriertcpd -pid=/var/run/courier/pop3d.pid -stderrlogger=/usr/sbin/courierlogger -maxprocs=40 -maxperip=4 -nodnslookup -noidentlookup -address=0 110 /usr/lib/courier/courier/courierpop3login /usr/lib/courier/authlib/authdaemon /usr/lib/courier/courier/courierpop3d Maildir
root 321 0.0 0.1 1432 444 ? S Dec21 0:00 /usr/sbin/courierlogger courierpop3login
root 329 0.0 0.2 1728 660 ? S< Dec21 0:00 /usr/sbin/diald -f /var/cache/diald/options.dsl-provider
root 349 0.0 0.2 1988 696 ? S Dec21 0:00 /usr/sbin/inetd
news 381 0.0 0.3 2176 896 ? S Dec21 0:00 /bin/sh /usr/lib/news/bin/rc.news
root 392 0.0 0.2 2044 740 ? S Dec21 0:00 /usr/sbin/lpd
root 605 0.0 0.2 2484 576 ? S Dec21 0:00 /usr/lib/postfix/master
postfix 610 0.0 0.3 2488 976 ? S Dec21 0:00 qmgr -l -t fifo -u -c
root 611 0.0 0.2 2700 736 ? S Dec21 0:01 /usr/sbin/nmbd -D
root 613 0.0 0.3 3584 796 ? S Dec21 0:00 /usr/sbin/smbd -D
root 619 0.0 0.2 2784 540 ? S Dec21 0:00 /usr/sbin/sshd
www-data 629 3.8 1.8 33300 4700 ? S Dec21 127:37 /usr/lib/jdk1.1/bin/i686/green_threads/java -Djava.security.policy=/usr/share/tomcat/conf/tomcat.policy -Dtomcat.home=/usr/share/tomcat org/apache/tomcat/startup/Main start
root 638 0.0 0.1 4236 488 ? S Dec21 0:00 /usr/bin/X11/xfs -daemon
website 773 0.0 0.3 3620 1004 ? S Dec21 0:00 proftpd (accepting connections)
daemon 784 0.0 0.2 1384 516 ? S Dec21 0:00 /usr/sbin/atd
root 787 0.0 0.2 1652 608 ? S Dec21 0:00 /usr/sbin/cron
root 791 0.0 0.5 136752 1332 ? S Dec21 0:00 /usr/sbin/apache
root 817 0.0 0.1 1252 400 tty1 S Dec21 0:00 /sbin/getty 38400 tty1
root 818 0.0 0.1 1252 400 tty2 S Dec21 0:00 /sbin/getty 38400 tty2
root 819 0.0 0.1 1252 400 tty3 S Dec21 0:00 /sbin/getty 38400 tty3
root 820 0.0 0.1 1252 400 tty4 S Dec21 0:00 /sbin/getty 38400 tty4
root 821 0.0 0.1 1252 400 tty5 S Dec21 0:00 /sbin/getty 38400 tty5
root 824 0.0 0.1 1252 400 tty6 S Dec21 0:00 /sbin/getty 38400 tty6
news 841 0.0 0.4 2200 1116 ? S Dec21 0:00 /bin/sh /usr/lib/news/bin/innwatch
nobody 985 0.0 0.1 1560 456 ? S Dec21 0:00 noip2-Linux -c /root/noip/noip.conf
root 9168 0.0 0.6 4072 1732 ? S 09:11 0:01 /usr/sbin/smbd -D
root 9478 0.0 0.7 4004 1832 ? S 13:29 0:00 /usr/sbin/smbd -D
www-data 9846 0.0 1.7 138428 4428 ? S 14:52 0:00 /usr/sbin/apache
www-data 9850 0.0 1.7 138488 4492 ? S 14:52 0:00 /usr/sbin/apache
www-data 9856 0.0 1.7 138456 4460 ? S 14:55 0:00 /usr/sbin/apache
root 9919 0.0 0.4 3876 1168 ? S 15:16 0:00 /usr/sbin/squid -D -sYC
proxy 9922 0.0 3.3 14984 8556 ? S 15:16 0:05 (squid) -D -sYC
proxy 9923 0.0 0.2 1872 760 ? S 15:16 0:00 (ncsa_auth) /etc/squid/passwd
proxy 9924 0.0 0.1 1800 468 ? S 15:16 0:00 (ncsa_auth) /etc/squid/passwd
proxy 9925 0.0 0.1 1800 468 ? S 15:16 0:00 (ncsa_auth) /etc/squid/passwd
proxy 9926 0.0 0.1 1800 468 ? S 15:16 0:00 (ncsa_auth) /etc/squid/passwd
proxy 9927 0.0 0.1 1800 468 ? S 15:16 0:00 (ncsa_auth) /etc/squid/passwd
proxy 10038 0.0 0.1 1244 304 ? S 15:16 0:00 (unlinkd)
www-data 10039 0.0 1.7 138476 4548 ? S 15:16 0:00 /usr/sbin/apache
www-data 10040 0.0 1.7 138504 4552 ? S 15:16 0:00 /usr/sbin/apache
www-data 10041 0.0 1.6 138444 4308 ? S 15:16 0:00 /usr/sbin/apache
root 10493 0.0 0.7 6416 1800 ? S 15:56 0:00 /usr/sbin/sshd
root 10495 0.0 0.4 2228 1272 pts/3 S 15:56 0:00 -bash
postfix 10499 0.0 0.3 2436 1000 ? S 15:58 0:00 pickup -l -t fifo -u -c
root 10524 0.0 0.3 2052 968 pts/3 S 16:09 0:00 /bin/sh /usr/bin/safe_mysqld
mysql 10562 0.0 1.9 36520 4856 pts/3 S 16:09 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
mysql 10564 0.0 1.9 36520 4856 pts/3 S 16:09 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
mysql 10565 0.0 1.9 36520 4856 pts/3 S 16:09 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
mysql 10566 0.0 1.9 36520 4856 pts/3 S 16:09 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
www-data 10640 0.0 1.6 138428 4268 ? S 16:46 0:00 /usr/sbin/apache
www-data 10646 0.0 1.6 138412 4284 ? S 16:55 0:00 /usr/sbin/apache
news 10659 0.0 0.1 1528 508 ? S 17:00 0:00 sleep 600
root 10669 0.0 0.6 3564 1596 pts/3 R 17:08 0:00 ps auxw

[fred_m]

tente :

killall -9 /usr/bin/safe_mysqld
ou
killall -9 safe_mysqld

killall -9 /usr/sbin/mysqld
ou
killall -9 mysqld

Faça isso e depois envie a saida do comando novamente.

[grilo]

tente :

killall -9 /usr/bin/safe_mysqld
ou
killall -9 safe_mysqld

killall -9 /usr/sbin/mysqld
ou
killall -9 mysqld

Faça isso e depois envie a saida do comando novamente.

killall -9 /usr/bin/safe_mysqld
saida
net256:~# killall -9 /usr/bin/safe_mysqld
/usr/bin/safe_mysqld: no process killed
net256:~#


killall -9 safe_mysqld
saida:
net256:~# killall -9 safe_mysqld
net256:~#


killall -9 /usr/sbin/mysqld
saida
net256:~# killall -9 /usr/sbin/mysqld
/usr/sbin/mysqld: no process killed
net256:~#



killall -9 mysqld
saida
net256:~# killall -9 mysqld
net256:~#


Tentei restarta ele de novo e deu falha
net256:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld...failed.
net256:~#

[fred_m]

Você já tentou reinicar o servidor ???

[grilo]

Você já tentou reinicar o servidor ???

ja reiniciei e ainda continua a falha.


tem q fazer alguma coniguraçao pra isto funcionar? qual?

[fred_m]

Faz o seguinte, vamos ao extremo. Faz um bckup de tuas bases, remove o mysql e depois reinstala ele.

[grilo]

Faz o seguinte, vamos ao extremo. Faz um bckup de tuas bases, remove o mysql e depois reinstala ele.

desistalei o mysql-server pelo apt-get
#apt-get remove mysql-server

depois instalei ele de novo pelo apte-get

#apt-get install mysql-server
#mysqladmin -u root -p 'newpassword'

eu entro nele e trabalho tranquilo, mas se eu tentar restarta ele o erro persiste, eu tenho q instalar algo mais? so instalei o mysql-server pelo apt-get e nao configurei mais nada..

uso debian 3, e tou querendo conectar remoto nele..

[fred_m]

instala o mysql-client.

Qual a versão do mysql que você está instalando ???

[grilo]

instala o mysql-client.

Qual a versão do mysql que você está instalando ???

prontinho ja ta instalado o client mas o erro persiste

[fred_m]

A saida do arquivio mysqld.log é a mesma informado acima??

Qual a versão do mysql ???

você pode tentar usar uma versão anterior.

[grilo]

kra beleza, ja deu tudo certo, uso o MySQL 3.23.49-log

depois q reinstalei dai funcionou..


obrigado