Problema Com O Mysql Do Phpdev V4.23

[BIFE]

galera to com um problemão.. instalei o phpDev v4.23 mas o mysql dele não inicia e sem ele iniciar quando eu vo tentar entrar np phpmyadmin aparece isso

MENSAGEM DO MYSQL

já tentei ir na pasta que esta o mysql e clikar em mysql.exe mas acontece o seguinte abre uma tela do DOS se fecha rapido ... alguém sabe se preciza configurar alguma coisa?

espero respostas

[Fabyo]

o mysql é independente do php , se ele não esta iniciado como serviço você precisa startar ele entra no DOS e na pasta do mysql\bin você digita mysqld-nt install pra instalar o serviço e pra iniciar você digita mysqld-nt start

o mysqld-nt é pra windows 2k xp etc... no win98 você não digita nt

qualquer duvida posta ai

[BIFE]

fabão fiz akilo que você me indicou e não vi nada de diferente depois de ter feitos esses processo que você me indicou continua aparecendo a mesma tela quando eu vou entrar no phpmyadmin

tela do DOS ATE CHEGAR NA PASTA MYSQL

Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\Documents and Settings\Gilmar1>cd C:\

C:\>cd phpdev

C:\phpdev>cd mysql

C:\phpdev\mysql>cd bin

C:\phpdev\mysql\bin>

TEL QUE O DOS ME DEU QUANDO DEI INSTALL

