Problema ao Iniciar o Mysql [RESOLVIDO]

1. Problema ao Iniciar o Mysql [RESOLVIDO]

Filipe Henrique
eldemon

(usa Debian)

Enviado em 25/03/2010 - 18:22h

Toda vez que eu tento iniciar o Mysql, ele falha e por causa disso dezena de outros problemas acontece.
# /etc/init.d/mysql start
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!



  


2. Re: Problema ao Iniciar o Mysql [RESOLVIDO]

Filipe Henrique
eldemon

(usa Debian)

Enviado em 25/03/2010 - 21:30h

Mar 25 21:12:38 filipe-home mysqld_safe[15224]: ended
Mar 25 21:12:50 filipe-home /etc/init.d/mysql[15341]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf pin$
Mar 25 21:12:50 filipe-home /etc/init.d/mysql[15341]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Mar 25 21:12:50 filipe-home /etc/init.d/mysql[15341]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s$
Mar 25 21:12:50 filipe-home /etc/init.d/mysql[15341]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exis$
Mar 25 21:12:50 filipe-home /etc/init.d/mysql[15341]:
Mar 25 21:17:01 filipe-home /USR/SBIN/CRON[15376]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
Mar 25 21:24:59 filipe-home mysqld_safe[15565]: started
Mar 25 21:24:59 filipe-home mysqld[15569]: 100325 21:24:59 InnoDB: Started; log sequence number 0 43655
Mar 25 21:24:59 filipe-home mysqld[15569]: 100325 21:24:59 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
Mar 25 21:24:59 filipe-home mysqld[15569]: 100325 21:24:59 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Mar 25 21:24:59 filipe-home mysqld[15569]: 100325 21:24:59 [ERROR] Aborting
Mar 25 21:24:59 filipe-home mysqld[15569]:
Mar 25 21:24:59 filipe-home mysqld[15569]: 100325 21:24:59 InnoDB: Starting shutdown...
Mar 25 21:25:01 filipe-home mysqld[15569]: 100325 21:25:01 InnoDB: Shutdown completed; log sequence number 0 43655
Mar 25 21:25:01 filipe-home mysqld[15569]: 100325 21:25:01 [Note] /usr/sbin/mysqld: Shutdown complete
Mar 25 21:25:01 filipe-home mysqld[15569]:
Mar 25 21:25:01 filipe-home mysqld_safe[15597]: ended




3. Re: Problema ao Iniciar o Mysql [RESOLVIDO]

Filipe Henrique
eldemon

(usa Debian)

Enviado em 25/03/2010 - 21:36h

Resultado do ps aux |grep mysql:

root 5868 0.0 0.1 3864 1252 ? S 15:55 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 5905 0.0 1.2 119316 12628 ? Sl 15:55 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root 5906 0.0 0.0 2976 636 ? S 15:55 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
root 15756 0.0 0.0 3116 780 pts/9 S+ 21:34 0:00 grep mysql



4. Re: Problema ao Iniciar o Mysql [RESOLVIDO]

Filipe Henrique
eldemon

(usa Debian)

Enviado em 25/03/2010 - 21:46h

Resolvido:

kill -9 5868 e kill -9 5905

depois /etc/init.d/mysql start
,beijo e abraço






Patrocínio

Site hospedado pelo provedor RedeHost.
Linux banner

Destaques

Artigos

Dicas

Tópicos

Top 10 do mês

Scripts