Ubuntu-fr

teddy.78

Re : Serveur / site web (Résolue)

Et cela pose un problème ou non ? car toi ils sont vide mais mysql fonctionne ?

Ungars

Re : Serveur / site web (Résolue)

Chez moi, le mysql.err est vide ce qui me parait normal, pour l' autre je ne sais pas. Je viens de regarder sur un de mes serveurs, c' est la même chose. As tu essayé ça , comme on en avait déjà parlé, ça mérite d' essayer.

teddy.78

Re : Serveur / site web (Résolue)

A oui mais le probleme est que lorsque je lance la commande "sudo mysql_secure_installation" il me demande le password je met donc mon password mais cela me met l'erreur 2002 donc je peut pas faire la suite j'ai essayer sans mettre de password mais meme erreur et je suis sur que ces se mots de passe la vu j'ai reinstaller mysql en mettant bien ce mots de passe sinon il y aurais t'il un moyen de supprimer le mots de passe histoire de voir si ce nest pas un probleme a ce niveau la ?

Edit: A non ce n'est pas possible vu sur le lien que tu me dit il dise qu'il faut un password sinon cela ne marche pas

Edit: J'essaye actuellement de reinstaller mysql et je vais voir

Edit: Cela ne fonctionne toujours pas le probleme est qu'il n'arrive pas a acceder au mots de passe je crois a ce que j'ai compris. Il n'arrive pas a modifier le mots de passe si je comprend bien lorsque j'essaye de me connecter a mysql il n'arrive pas a acceder au mots de passe donc n'arrive pas a verifier que ces le bon donc n'arrive pas a ce connecter au serveur. Mais je ne suis pas sur du tout ces juste ce que je pense pouvez vous me dire ce que vous en pensez ?

Dernière modification par teddy.78 (Le 26/03/2011, à 00:34)

Ungars

Re : Serveur / site web (Résolue)

Même si tu te connectes en root ? Avec sudo -i

teddy.78

Re : Serveur / site web (Résolue)

Même resultat

Ungars

Re : Serveur / site web (Résolue)

Dans ton repertoire /www, as tu un fichier config.php ? Si oui peux tu poster le contenu.
  On va y arriver, bon courage.

teddy.78

Re : Serveur / site web (Résolue)

