View previous topic :: View next topic |
Author |
Message |
geforce l33t
Joined: 29 Dec 2003 Posts: 653 Location: Canada
|
Posted: Fri Apr 22, 2005 7:06 pm Post subject: (MySql) (): Can't connect to l (RESOLU) |
|
|
Bonjour.
J'ai présentemetn l'erreur suivante:
Quote: |
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /pub/www/hosts/collegedechampigny.com/default/include/mysql.php on line 7
Unable to connect to SQL server |
Voici ce uqe j'ai fait pour essayer de debugger mon Mysql:
/etc/init.d/mysql stop:
Code: |
* Stopping mysqld... [ !! ]
|
Ensuite :
/etc/init.d/mysql zap
et pour continuer: /etc/init.d/mysql start
..
J'ai cependant la meme erreur
Mon mysql.err:
Quote: |
tail -f /var/log/mysql/mysql.err
050422 15:06:08 mysqld started
050422 15:06:08 Can't start server: Bind on TCP/IP port: Address already in use
050422 15:06:08 Do you already have another mysqld server running on port: 3306 ?
050422 15:06:08 Aborting
050422 15:06:08 /usr/sbin/mysqld: Shutdown Complete
050422 15:06:08 mysqld ended
|
J'ai vite besoin de remettre ce serveur sur pied car ces le main serveur de la cie....
Merci
Phil
GeForce _________________ User #29433
Last edited by geforce on Fri Apr 22, 2005 7:14 pm; edited 1 time in total |
|
Back to top |
|
|
Oupsman Veteran
Joined: 19 Jul 2004 Posts: 1042
|
Posted: Fri Apr 22, 2005 7:10 pm Post subject: Re: (MySql) (): Can't connect to l |
|
|
geforce wrote: |
Quote: |
tail -f /var/log/mysql/mysql.err
050422 15:06:08 mysqld started
050422 15:06:08 Can't start server: Bind on TCP/IP port: Address already in use
050422 15:06:08 Do you already have another mysqld server running on port: 3306 ?
050422 15:06:08 Aborting
050422 15:06:08 /usr/sbin/mysqld: Shutdown Complete
050422 15:06:08 mysqld ended
|
|
Cette erreur là indique qu'il y'a déjà un processus démarré qui occupe le port de MySQL. Un netstat -anp |grep 3306 devrait te permettre de l'identifier. _________________ --
L'idéal de nouveauté semble avoir remplacé l'idéal de progrès. C'est bien triste.
----
Unix philosophy: "Do one thing and do it well."
systemd: "Try to do everything and do it wrong." |
|
Back to top |
|
|
CourJuS Tux's lil' helper
Joined: 26 Jun 2004 Posts: 99 Location: Belgique
|
Posted: Fri Apr 22, 2005 7:10 pm Post subject: |
|
|
2 ptite idées
que donne un ps ax ??
et unReboot du server si sa pose pas trop de problem sa donne quoi ? |
|
Back to top |
|
|
geforce l33t
Joined: 29 Dec 2003 Posts: 653 Location: Canada
|
Posted: Fri Apr 22, 2005 7:11 pm Post subject: |
|
|
Quote: | netstat -anp |grep 3306
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 9470/mysqld |
_________________ User #29433 |
|
Back to top |
|
|
CourJuS Tux's lil' helper
Joined: 26 Jun 2004 Posts: 99 Location: Belgique
|
Posted: Fri Apr 22, 2005 7:13 pm Post subject: |
|
|
geforce wrote: | Quote: | netstat -anp |grep 3306
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 9470/mysqld |
|
killall -9 mysqld (un px bourin mais bon éfficace)
et /etc/init.d/mysql start |
|
Back to top |
|
|
geforce l33t
Joined: 29 Dec 2003 Posts: 653 Location: Canada
|
Posted: Fri Apr 22, 2005 7:14 pm Post subject: |
|
|
MERCI ! _________________ User #29433 |
|
Back to top |
|
|
CourJuS Tux's lil' helper
Joined: 26 Jun 2004 Posts: 99 Location: Belgique
|
Posted: Fri Apr 22, 2005 7:15 pm Post subject: |
|
|
sa marche ? si oui un ptit (résolut) dans le topics <---- j'ai rien dit
lol l'interactivité c'est plus un forum mais un IM mainent |
|
Back to top |
|
|
|