C:\phpdev\mysql\bin>mysqld-nt install
mysqld-nt: unrecognized option `--key_buffer=16K'
mysqld-nt  Ver 4.0.0-alpha-nt for NT on i32
Copyright (C) 2000 MySQL AB & MySQL Finland AB, by Monty and others
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Starts the MySQL server

Usage: mysqld-nt [OPTIONS]

  --ansi                Use ANSI SQL syntax instead of MySQL syntax
  -b, --basedir=path    Path to installation directory. All paths are
                        usually resolved relative to this
  --big-tables          Allow big result sets by saving all temporary sets
                        on file (Solves most 'table full' errors)
  --bind-address=IP     Ip address to bind to
  --bootstrap           Used by mysql installation scripts
  --character-sets-dir=...
                        Directory where character sets are
  --chroot=path         Chroot mysqld daemon during startup
  --core-file           Write core on errors
  -h, --datadir=path    Path to the database root
  --default-character-set=charset
                        Set the default character set
  --default-table-type=type
                        Set the default table type for tables
  --delay-key-write-for-all-tables
                        Don't flush key buffers between writes for any MyISAM
                        table
  --enable-locking      Enable system locking
  --enable-pstack       Print a symbolic stack trace on failure
  -T, --exit-info       Used for debugging;  Use at your own risk!
  --flush               Flush tables to disk between SQL commands
  -?, --help            Display this help and exit
  --init-file=file      Read SQL commands from this file at startup
  -L, --language=...    Client error messages in given language. May be
                        given as a full path
  -l, --log[=file]      Log connections and queries to file
  --log-bin[=file]      Log queries in new binary format (for replication)
  --log-bin-index=file  File that holds the names for last binary log files
  --log-update[=file]   Log updates to file.# where # is a unique number
                        if not given.
  --log-isam[=file]     Log all MyISAM changes to file
  --log-long-format     Log some extra information to update log
  --low-priority-updates INSERT/DELETE/UPDATE has lower priority than selects
  --log-slow-queries=[file]
                        Log slow queries to this log file.  Defaults logging
                        to hostname-slow.log
  --pid-file=path       Pid file used by safe_mysqld
  --myisam-recover[=option[,option...]] where options is one of DEAULT,
                        BACKUP or FORCE.
  --memlock             Lock mysqld in memory
  -n, --new             Use very new possible 'unsafe' functions
  -o, --old-protocol    Use the old (3.20) protocol
  -P, --port=...        Port number to use for connection

  -O, --set-variable var=option
                        Give a variable an value. --help lists variables
  --safe-mode           Skip some optimize stages (for testing)
  --safe-show-database  Don't show databases for which the user has no
                        privileges
  --safe-user-create    Don't new users cretaion without privileges to the
                        mysql.user table
  --skip-concurrent-insert
                        Don't use concurrent insert with MyISAM
  --skip-delay-key-write
                        Ignore the delay_key_write option for all tables
  --skip-grant-tables   Start without grant tables. This gives all users
                        FULL ACCESS to all tables!
  --skip-host-cache     Don't cache host names
  --skip-locking        Don't use system locking. To use isamchk one has
                        to shut down the server.
  --skip-name-resolve   Don't resolve hostnames.
                        All hostnames are IP's or 'localhost'
  --skip-networking     Don't allow connection with TCP/IP.
  --skip-new            Don't use new, possible wrong routines.

  --skip-stack-trace    Don't print a stack trace on failure
  --skip-symlink        Don't allow symlinking of tables
  --skip-show-database  Don't allow 'SHOW DATABASE' commands
  --skip-thread-priority
                        Don't give threads different priorities.
  --socket=...          Socket file to use for connection
  -t, --tmpdir=path     Path for temporary files
  --sql-mode=option[,option[,option...]] where option can be one of:
                        REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES,
                        IGNORE_SPACE, SERIALIZE, ONLY_FULL_GROUP_BY.
  --transaction-isolation
                        Default transaction isolation level
  --temp-pool           Use a pool of temporary files
  -u, --user=user_name  Run mysqld daemon as user
  -V, --version         output version information and exit
  -W, --warnings        Log some not critical warnings to the log file

NT and Win32 specific options:
  --console             Don't remove the console window
  --install             Install mysqld as a service (NT)
  --remove              Remove mysqld from the service list (NT)
  --standalone          Dummy option to start as a standalone program (NT)


Default options are read from the following files in the given order:
C:\WINNT\my.ini C:\my.cnf
The following groups are read: mysqld server
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

To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --help'.
The default values (after parsing the command line arguments) are:

basedir:     C:\phpdev\mysql\
datadir:     C:\phpdev\mysql\data\
tmpdir:      C:\DOCUME~1\Gilmar1\CONFIG~1\Temp\
language:    C:\phpdev\mysql\share\english\
TCP port:    3306

system locking is not in use

Possible variables for option --set-variable (-O) are:
back_log              current value: 50
binlog_cache_size     current value: 32768
connect_timeout       current value: 5
delayed_insert_timeout  current value: 300
delayed_insert_limit  current value: 100
delayed_queue_size    current value: 1000
flush_time            current value: 1800
ft_min_word_len       current value: 4
ft_max_word_len       current value: 254
ft_max_word_len_for_sort  current value: 20
interactive_timeout   current value: 28800
join_buffer_size      current value: 131072
key_buffer_size       current value: 8388600
long_query_time       current value: 10
lower_case_table_names  current value: 1
max_allowed_packet    current value: 1048576
max_binlog_cache_size  current value: 4294967295
max_binlog_size       current value: 1073741824
max_connections       current value: 100
max_connect_errors    current value: 10
max_delayed_threads   current value: 20
max_heap_table_size   current value: 16777216
max_join_size         current value: 4294967295
max_sort_length       current value: 1024
max_tmp_tables        current value: 32
max_user_connections  current value: 0
max_write_lock_count  current value: 4294967295
myisam_bulk_insert_tree_size  current value: 8388608
myisam_block_size     current value: 1024
myisam_max_extra_sort_file_size  current value: 256
myisam_max_sort_file_size  current value: 2047
myisam_sort_buffer_size  current value: 8388608
net_buffer_length     current value: 16384
net_retry_count       current value: 10
net_read_timeout      current value: 30
net_write_timeout     current value: 60
open_files_limit      current value: 0
query_buffer_size     current value: 0
record_buffer         current value: 131072
record_rnd_buffer     current value: 0
slave_net_timeout     current value: 3600
slow_launch_time      current value: 2
sort_buffer           current value: 2097144
table_cache           current value: 64
thread_concurrency    current value: 10
thread_cache_size     current value: 0
tmp_table_size        current value: 33554432
thread_stack          current value: 65536
wait_timeout          current value: 28800

TELA QUE O DOS ME DEU QUANDO DEI START

C:\phpdev\mysql\bin>mysqld-nt start
mysqld-nt: unrecognized option `--key_buffer=16K'
mysqld-nt  Ver 4.0.0-alpha-nt for NT on i32
Copyright (C) 2000 MySQL AB & MySQL Finland AB, by Monty and others
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Starts the MySQL server

