Cannot connect to database Server 2003 IIS 6.0

  • homersim2600

    (@homersim2600)


    21 years, 5 months ago

    Hello, 5-minutes has turned into 6-hours! I cannot connect to the database; I get this error

    Begin error…
    Error establishing a database connection! This probably means that the connection information in your wp-config.php file is incorrect. Double check it and try again.

    Are you sure you have the correct user/password?
    Are you sure that you have typed the correct hostname?
    Are you sure that the database server is running?
    WordPress Support Forums
    End Error…

    From what I understand, from reading the documentation from MySql, the database must be available, and a user must be specified, BEFORE a connection is attempted. This is my setup:

    Begin Setup…
    Windows Server 2003
    IIS Version 6.0
    MySql Version 4.1.9
    PHP Version 4.3.10.10
    End Setup…

    I have checked, and double checked the username and the password. Does the database, in fact, have to exist BEFORE the wp-config.php file is created, or what?? If it does have to exist, then what are the table names??? Is there a way to just use a database file instead of relying on MySql??? Please help the frustrated. Thank you.

    P.S. I have read all of the other postings regarding this problem; still having problems…

    Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator James Huff

    (@macmanx)

    21 years, 5 months ago

    You only have to create the database first. This is so you can include the DB_NAME, DB_USER, DB_PASSWORD, and DB_HOST values in wp-config.php. Running install.php (after wp-config.php is setup properly) creates the tables.

    http://codex.wordpress.org/Installing_WordPress

    WordPress requires MySQL.

    Thread Starter homersim2600

    (@homersim2600)

    21 years, 5 months ago

    Thank you. I finally figured it all out at about 1am lastnight! hehe. What can I say, this program is just too good to put away for the night…

    I should point out that my main problem was that I was using MySQL 4.1. which does not make it’s defaul directory in c:\mysql . This appears to be a big problem for this program overall. In fact, once I got the whole thing running, I then went back and reinstalled MySQL 4.1 to prove my assumptions.

    I have spent the greater part of the day writing a VB program which will automatically create the connection (i.e. the database, and user/pass). It will check to make sure that the directories are in the appropriate place and will notify the user if they are not. I thought about adding the function which would create the wp-config.php file for the user, but perhaps in the next release this will happen.

    I am going to upload the file to my server at about 8:30p.m. Eastern Standard Time, and at this time I will post a link to download the file. The source code will be included in the zip, so just look for the setup.exe file after extracting and you will be all set.

    I just wanted to say that even though my frustrations were nearing the point of total, and complete, negligence of this program, It was NOT WordPress that was at fault in the end–as much as I thought it was…

    Thank you again…

    Bryan P. Dyess

    Thread Starter homersim2600

    (@homersim2600)

    21 years, 5 months ago

    Here is the link to the program I wrote to help simplify installation a bit more.

    http://journal.veryfinephotos.com/mysqlconfigure.zip

    Let me know if you have problems via my journal ok??? (the journal is at the link minus the file for those that don’t know…

    Bryan P. Dyess

    steve8004

    (@steve8004)

    20 years, 11 months ago

    Brian:

    I tried to download your application, but it doesn’t work. Can you email me a copy at Steve@steveeisenberg.com or use http://www.yousendit.com ?

    Many thanks,
    Steve

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Cannot connect to database Server 2003 IIS 6.0’ is closed to new replies.