probleme apache/sql

probleme apache/sql - PHP - Programmation

Marsh Posté le 22-01-2003 à 09:23:05    

pas moyen de lancer sql :(
 
dans les log j'ai toujour la meme erreur :

Citation :

030122  9:22:24  G:\EasyPHP\MySql\bin\mysqld-nt.exe: Table 'mysql.host' doesn't exist


 
quand je lance mysqld-nt à la main ca marche bien mais ca se coupe vite fait !
j'ai essayer de 'linstaller en service mysqld-nt --install et ca fait rien
Savez vous d'ou provient l'erreur?

Reply

Marsh Posté le 22-01-2003 à 09:23:05   

Reply

Marsh Posté le 22-01-2003 à 09:28:05    

Install un Linux ...

Reply

Marsh Posté le 22-01-2003 à 09:28:44    

Salut,
 
Lances winmysqladmin.exe dans le repertoire bin, c surement parce que tu n'as pas initialisé ta base que ca ne fonctionne pas.
 

Reply

Marsh Posté le 22-01-2003 à 09:29:26    

western a écrit :

Install un Linux ...


 
oui, il faut recompiler le noyau :D

Reply

Marsh Posté le 22-01-2003 à 09:31:10    

recompiler parce que mysql demarre pas?  :lol:

Reply

Marsh Posté le 22-01-2003 à 09:33:05    

chui sous window avec easy php !
 
hier ca marchait :/

Reply

Marsh Posté le 22-01-2003 à 09:34:20    

bah oui c'est pour cela ... install un Linux et si ça marche un jour, ça marche toujours (sauf conneries que tu peux faire mais ...) ...

Reply

Marsh Posté le 22-01-2003 à 09:34:38    

alien_nan a écrit :

Salut,
 
Lances winmysqladmin.exe dans le repertoire bin, c surement parce que tu n'as pas initialisé ta base que ca ne fonctionne pas.
 
 

avec quel argument?

Reply

Marsh Posté le 22-01-2003 à 09:35:10    

western a écrit :

recompiler parce que mysql demarre pas?  :lol:  


 
sous linux, qd ca plante, a part recompiler tes installations, je vois pas trop ce que tu peux faire d'autres .... :sweat:

Reply

Marsh Posté le 22-01-2003 à 09:37:52    

chacal_one333 a écrit :

avec quel argument?


 
tu n'as pas besoin d'argument, tu le lances, il va te demander un login et un mot de passe
 
l'equivalent sous linux c scripts/mysql_install_db .... à verifier....

Reply

Marsh Posté le 22-01-2003 à 09:37:52   

Reply

Marsh Posté le 22-01-2003 à 09:38:27    

alien_nan a écrit :


 
tu n'as pas besoin d'argument, tu le lances, il va te demander un login et un mot de passe
 
l'equivalent sous linux c scripts/mysql_install_db .... à verifier....

:non:  
 

Citation :

[quote]G:\EASYPHP\MYSQL\BIN>mysqladmin
MYSQLADMIN  Ver 8.23 Distrib 3.23.49, for Win95/Win98 on i32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
 
Administration program for the mysqld daemon.
Usage: MYSQLADMIN [OPTIONS] command command....
 
  -#, --debug=...       Output debug log. Often this is 'd:t:o,filename`
  -f, --force           Don't ask for confirmation on drop database; with
                        multiple commands, continue even if an error occurs
  -?, --help            Display this help and exit
  --character-sets-dir=...
                        Set the character set directory
  -C, --compress        Use compression in server/client protocol
  -h, --host=#          Connect to host
  -p, --password[=...]  Password to use when connecting to server
                        If password is not given it's asked from the tty
-W, --pipe              Use named pipes to connect to server
  -P  --port=...        Port number to use for connection
  -i, --sleep=sec       Execute commands again and again with a sleep between
  -r, --relative        Show difference between current and previous values
                        when used with -i. Currently works only with
                        extended-status
  -E, --vertical        Print output vertically. Is similar to --relative,
                        but prints output vertically.
  -s, --silent          Silently exit if one can't connect to server
  -S, --socket=...      Socket file to use for connection
  -u, --user=#          User for login if not current user
  -v, --verbose         Write more information
  -V, --version         Output version information and exit
  -w, --wait[=retries]  Wait and retry if connection is down
 
Default options are read from the following files in the given order:
C:\WINNT\my.ini C:\my.cnf
The following groups are read: mysqladmin client
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit
--no-defaults           Don't read default options from any options file
--defaults-file=#       Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read
 
Possible variables for option --set-variable (-O) are:
connect_timeout       current value: 0
shutdown_timeout      current value: 3600
 
Where command is a one or more of: (Commands may be shortened)
  create databasename   Create a new database
  drop databasename     Delete a database and all its tables
  extended-status       Gives an extended status message from the server
  flush-hosts           Flush all cached hosts
  flush-logs            Flush all logs
  flush-status          Clear status variables
  flush-tables          Flush all tables
  flush-threads         Flush the thread cache
  flush-privileges      Reload grant tables (same as reload)
  kill id,id,...        Kill mysql threads
  password new-password Change old password to new-password
  ping                  Check if mysqld is alive
  processlist           Show list of active threads in server
  reload                Reload grant tables
  refresh               Flush all tables and close and open logfiles
  shutdown              Take server down
  status                Gives a short status message from the server
  start-slave           Start slave
  stop-slave            Stop slave
  variables             Prints variables available
  version               Get version info from server
 
G:\EASYPHP\MYSQL\BIN>

Reply

Marsh Posté le 22-01-2003 à 09:41:32    

chacal_one333 a écrit :

:non:  
 

Citation :

[quote]G:\EASYPHP\MYSQL\BIN>mysqladmin
MYSQLADMIN  Ver 8.23 Distrib 3.23.49, for Win95/Win98 on i32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
 
Administration program for the mysqld daemon.
Usage: MYSQLADMIN [OPTIONS] command command....
 
  -#, --debug=...       Output debug log. Often this is 'd:t:o,filename`
  -f, --force           Don't ask for confirmation on drop database; with
                        multiple commands, continue even if an error occurs
  -?, --help            Display this help and exit
  --character-sets-dir=...
                        Set the character set directory
  -C, --compress        Use compression in server/client protocol
  -h, --host=#          Connect to host
  -p, --password[=...]  Password to use when connecting to server
                        If password is not given it's asked from the tty
-W, --pipe              Use named pipes to connect to server
  -P  --port=...        Port number to use for connection
  -i, --sleep=sec       Execute commands again and again with a sleep between
  -r, --relative        Show difference between current and previous values
                        when used with -i. Currently works only with
                        extended-status
  -E, --vertical        Print output vertically. Is similar to --relative,
                        but prints output vertically.
  -s, --silent          Silently exit if one can't connect to server
  -S, --socket=...      Socket file to use for connection
  -u, --user=#          User for login if not current user
  -v, --verbose         Write more information
  -V, --version         Output version information and exit
  -w, --wait[=retries]  Wait and retry if connection is down
 
Default options are read from the following files in the given order:
C:\WINNT\my.ini C:\my.cnf
The following groups are read: mysqladmin client
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit
--no-defaults           Don't read default options from any options file
--defaults-file=#       Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read
 
Possible variables for option --set-variable (-O) are:
connect_timeout       current value: 0
shutdown_timeout      current value: 3600
 
Where command is a one or more of: (Commands may be shortened)
  create databasename   Create a new database
  drop databasename     Delete a database and all its tables
  extended-status       Gives an extended status message from the server
  flush-hosts           Flush all cached hosts
  flush-logs            Flush all logs
  flush-status          Clear status variables
  flush-tables          Flush all tables
  flush-threads         Flush the thread cache
  flush-privileges      Reload grant tables (same as reload)
  kill id,id,...        Kill mysql threads
  password new-password Change old password to new-password
  ping                  Check if mysqld is alive
  processlist           Show list of active threads in server
  reload                Reload grant tables
  refresh               Flush all tables and close and open logfiles
  shutdown              Take server down
  status                Gives a short status message from the server
  start-slave           Start slave
  stop-slave            Stop slave
  variables             Prints variables available
  version               Get version info from server
 
G:\EASYPHP\MYSQL\BIN>




 
=>winmysqladmin (cliques dessus, c l'interface sous windows)

Reply

Marsh Posté le 22-01-2003 à 09:43:10    

je l'ai pas ca [:_ _taupe_ _]

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed