Installation problem, PHP, MYSQL on local machine
-
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:
https://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.
-
I use XP Home and xampp very successfully so if this gets too much, stop IIS and go get xampp.
https://www.apachefriends.org/en/xampp.htmlCan you do a phpinfo and check that all the parts are talking to each other ?
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.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.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.zlibThis 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 [email protected] [email protected]
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 Onbcmath
BCMath support enabledcalendar
Calendar support enabledcom
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 valuectype
ctype functions enabledftp
FTP support enabledmysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.49Directive 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 Offodbc
ODBC Support enabled
Active Persistent Links 0
Active Links 0
ODBC library Win32Directive 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 Unlimitedoverload
User-Space Object Overloading Support enabledpcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 4.5 01-December-2003session
Session Support enabled
Registered save handlers files userDirective 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 Offstandard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Internal Sendmail Support for Windows enabledDirective 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 valuetokenizer
Tokenizer Support enabledwddx
WDDX Support enabled
WDDX Session Serializer enabledxml
XML Support active
XML Namespace Support active
EXPAT Version 1.95.6zlib
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no valueAdditional Modules
Module NameEnvironment
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:\WINNTPHP 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?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.2Yes, 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
https://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.
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!
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 https://localhost/wordpress to https://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..
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
- The topic ‘Installation problem, PHP, MYSQL on local machine’ is closed to new replies.