Installation problem, PHP, MYSQL on local machine

  • taysay

    (@taysay)


    18 years, 11 months ago

    Hi
    I were installed the mysql-essential-4.1.12a-win32 and php-4.3.10-Win32
    on a XP box, and then I were created the new database and related username having all privilieges and grants. Then I configured the
    wp-config.php according my specification (database name and …) carefully.
    But when I came to instll the wordpress using the following link:
    http://localhost/wordpress/wp-config.php
    I got a page containing following messege:

    Error establishing a database connection
    This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at localhost. This could mean your host’s database server is down.

    Are you sure you have the correct username and password?
    Are you sure that you have typed the correct hostname?
    Are you sure that the database server is running?
    If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.
    …………………………………………………………………..
    But, believe me that I enterd the database name and username and password correctly, and MYsql is running on my PC . It seems that everything would be ok, unless that the installation could not be countinued.
    I were changed the “localhost” by my PC IP, also.
    I had to say that I face this problem on a W2K Box, too. And Note That my webserver is IIS 5.0
    Please help .
    Any help is greatly appreciated.

Viewing 11 replies - 1 through 11 (of 11 total)
  • Mark (podz)

    (@podz)

    18 years, 11 months ago

    I use XP Home and xampp very successfully so if this gets too much, stop IIS and go get xampp.
    http://www.apachefriends.org/en/xampp.html

    Can you do a phpinfo and check that all the parts are talking to each other ?

    Thread Starter taysay

    (@taysay)

    18 years, 11 months ago

    hi dear podz
    I had to use ISS, because of some reasons.
    So, pls tell me how I can do a phpinfo to check that all parts are talking eachother.
    thanks.

    Mark (podz)

    (@podz)

    18 years, 11 months ago

    Copy this into a new notepad file:

    <?php phpinfo(); ?>

    Save as ‘info.php’
    put into the wp directory on your machine then use your browser to access it.

    Thread Starter taysay

    (@taysay)

    18 years, 10 months ago

    hi dear podz
    I do that as u said. On xp box it didn’t run, and I got following messege: “The Page Cannot Be Displayed”.
    But it respond correctly on W2K box. But because of my poor knwoledge on PHP, I dont know what it means. The displayed page contains the following information:

    System Windows NT GATE 5.0 build 2195
    Build Date Dec 14 2004 17:46:48
    Server API CGI/FastCGI
    Virtual Directory Support enabled
    Configuration File (php.ini) Path C:\WINNT\php.ini
    PHP API 20020918
    PHP Extension 20020429
    Zend Extension 20021010
    Debug Build no
    Thread Safety enabled
    Registered PHP Streams php, http, ftp, compress.zlib

    This program makes use of the Zend Scripting Language Engine:
    Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies

    ——————————————————————————–

    PHP Credits

    ——————————————————————————–

    Configuration
    PHP Core
    Directive Local Value Master Value
    allow_call_time_pass_reference On On
    allow_url_fopen On On
    always_populate_raw_post_data Off Off
    arg_separator.input & &
    arg_separator.output & &
    asp_tags Off Off
    auto_append_file no value no value
    auto_prepend_file no value no value
    browscap no value no value
    default_charset no value no value
    default_mimetype text/html text/html
    define_syslog_variables Off Off
    disable_classes no value no value
    disable_functions no value no value
    display_errors On On
    display_startup_errors Off Off
    doc_root no value no value
    docref_ext no value no value
    docref_root no value no value
    enable_dl On On
    error_append_string no value no value
    error_log no value no value
    error_prepend_string no value no value
    error_reporting 341 341
    expose_php On On
    extension_dir ./ ./
    file_uploads On On
    gpc_order GPC GPC
    highlight.bg #FFFFFF #FFFFFF
    highlight.comment #FF8000 #FF8000
    highlight.default #0000BB #0000BB
    highlight.html #000000 #000000
    highlight.keyword #007700 #007700
    highlight.string #DD0000 #DD0000
    html_errors On On
    ignore_repeated_errors Off Off
    ignore_repeated_source Off Off
    ignore_user_abort Off Off
    implicit_flush Off Off
    include_path .;c:\php4\pear .;c:\php4\pear
    log_errors Off Off
    log_errors_max_len 1024 1024
    magic_quotes_gpc On On
    magic_quotes_runtime Off Off
    magic_quotes_sybase Off Off
    max_execution_time 30 30
    max_input_time 60 60
    open_basedir no value no value
    output_buffering no value no value
    output_handler no value no value
    post_max_size 8M 8M
    precision 12 12
    register_argc_argv On On
    register_globals Off Off
    report_memleaks On On
    safe_mode Off Off
    safe_mode_exec_dir no value no value
    safe_mode_gid Off Off
    safe_mode_include_dir no value no value
    sendmail_from me@localhost.com me@localhost.com
    sendmail_path no value no value
    serialize_precision 100 100
    short_open_tag On On
    SMTP localhost localhost
    smtp_port 25 25
    sql.safe_mode Off Off
    track_errors Off Off
    unserialize_callback_func no value no value
    upload_max_filesize 2M 2M
    upload_tmp_dir C:\PHP\uploadtemp C:\PHP\uploadtemp
    user_dir no value no value
    variables_order EGPCS EGPCS
    xmlrpc_error_number 0 0
    xmlrpc_errors Off Off
    y2k_compliance On On

    bcmath
    BCMath support enabled

    calendar
    Calendar support enabled

    com
    Directive Local Value Master Value
    com.allow_dcom Off Off
    com.autoregister_casesensitive On On
    com.autoregister_typelib Off Off
    com.autoregister_verbose Off Off
    com.typelib_file no value no value

    ctype
    ctype functions enabled

    ftp
    FTP support enabled

    mysql
    MySQL Support enabled
    Active Persistent Links 0
    Active Links 0
    Client API version 3.23.49

    Directive Local Value Master Value
    mysql.allow_persistent On On
    mysql.connect_timeout 60 60
    mysql.default_host no value no value
    mysql.default_password no value no value
    mysql.default_port no value no value
    mysql.default_socket no value no value
    mysql.default_user no value no value
    mysql.max_links Unlimited Unlimited
    mysql.max_persistent Unlimited Unlimited
    mysql.trace_mode Off Off

    odbc
    ODBC Support enabled
    Active Persistent Links 0
    Active Links 0
    ODBC library Win32

    Directive Local Value Master Value
    odbc.allow_persistent On On
    odbc.check_persistent On On
    odbc.default_db no value no value
    odbc.default_pw no value no value
    odbc.default_user no value no value
    odbc.defaultbinmode return as is return as is
    odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes
    odbc.max_links Unlimited Unlimited
    odbc.max_persistent Unlimited Unlimited

    overload
    User-Space Object Overloading Support enabled

    pcre
    PCRE (Perl Compatible Regular Expressions) Support enabled
    PCRE Library Version 4.5 01-December-2003

    session
    Session Support enabled
    Registered save handlers files user

    Directive Local Value Master Value
    session.auto_start Off Off
    session.bug_compat_42 On On
    session.bug_compat_warn On On
    session.cache_expire 180 180
    session.cache_limiter nocache nocache
    session.cookie_domain no value no value
    session.cookie_lifetime 0 0
    session.cookie_path / /
    session.cookie_secure Off Off
    session.entropy_file no value no value
    session.entropy_length 0 0
    session.gc_divisor 100 100
    session.gc_maxlifetime 1440 1440
    session.gc_probability 1 1
    session.name PHPSESSID PHPSESSID
    session.referer_check no value no value
    session.save_handler files files
    session.save_path C:\PHP\sessiondata C:\PHP\sessiondata
    session.serialize_handler php php
    session.use_cookies On On
    session.use_only_cookies Off Off
    session.use_trans_sid Off Off

    standard
    Regex Library Bundled library enabled
    Dynamic Library Support enabled
    Internal Sendmail Support for Windows enabled

    Directive Local Value Master Value
    assert.active 1 1
    assert.bail 0 0
    assert.callback no value no value
    assert.quiet_eval 0 0
    assert.warning 1 1
    auto_detect_line_endings 0 0
    default_socket_timeout 60 60
    safe_mode_allowed_env_vars PHP_ PHP_
    safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
    url_rewriter.tags a=href,area=href,frame=src,input=src,form=,fieldset= a=href,area=href,frame=src,input=src,form=,fieldset=
    user_agent no value no value

    tokenizer
    Tokenizer Support enabled

    wddx
    WDDX Support enabled
    WDDX Session Serializer enabled

    xml
    XML Support active
    XML Namespace Support active
    EXPAT Version 1.95.6

    zlib
    ZLib Support enabled
    Compiled Version 1.1.4
    Linked Version 1.1.4

    Directive Local Value Master Value
    zlib.output_compression Off Off
    zlib.output_compression_level -1 -1
    zlib.output_handler no value no value

    Additional Modules
    Module Name

    Environment
    Variable Value
    ALLUSERSPROFILE C:\Documents and Settings\All Users
    CommonProgramFiles C:\Program Files\Common Files
    COMPUTERNAME GATE
    ComSpec C:\WINNT\system32\cmd.exe
    CONTENT_LENGTH 0
    GATEWAY_INTERFACE CGI/1.1
    HTTPS off
    HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */*
    HTTP_ACCEPT_LANGUAGE en-us
    HTTP_CONNECTION Keep-Alive
    HTTP_HOST localhost
    HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0; .NET CLR 1.1.4322)
    HTTP_ACCEPT_ENCODING gzip, deflate
    INSTANCE_ID 1
    LOCAL_ADDR 127.0.0.1
    NUMBER_OF_PROCESSORS 1
    Os2LibPath C:\WINNT\system32\os2\dll;
    OS Windows_NT
    Path C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\ATI Technologies\ATI Control Panel
    PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
    PATH_INFO /wordpress/info.php
    PATH_TRANSLATED c:\inetpub\wwwroot\wordpress\info.php
    PROCESSOR_ARCHITECTURE x86
    PROCESSOR_IDENTIFIER x86 Family 15 Model 3 Stepping 4, GenuineIntel
    PROCESSOR_LEVEL 15
    PROCESSOR_REVISION 0304
    ProgramFiles C:\Program Files
    REMOTE_ADDR 127.0.0.1
    REMOTE_HOST 127.0.0.1
    REQUEST_METHOD GET
    SCRIPT_NAME /wordpress/info.php
    SERVER_NAME localhost
    SERVER_PORT 80
    SERVER_PORT_SECURE 0
    SERVER_PROTOCOL HTTP/1.1
    SERVER_SOFTWARE Microsoft-IIS/5.0
    SystemDrive C:
    SystemRoot C:\WINNT
    TEMP C:\WINNT\TEMP
    TMP C:\WINNT\TEMP
    USERPROFILE C:\Documents and Settings\Default User
    windir C:\WINNT

    PHP Variables
    Variable Value
    _SERVER[“ALLUSERSPROFILE”] C:\\Documents and Settings\\All Users
    _SERVER[“CommonProgramFiles”] C:\\Program Files\\Common Files
    _SERVER[“COMPUTERNAME”] GATE
    _SERVER[“ComSpec”] C:\\WINNT\\system32\\cmd.exe
    _SERVER[“CONTENT_LENGTH”] 0
    _SERVER[“GATEWAY_INTERFACE”] CGI/1.1
    _SERVER[“HTTPS”] off
    _SERVER[“HTTP_ACCEPT”] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */*
    _SERVER[“HTTP_ACCEPT_LANGUAGE”] en-us
    _SERVER[“HTTP_CONNECTION”] Keep-Alive
    _SERVER[“HTTP_HOST”] localhost
    _SERVER[“HTTP_USER_AGENT”] Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0; .NET CLR 1.1.4322)
    _SERVER[“HTTP_ACCEPT_ENCODING”] gzip, deflate
    _SERVER[“INSTANCE_ID”] 1
    _SERVER[“LOCAL_ADDR”] 127.0.0.1
    _SERVER[“NUMBER_OF_PROCESSORS”] 1
    _SERVER[“Os2LibPath”] C:\\WINNT\\system32\\os2\\dll;
    _SERVER[“OS”] Windows_NT
    _SERVER[“Path”] C:\\WINNT\\system32;C:\\WINNT;C:\\WINNT\\System32\\Wbem;C:\\Program Files\\ATI Technologies\\ATI Control Panel
    _SERVER[“PATHEXT”] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
    _SERVER[“PATH_INFO”] /wordpress/info.php
    _SERVER[“PATH_TRANSLATED”] c:\\inetpub\\wwwroot\\wordpress\\info.php
    _SERVER[“PROCESSOR_ARCHITECTURE”] x86
    _SERVER[“PROCESSOR_IDENTIFIER”] x86 Family 15 Model 3 Stepping 4, GenuineIntel
    _SERVER[“PROCESSOR_LEVEL”] 15
    _SERVER[“PROCESSOR_REVISION”] 0304
    _SERVER[“ProgramFiles”] C:\\Program Files
    _SERVER[“REMOTE_ADDR”] 127.0.0.1
    _SERVER[“REMOTE_HOST”] 127.0.0.1
    _SERVER[“REQUEST_METHOD”] GET
    _SERVER[“SCRIPT_NAME”] /wordpress/info.php
    _SERVER[“SERVER_NAME”] localhost
    _SERVER[“SERVER_PORT”] 80
    _SERVER[“SERVER_PORT_SECURE”] 0
    _SERVER[“SERVER_PROTOCOL”] HTTP/1.1
    _SERVER[“SERVER_SOFTWARE”] Microsoft-IIS/5.0
    _SERVER[“SystemDrive”] C:
    _SERVER[“SystemRoot”] C:\\WINNT
    _SERVER[“TEMP”] C:\\WINNT\\TEMP
    _SERVER[“TMP”] C:\\WINNT\\TEMP
    _SERVER[“USERPROFILE”] C:\\Documents and Settings\\Default User
    _SERVER[“windir”] C:\\WINNT
    _SERVER[“PHP_SELF”] /wordpress/info.php
    _SERVER[“argv”] Array
    (
    )

    _SERVER[“argc”] 0
    _ENV[“ALLUSERSPROFILE”] C:\\Documents and Settings\\All Users
    _ENV[“CommonProgramFiles”] C:\\Program Files\\Common Files
    _ENV[“COMPUTERNAME”] GATE
    _ENV[“ComSpec”] C:\\WINNT\\system32\\cmd.exe
    _ENV[“CONTENT_LENGTH”] 0
    _ENV[“GATEWAY_INTERFACE”] CGI/1.1
    _ENV[“HTTPS”] off
    _ENV[“HTTP_ACCEPT”] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, */*
    _ENV[“HTTP_ACCEPT_LANGUAGE”] en-us
    _ENV[“HTTP_CONNECTION”] Keep-Alive
    _ENV[“HTTP_HOST”] localhost
    _ENV[“HTTP_USER_AGENT”] Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0; .NET CLR 1.1.4322)
    _ENV[“HTTP_ACCEPT_ENCODING”] gzip, deflate
    _ENV[“INSTANCE_ID”] 1
    _ENV[“LOCAL_ADDR”] 127.0.0.1
    _ENV[“NUMBER_OF_PROCESSORS”] 1
    _ENV[“Os2LibPath”] C:\\WINNT\\system32\\os2\\dll;
    _ENV[“OS”] Windows_NT
    _ENV[“Path”] C:\\WINNT\\system32;C:\\WINNT;C:\\WINNT\\System32\\Wbem;C:\\Program Files\\ATI Technologies\\ATI Control Panel
    _ENV[“PATHEXT”] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
    _ENV[“PATH_INFO”] /wordpress/info.php
    _ENV[“PATH_TRANSLATED”] c:\\inetpub\\wwwroot\\wordpress\\info.php
    _ENV[“PROCESSOR_ARCHITECTURE”] x86
    _ENV[“PROCESSOR_IDENTIFIER”] x86 Family 15 Model 3 Stepping 4, GenuineIntel
    _ENV[“PROCESSOR_LEVEL”] 15
    _ENV[“PROCESSOR_REVISION”] 0304
    _ENV[“ProgramFiles”] C:\\Program Files
    _ENV[“REMOTE_ADDR”] 127.0.0.1
    _ENV[“REMOTE_HOST”] 127.0.0.1
    _ENV[“REQUEST_METHOD”] GET
    _ENV[“SCRIPT_NAME”] /wordpress/info.php
    _ENV[“SERVER_NAME”] localhost
    _ENV[“SERVER_PORT”] 80
    _ENV[“SERVER_PORT_SECURE”] 0
    _ENV[“SERVER_PROTOCOL”] HTTP/1.1
    _ENV[“SERVER_SOFTWARE”] Microsoft-IIS/5.0
    _ENV[“SystemDrive”] C:
    _ENV[“SystemRoot”] C:\\WINNT
    _ENV[“TEMP”] C:\\WINNT\\TEMP
    _ENV[“TMP”] C:\\WINNT\\TEMP
    _ENV[“USERPROFILE”] C:\\Documents and Settings\\Default User
    _ENV[“windir”] C:\\WINNT
    ””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””’
    So what I had to do now?

    johnfallen

    (@johnfallen)

    18 years, 10 months ago

    Hey great people. I KNOW this must be a boring topic for every one but too the poor people like myself that are haveing the same prolblems as taysay.

    I know that msSQL is operating properly. I connect to it with the mySQL Administraotr (from mySQL.com) PHP give me my info.php page Just great.

    AND I KNOW my wp-config.php is accurate.

    So WHAT the heck.

    Should I change the php.ini file to read:
    mysql.default_host = localhost?

    Still not doing the trick.

    Flavores:
    win2003 (all latest paches)
    php 4.3.11
    WP 1.5.1.2

    maxb

    (@maxb)

    18 years, 10 months ago

    Yes, I am also having the same problem here. ANY help would me much appriciated. Same criteria as above. MySql is talking with PHP.
    Everything is “fine” except for the problem of connecting to the database. I am running win server 2003, with MySql and PHP on the same computer. Everything is accurate. My circumstances are almost, if not exact to johnfallen.

    Thank You, Max

    Mark (podz)

    (@podz)

    18 years, 10 months ago

    WP on IIS

    http://wordlog.com/index.php?p=32

    http://www.simmonsconsulting.com/wordpress?p=160

    johnfallen

    (@johnfallen)

    18 years, 10 months ago

    http://www.apachefriends.org/en/xampp.html –

    This dosnt solve the issue. I did turn off IIS, installed xampp, configed the new instance of mySQL, and BAM. WP working great.

    I DID NOT WANT TO USE Apache (nothing against it, just wanted to use ColdFusion and WP togeather under IIS), but after reading the problems with permalinking and all the likes, in the very informative articles listed above, i decided, heck with IIS 6. I just want WP running for my boss (how much of our world is getting things done for the boss?).

    Hope the weeked wad great.

    mythmenot

    (@mythmenot)

    18 years, 10 months ago

    I, too, had the standard MySQL not found error message, as quoted above. Turns out I DID have to replace “localhost” with the actual location of the MySQL server. Then installation worked like a charm!

    jananthadev

    (@jananthadev)

    18 years, 8 months ago

    Hi guys…i have apache 2 , PHP 5.0.3, and MySQL Server 4.1 running on my WinXp professional machine..

    THe problem is it doesnt give any errors..i installed WP succesfully..but when i write new pages and try to see them using my browser it directs to my wordpress directory root where i can really see the files !!! This shouldnt be happening and also i tried to change the URI location from http://localhost/wordpress to http://localhost/wordpress/index.php and the main homepage just appeared with the text but with NO graphics..can somebody please help me on this..im really stuck..

    jananthadev

    (@jananthadev)

    18 years, 8 months ago

    Also in addition to my previous question…
    When i installed WordPressafter it gives the user name and a password … its says to logging and after i submit the username and the password…it takes me to the root where WP resides on my machine..there i can see all my files…but actually it should take me to the wp-edit.php isnt it.! please help

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Installation problem, PHP, MYSQL on local machine’ is closed to new replies.