|
Problema ao Iniciar o Mysql[RESOLVIDO]
|
|
25/03/2010, 18:36
Resposta: #1
|
|||
|
|||
|
Problema ao Iniciar o Mysql[RESOLVIDO]
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! |
|||
|
25/03/2010, 21:32
Resposta: #2
|
|||
|
|||
|
Re: Problema ao Iniciar o Mysql
Log do Sistema com o erro:
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 |
|||
|
25/03/2010, 21:36
Resposta: #3
|
|||
|
|||
|
Re: Problema ao Iniciar o Mysql
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 |
|||
|
25/03/2010, 21:47
Resposta: #4
|
|||
|
|||
|
Re: Problema ao Iniciar o Mysql
Resolvido:
kill -9 5868 e kill -9 5905 depois /etc/init.d/mysql start |
|||
|
« Anteriores | Seguintes »
|
Usuários visualizando este tópico: 1 Visitantes