Usage: mysqld-nt [OPTIONS]

  --ansi                Use ANSI SQL syntax instead of MySQL syntax
  -b, --basedir=path    Path to installation directory. All paths are
                        usually resolved relative to this
  --big-tables          Allow big result sets by saving all temporary sets
                        on file (Solves most 'table full' errors)
  --bind-address=IP     Ip address to bind to
  --bootstrap           Used by mysql installation scripts
  --character-sets-dir=...
                        Directory where character sets are
  --chroot=path         Chroot mysqld daemon during startup
  --core-file           Write core on errors
  -h, --datadir=path    Path to the database root
  --default-character-set=charset
                        Set the default character set
  --default-table-type=type
                        Set the default table type for tables
  --delay-key-write-for-all-tables
                        Don't flush key buffers between writes for any MyISAM
                        table
  --enable-locking      Enable system locking
  --enable-pstack       Print a symbolic stack trace on failure
  -T, --exit-info       Used for debugging;  Use at your own risk!
  --flush               Flush tables to disk between SQL commands
  -?, --help            Display this help and exit
  --init-file=file      Read SQL commands from this file at startup
  -L, --language=...    Client error messages in given language. May be
                        given as a full path
  -l, --log[=file]      Log connections and queries to file
  --log-bin[=file]      Log queries in new binary format (for replication)
  --log-bin-index=file  File that holds the names for last binary log files
  --log-update[=file]   Log updates to file.# where # is a unique number
                        if not given.
  --log-isam[=file]     Log all MyISAM changes to file
  --log-long-format     Log some extra information to update log
  --low-priority-updates INSERT/DELETE/UPDATE has lower priority than selects
  --log-slow-queries=[file]
                        Log slow queries to this log file.  Defaults logging
                        to hostname-slow.log
  --pid-file=path       Pid file used by safe_mysqld
  --myisam-recover[=option[,option...]] where options is one of DEAULT,
                        BACKUP or FORCE.
  --memlock             Lock mysqld in memory
  -n, --new             Use very new possible 'unsafe' functions
  -o, --old-protocol    Use the old (3.20) protocol
  -P, --port=...        Port number to use for connection

  -O, --set-variable var=option
                        Give a variable an value. --help lists variables
  --safe-mode           Skip some optimize stages (for testing)
  --safe-show-database  Don't show databases for which the user has no
                        privileges
  --safe-user-create    Don't new users cretaion without privileges to the
                        mysql.user table
  --skip-concurrent-insert
                        Don't use concurrent insert with MyISAM
  --skip-delay-key-write
                        Ignore the delay_key_write option for all tables
  --skip-grant-tables   Start without grant tables. This gives all users
                        FULL ACCESS to all tables!
  --skip-host-cache     Don't cache host names
  --skip-locking        Don't use system locking. To use isamchk one has
                        to shut down the server.
  --skip-name-resolve   Don't resolve hostnames.
                        All hostnames are IP's or 'localhost'
  --skip-networking     Don't allow connection with TCP/IP.
  --skip-new            Don't use new, possible wrong routines.

  --skip-stack-trace    Don't print a stack trace on failure
  --skip-symlink        Don't allow symlinking of tables
  --skip-show-database  Don't allow 'SHOW DATABASE' commands
  --skip-thread-priority
                        Don't give threads different priorities.
  --socket=...          Socket file to use for connection
  -t, --tmpdir=path     Path for temporary files
  --sql-mode=option[,option[,option...]] where option can be one of:
                        REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES,
                        IGNORE_SPACE, SERIALIZE, ONLY_FULL_GROUP_BY.
  --transaction-isolation
                        Default transaction isolation level
  --temp-pool           Use a pool of temporary files
  -u, --user=user_name  Run mysqld daemon as user
  -V, --version         output version information and exit
  -W, --warnings        Log some not critical warnings to the log file

