Support » Installation » [Resolved] Error establishing a database connection

[Resolved] Error establishing a database connection

  • I am quite sure you guys get tired of seeing posts about this topic but I can’t seem to find the specific information I need. After not being able to successfully install WP, I contacted our web host and got from them both the database IP address and the Server name as well as verified the assigned user name, password and database name. I am able to get into the database with this information using SQL Server Management Studio Express so it all appears to be correct. However, when I run install.php with that same information, I get the apparently famous error – “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 (known good server name).”

    Any suggestions??

Viewing 15 replies - 1 through 15 (of 29 total)
  • Double and triple check your config file.. sometimes a small _space or a dot can make the whole difference…

    I am able to get into the database with this information using SQL Server Management Studio Express so it all..

    Are you sure you are using MySQL and not SQL ??

    i have double and triple checked the config file. It could be a problem with SQL vs My SQL. I will have to get more information on that. Are the wp-config.php and the install.php SQL or MySQL specific???

    Yes …
    The whole WordPress is MySQL specific (as far as I know)

    Thanks a lot – I just talked to our webhost and our plan with them had not been updated to include a MySQL database. I think it is just a legacy issue because as soon as I called them they offered us a new plan with both SQL and MySQL databases at the same cost with a free porting of our site. Hopefully, this well resolve any issues that I am having.

    Great support forum!!!

    well.. If you will move to MySQL it will SURELY resolve your problem 🙂

    Hey – got the MySQL Upgrade which turned out to be the problem. However, I am now at the next apparent hurdle –

    Can’t select database
    We were able to connect to the database server (which means your username and password is okay) but not able to select the 50726_Wordpress database.

    Are you sure it exists? – YES – Would put a screenshot in here if I could from MySQL Manager. In answer to the question below, the 50726 was the assigned prefix for the database when it was created.

    Does the user 1679575 have permission to use the 50726_Wordpress database? YES – Permissions are set to ALL

    On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem? The name is exactly as it appears above. I have confirmed that the database is up and running from the MySQL manager and PHPAdmin.

    This shouldn’t be that hard ;)!!!!!!!!!

    I just went through the same thing! This has never happened before, but here is what it is. You know when you filled out the form with your username, then it could connect, but afterward you couldn’t? Somehow, the info from that form didn’t make it to the config file. Look at your wp-config.php file and make sure that your username is correct there, mine wasn’t, it left off the prefix that the host adds. Check to see what the actual username is, then fix it in the config file.

    this doesn’t seem to be the issue – I have never gotten past this point in the installation of the databases. I have checked the wp-config.php file many, many times. I have checked for spaces, typos, etc. and can’t find anything. I just downloaded the wp-config.php file to see if it was being altered and it doesn’t seem to be. I know that the database exists and I know that the user has access to it, I can get to it from the MySQL manager provided by my webhost. So much for the five minute install.

    I am pretty sure it is some little something, I have installed WP dozens of times, but was just installing the 2.7 beta3 to test some plugins and had the same problem, but mine was the prefix to the username. In that form you fill out, I had the prefix there, but it didn’t get put into the config file. All I can say is to make sure in your database control panel or whatever your host has, if it shows a list of databases and users, make sure there is no prefix missing in the config file, other than that, I don’t know. Does your host offer Fantastico Deluxe? That is the easiest way to install wordpress. Simple scripts works good too, but it is not as quick. Since I was installing the beta, it wasn’t available with Fantastico. Anyway, good luck!

    Did you checked for CAPITALS ?

    I did check for capitals and even deleted the database that I had created and changed it to all lowercase just to satisfy my own curiosity. I still received the same message back from the install.php. to make sure I wasn’t missing something, I even went back to a clean wp-config-sample.php file and re-entered the information. Still received the same result.

    Can’t select database
    We were able to connect to the database server (which means your username and password is okay) but not able to select the 50726_wordpress database.

    I know this database exists and that the user has ALL privileges. I am going to search some other forums as most threads on this topic seem to just end without anyone really describing a solution.

    just for grins, I even created a new user and granted all privileges. I still get the same error. This has to be something really goofy. Like I said, I can get to the database with PHPAdmin, I know it exists, I know I have access rights. This just doesn’t make sense.

    I guess it is time for a call to your host. I reviewed a few earlier posts with the same error message, and they all came down to
    a) DB not being there
    b) user not having all the privileges
    c) faulty setup of the DB by the host

    Since you are saying that a) and b) are eliminated as possible errors…

    I don’t even know what to ask the host at this point?? I have deleted and re-created the database several times with the same result. As with most hosts, as soon as you mention a third-party software application, they quickly state that they don’t offer any support. Are there specific questions that I should ask regarding the DB setup?

    I know they always blame third-party applications… however, the fact that they just recently added MySQL to your account and “ported” your site somewhere else — makes me think that the error must come from their end.

    Ask them if they can show you that it is possible to connect to the MySQL DB via a PHP script. Because with the data they provided, you can’t.

Viewing 15 replies - 1 through 15 (of 29 total)
  • The topic ‘[Resolved] Error establishing a database connection’ is closed to new replies.