Non je n'est pas de config.php j'ai que un dossier test (ces le dossier que j'ai cree pour apache 2 pour le site) et un fichier index.html (cela vien aussi de apache2

Ungars

Re : Serveur / site web (Résolue)

Peux tu faire un :

cat /var/log/mysql/error.log

teddy.78

Re : Serveur / site web (Résolue)

Oo sa met un message plus grand que la taille maximal du terminal ca va etre dur de tous mettre je fait quoi ?

Ungars

Re : Serveur / site web (Résolue)

Alors on va peut etre y voir plus clair. Inutile de mettre tout, mets ce que tu peux mettre.

teddy.78

Re : Serveur / site web (Résolue)

Oki voici le resultat je doit avouer que la je ne comprend pas grand chose

110326 10:11:17  InnoDB: Starting shutdown...
110326 10:11:23  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:11:23 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:11:47 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:11:47 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:11:48  InnoDB: Started; log sequence number 0 44233
110326 10:11:48 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:11:48 [ERROR] Aborting

110326 10:11:48  InnoDB: Starting shutdown...
110326 10:11:53  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:11:53 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:12:18 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:12:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:12:18  InnoDB: Started; log sequence number 0 44233
110326 10:12:18 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:12:18 [ERROR] Aborting

110326 10:12:18  InnoDB: Starting shutdown...
110326 10:12:23  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:12:23 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:12:48 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:12:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:12:48  InnoDB: Started; log sequence number 0 44233
110326 10:12:48 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:12:48 [ERROR] Aborting

110326 10:12:48  InnoDB: Starting shutdown...
110326 10:12:53  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:12:53 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:13:18 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:13:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:13:18  InnoDB: Started; log sequence number 0 44233
110326 10:13:18 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:13:18 [ERROR] Aborting

110326 10:13:18  InnoDB: Starting shutdown...
110326 10:13:24  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:13:24 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:13:49 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:13:49 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:13:49  InnoDB: Started; log sequence number 0 44233
110326 10:13:49 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:13:49 [ERROR] Aborting

110326 10:13:49  InnoDB: Starting shutdown...
110326 10:13:54  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:13:54 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:14:19 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:14:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:14:19  InnoDB: Started; log sequence number 0 44233
110326 10:14:19 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:14:19 [ERROR] Aborting

110326 10:14:19  InnoDB: Starting shutdown...
110326 10:14:24  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:14:24 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:14:49 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:14:49 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:14:49  InnoDB: Started; log sequence number 0 44233
110326 10:14:49 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:14:49 [ERROR] Aborting

110326 10:14:49  InnoDB: Starting shutdown...
110326 10:14:55  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:14:55 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:15:19 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:15:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:15:20  InnoDB: Started; log sequence number 0 44233
110326 10:15:20 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:15:20 [ERROR] Aborting

110326 10:15:20  InnoDB: Starting shutdown...
110326 10:15:25  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:15:25 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:15:50 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:15:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:15:50  InnoDB: Started; log sequence number 0 44233
110326 10:15:50 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:15:50 [ERROR] Aborting

110326 10:15:50  InnoDB: Starting shutdown...
110326 10:15:55  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:15:55 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:16:20 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:16:20 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:16:20  InnoDB: Started; log sequence number 0 44233
110326 10:16:20 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:16:20 [ERROR] Aborting

110326 10:16:20  InnoDB: Starting shutdown...
110326 10:16:25  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:16:25 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:16:50 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:16:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:16:50  InnoDB: Started; log sequence number 0 44233
110326 10:16:50 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:16:50 [ERROR] Aborting

110326 10:16:50  InnoDB: Starting shutdown...
110326 10:16:56  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:16:56 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:17:20 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:17:20 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:17:21  InnoDB: Started; log sequence number 0 44233
110326 10:17:21 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:17:21 [ERROR] Aborting

110326 10:17:21  InnoDB: Starting shutdown...
110326 10:17:26  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:17:26 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:17:51 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:17:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:17:51  InnoDB: Started; log sequence number 0 44233
110326 10:17:51 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:17:51 [ERROR] Aborting

110326 10:17:51  InnoDB: Starting shutdown...
110326 10:17:56  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:17:56 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:18:21 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:18:21 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:18:21  InnoDB: Started; log sequence number 0 44233
110326 10:18:21 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:18:21 [ERROR] Aborting

110326 10:18:21  InnoDB: Starting shutdown...
110326 10:18:27  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:18:27 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:18:51 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:18:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:18:52  InnoDB: Started; log sequence number 0 44233
110326 10:18:52 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:18:52 [ERROR] Aborting

110326 10:18:52  InnoDB: Starting shutdown...
110326 10:18:57  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:18:57 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:19:22 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:19:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:19:22  InnoDB: Started; log sequence number 0 44233
110326 10:19:22 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:19:22 [ERROR] Aborting

110326 10:19:22  InnoDB: Starting shutdown...
110326 10:19:27  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:19:27 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:19:52 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:19:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:19:52  InnoDB: Started; log sequence number 0 44233
110326 10:19:52 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:19:52 [ERROR] Aborting

110326 10:19:52  InnoDB: Starting shutdown...
110326 10:19:57  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:19:57 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:20:22 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:20:22 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:20:22  InnoDB: Started; log sequence number 0 44233
110326 10:20:22 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:20:22 [ERROR] Aborting

110326 10:20:22  InnoDB: Starting shutdown...
110326 10:20:28  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:20:28 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:20:52 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:20:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:20:53  InnoDB: Started; log sequence number 0 44233
110326 10:20:53 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:20:53 [ERROR] Aborting

110326 10:20:53  InnoDB: Starting shutdown...
110326 10:20:58  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:20:58 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:21:23 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:21:23 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:21:23  InnoDB: Started; log sequence number 0 44233
110326 10:21:23 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:21:23 [ERROR] Aborting

110326 10:21:23  InnoDB: Starting shutdown...
110326 10:21:28  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:21:28 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:21:53 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:21:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:21:53  InnoDB: Started; log sequence number 0 44233
110326 10:21:53 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:21:53 [ERROR] Aborting

110326 10:21:53  InnoDB: Starting shutdown...
110326 10:21:58  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:21:58 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:22:23 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:22:23 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:22:23  InnoDB: Started; log sequence number 0 44233
110326 10:22:23 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:22:23 [ERROR] Aborting

110326 10:22:23  InnoDB: Starting shutdown...
110326 10:22:29  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:22:29 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:22:54 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:22:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:22:54  InnoDB: Started; log sequence number 0 44233
110326 10:22:54 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:22:54 [ERROR] Aborting

110326 10:22:54  InnoDB: Starting shutdown...
110326 10:22:59  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:22:59 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:23:24 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:23:24 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:23:24  InnoDB: Started; log sequence number 0 44233
110326 10:23:24 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:23:24 [ERROR] Aborting

110326 10:23:24  InnoDB: Starting shutdown...
110326 10:23:29  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:23:29 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:23:54 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:23:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:23:54  InnoDB: Started; log sequence number 0 44233
110326 10:23:54 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:23:54 [ERROR] Aborting

110326 10:23:54  InnoDB: Starting shutdown...
110326 10:24:00  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:24:00 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:24:24 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:24:24 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:24:25  InnoDB: Started; log sequence number 0 44233
110326 10:24:25 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:24:25 [ERROR] Aborting

110326 10:24:25  InnoDB: Starting shutdown...
110326 10:24:30  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:24:30 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:24:55 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:24:55 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:24:55  InnoDB: Started; log sequence number 0 44233
110326 10:24:55 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:24:55 [ERROR] Aborting

110326 10:24:55  InnoDB: Starting shutdown...
110326 10:25:00  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:25:00 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:25:25 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:25:25 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:25:25  InnoDB: Started; log sequence number 0 44233
110326 10:25:25 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:25:25 [ERROR] Aborting

110326 10:25:25  InnoDB: Starting shutdown...
110326 10:25:30  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:25:30 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:25:55 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:25:55 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:25:55  InnoDB: Started; log sequence number 0 44233
110326 10:25:55 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:25:55 [ERROR] Aborting

110326 10:25:55  InnoDB: Starting shutdown...
110326 10:26:01  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:26:01 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:26:26 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:26:26 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:26:26  InnoDB: Started; log sequence number 0 44233
110326 10:26:26 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:26:26 [ERROR] Aborting

110326 10:26:26  InnoDB: Starting shutdown...
110326 10:26:31  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:26:31 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:26:56 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:26:56 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:26:56  InnoDB: Started; log sequence number 0 44233
110326 10:26:56 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:26:56 [ERROR] Aborting

110326 10:26:56  InnoDB: Starting shutdown...
110326 10:27:01  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:27:01 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:27:26 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:27:26 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:27:26  InnoDB: Started; log sequence number 0 44233
110326 10:27:26 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:27:26 [ERROR] Aborting

110326 10:27:26  InnoDB: Starting shutdown...
110326 10:27:32  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:27:32 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:27:56 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:27:56 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:27:57  InnoDB: Started; log sequence number 0 44233
110326 10:27:57 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:27:57 [ERROR] Aborting

110326 10:27:57  InnoDB: Starting shutdown...
110326 10:28:02  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:28:02 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:28:27 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:28:27 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:28:27  InnoDB: Started; log sequence number 0 44233
110326 10:28:27 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:28:27 [ERROR] Aborting

110326 10:28:27  InnoDB: Starting shutdown...
110326 10:28:32  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:28:32 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:28:57 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:28:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:28:57  InnoDB: Started; log sequence number 0 44233
110326 10:28:57 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:28:57 [ERROR] Aborting

110326 10:28:57  InnoDB: Starting shutdown...
110326 10:29:02  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:29:02 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:29:27 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:29:27 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:29:27  InnoDB: Started; log sequence number 0 44233
110326 10:29:27 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:29:27 [ERROR] Aborting

110326 10:29:27  InnoDB: Starting shutdown...
110326 10:29:33  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:29:33 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:29:58 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:29:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:29:58  InnoDB: Started; log sequence number 0 44233
110326 10:29:58 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:29:58 [ERROR] Aborting

110326 10:29:58  InnoDB: Starting shutdown...
110326 10:30:03  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:30:03 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:30:28 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:30:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:30:28  InnoDB: Started; log sequence number 0 44233
110326 10:30:28 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:30:28 [ERROR] Aborting

110326 10:30:28  InnoDB: Starting shutdown...
110326 10:30:33  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:30:33 [Note] /usr/sbin/mysqld: Shutdown complete

110326 10:30:58 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 10:30:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 10:30:58  InnoDB: Started; log sequence number 0 44233
110326 10:30:58 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'
110326 10:30:58 [ERROR] Aborting

110326 10:30:58  InnoDB: Starting shutdown...
110326 10:31:04  InnoDB: Shutdown completed; log sequence number 0 44233
110326 10:31:04 [Note] /usr/sbin/mysqld: Shutdown complete

Ungars

Re : Serveur / site web (Résolue)

Bon, on a enfin un log qui parle.
  Ce qui me choque c' est ça :

110326 10:11:48 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-adress=192.168.1.3'

  Or, dans ton /etc/mysql/my.cnf, il y a :

bind-address        = 127.0.0.1
bind-adress             = 192.168.1.3

  Je ne suis pas sur que ce soit normal...
  Ouvre ton /etc/mysql/my.cnf, et commente la dernière ligne ci dessus en mettant un # ce qui fera :

#bind-adress             = 192.168.1.3

  Sauvegarde, stop mysql, start mysql et dis nous...

teddy.78

Re : Serveur / site web (Résolue)

Deja je souhaite dire que ce n'est pas moi qui est modifier ce fichier de plus l'adresse 192.168.1.3 correspond a l'adresse d'un autre ordinateur du reseau celui sur lequel je suis actuellement et non pas celui qui a le serveur donc je ne comprend pas cela a peut etre a voir avec apache2 non ?

J'ai donc rajouter le # mais j'ai toujours le probleme que je stop le programme mysql puis je fait pour le relancer et sa cherche mais ne dit jamais que l'action a ete faite donc je ne comprend pas je relance donc le pc et retest mais cela ne marche toujours pas je croi que en faite le programme n'arrive pas a ce lancer

Dernière modification par teddy.78 (Le 26/03/2011, à 23:24)

Ungars

Re : Serveur / site web (Résolue)

Tu as bien redémarrer mysql ?
  Supprime carrément cette ligne, de toute façon elle est ecrite avec une faute et ne sert à rien.
  Fais ensuite un :
 

cat /var/log/mysql/error.log

à l' heure ou tu as relancé mysql, voir quels sont les messages d' erreur maintenant.

teddy.78

Re : Serveur / site web (Résolue)

A j'ai un message d'erreur comme quoi il ne peut pas verrouiller les privilège  parce que mysql.host n'existe pas je te met les erreur du fichier qu'il me met a l'heure ou je redemare

110326 22:42:36 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
110326 22:42:36 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
110326 22:42:36  InnoDB: Started; log sequence number 0 44233
110326 22:42:36 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

Ungars

Re : Serveur / site web (Résolue)

Bon déjà tu as un message d' erreur en moins, c' est déjà ça.
  Si tu fais un :

sudo mysql_upgrade

  Ca donne quoi ?

teddy.78

Re : Serveur / site web (Résolue)

Oui j'ai essaye mysql_upgrade cela commence a chercher et au moment de la verification cela me met "got error: 2002 ..."

Ungars

Re : Serveur / site web (Résolue)

Essaye ça : http://forum.ubuntu-fr.org/viewtopic.ph … 2#p3207872

teddy.78

Re : Serveur / site web (Résolue)

WHOUAHOU merci sa remarche je ne comprend pas la mais sa remarche juste grace a "autoremove" ba merci beaucoup de ton aide

Edit: J'ai decouvert donc vien le probleme le probleme vien de bind-address qui doit correspondre a l'adresse qu'il ecoute car j'ai reinstaller et remit bind-adress: 192.168.1.3 (l'adresse de mon ordinateur ) mais cela me remet erreur 2002 donc bizare

Dernière modification par teddy.78 (Le 27/03/2011, à 00:34)

Ungars

Re : Serveur / site web (Résolue)

C' est bind address avec 2 "d" , mais sur ton fichier de conf tu avais deux bind-address, déjà ce n' était pas bon.

  Content que cela refonctionne, bon Dimanche

Dernière modification par Ungars (Le 27/03/2011, à 00:40)

teddy.78

Re : Serveur / site web (Résolue)

Oki merci mais meme avec 2 "d" cela fait la meme erreur je ne veut pas continuer avec mes problème mais je ne comprend pas pourquoi lorsque je met a ecouter une autre machine cela ne fonctionne plus

Ungars

Re : Serveur / site web (Résolue)

Cela te fait sans doute l' erreur 2002, mais pas celle qu' il y avait dans les logs :

unknown variable 'bind-adress=192.168.1.3'

  Tu aurais sans doute eu des problèmes avec ça de toute façon.

teddy.78

Re : Serveur / site web (Résolue)

Mais je ne compprend donc pas comment metre pour que mysql ecoute l'address 192.168.1.3 (j'ai deja essayer avec bin-address = 192.168.1.3 mais cela ne fonctionne pas

Ungars

Re : Serveur / site web (Résolue)

C' est bind-adress, avec un d

Altaïr_o

Re : Serveur / site web (Résolue)

Désolé de déterrer le sujet, mais je rencontre exactement la même erreur. Après avoir fait

apt-get --purge autoremove mysql-server

je réinstalle mysql-server, je choisis un mot de passe root, et mysql me répond

impossible de changer le mot de passe de l'utilisateur root de mysql

---

Des chercheurs qui cherchent, on en trouve, des chercheurs qui trouvent, on en cherche.