NT and Win32 specific options:
  --console             Don't remove the console window
  --install             Install mysqld as a service (NT)
  --remove              Remove mysqld from the service list (NT)
  --standalone          Dummy option to start as a standalone program (NT)


Default options are read from the following files in the given order:
C:\WINNT\my.ini C:\my.cnf
The following groups are read: mysqld server
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

To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --help'.
The default values (after parsing the command line arguments) are:

basedir:     C:\phpdev\mysql\
datadir:     C:\phpdev\mysql\data\
tmpdir:      C:\DOCUME~1\Gilmar1\CONFIG~1\Temp\
language:    C:\phpdev\mysql\share\english\
TCP port:    3306

system locking is not in use

Possible variables for option --set-variable (-O) are:
back_log              current value: 50
binlog_cache_size     current value: 32768
connect_timeout       current value: 5
delayed_insert_timeout  current value: 300
delayed_insert_limit  current value: 100
delayed_queue_size    current value: 1000
flush_time            current value: 1800
ft_min_word_len       current value: 4
ft_max_word_len       current value: 254
ft_max_word_len_for_sort  current value: 20
interactive_timeout   current value: 28800
join_buffer_size      current value: 131072
key_buffer_size       current value: 8388600
long_query_time       current value: 10
lower_case_table_names  current value: 1
max_allowed_packet    current value: 1048576
max_binlog_cache_size  current value: 4294967295
max_binlog_size       current value: 1073741824
max_connections       current value: 100
max_connect_errors    current value: 10
max_delayed_threads   current value: 20
max_heap_table_size   current value: 16777216
max_join_size         current value: 4294967295
max_sort_length       current value: 1024
max_tmp_tables        current value: 32
max_user_connections  current value: 0
max_write_lock_count  current value: 4294967295
myisam_bulk_insert_tree_size  current value: 8388608
myisam_block_size     current value: 1024
myisam_max_extra_sort_file_size  current value: 256
myisam_max_sort_file_size  current value: 2047
myisam_sort_buffer_size  current value: 8388608
net_buffer_length     current value: 16384
net_retry_count       current value: 10
net_read_timeout      current value: 30
net_write_timeout     current value: 60
open_files_limit      current value: 0
query_buffer_size     current value: 0
record_buffer         current value: 131072
record_rnd_buffer     current value: 0
slave_net_timeout     current value: 3600
slow_launch_time      current value: 2
sort_buffer           current value: 2097144
table_cache           current value: 64
thread_concurrency    current value: 10
thread_cache_size     current value: 0
tmp_table_size        current value: 33554432
thread_stack          current value: 65536
wait_timeout          current value: 28800

[Fabyo]

não instalou o mysql que versao você ta usando ?

[BIFE]

na verdade estou usando o phpDev v4.23

acho que é isso

isso estava no site que baixei o programa

Apache 1.3.27

PHP 4.2.3

MySQL 4.0

phpMyAdmin 2.3.2

Zend Optimizer 2.0.2

Invision Board

Phpwebsite

Cerebus FTP

GD Library activo

PHP-GTK (instalação opcional - http://www.firepages.org/gtkdev.html)

Mod Perl + Perl v5.6.1(instalação opcional - http://www.firepages.com.au/mod_perl.htm)

[BIFE]

eu dei uma olhada AQUI

e fiz exatamente como estava dizendo..

e acontece isso

C:\phpdev\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

já to fikando doido.. se alguém tiver alguma outra dica..to aceitadno de tudo

[Fabyo]

Porque você não instala tudo separado ?

esses pacotes é tranqueira

[BIFE]

to achando melhor fazer isso mesmo... esse tuto pendurado aqui em php mesmo ensinando a configurar pá... vai dar pra eu rodar php na minha makina né... é só pra isso que quero esses programas