Godaddy install woes

  • nodaddy

    (@nodaddy)


    19 years, 3 months ago

    Hello,

    Have been pouring over the many previous posts on this topic. Have tried everything listed in all that I’ve read and still no help. At this point the error message says:
    ————————
    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 WordPress451 database.

    ———————–

    I think I have my wp-config file edited correctly at this time.

    ‘Localhost’ has been edited to reflect the proper mysqlXXX.secureserver.net.

    I switched from Windows hosting to Linux php.

    Mysql is setup. All names are correct. I have given the DB a unique name.

    Here are the edited parts of the file sans password:

    <?php
    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘WordPress451’); // The name of the database
    define(‘DB_USER’, ‘Montag451’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘XXXXXXX’); // …and password
    define(‘DB_HOST’, ‘mysql289.secureserver.net’); // 99% chance you won’t need to change this value

    Any ideas?

    Thanks,

    John

Viewing 7 replies - 1 through 7 (of 7 total)
  • MichaelH

    (@michaelh)

    19 years, 3 months ago

    Database name and username are case sensitive.

    Can you use phpMyAdmin to edit the database:

    Accessing phpMyAdmin on a Godaddy hosted account
    1. Login to your GoDaddy account
    2. Hover your mouse over Hosting & Servers, then click on My Hosting Account–that causes your existing hosting accounts to display.
    3. Under the Control Panel column next to your domain, click on Open which opens the Hosting Manager Control Panel.
    4. On the menu on the left, click on Databases and then MySQL–a list of your databases will display.
    5. On the line that shows your database, under the Manager column, click on Open Manager–this will launch the login to phpMyAdmin.
    6. Enter your database user name and password.
    7. You then should see your database(s).

    This will confirm, outside of WordPress, that your username and password are working.

    interlude22

    (@interlude22)

    19 years, 3 months ago

    Hello, installed a wordpress onto a godaddy server the other day, got exactly the same problem. The solution:

    You have to define the DB_HOST to the godaddy mysql details you would have been given when setting up the database through the back end of your server.

    It may be something like “****mysql17.secureserver.net”

    I did the stars because i didnt want to publish this address, not use if it could be ripped off or not

    Then go through the standard procedure and you should be good to rock and roll!

    Thread Starter nodaddy

    (@nodaddy)

    19 years, 3 months ago

    Confirmed, MichaelH. They are working.

    Thread Starter nodaddy

    (@nodaddy)

    19 years, 3 months ago

    Thanks to both of you for trying to help.

    interlude22,

    I am unable to find any details like some sort of prefix to go in front of mysqlXXX.secureserver.net.

    I don’t ever remember seeing any whenever I set it up either. Were they letters or numbers?

    I even went in and set permissions on the root folder to 777 and did a total reinstall, as suggested in another post. No good there either.

    Interestingly though, I received an unsolicited phone call from GoDaddy support this evening. I had not yet resorted to calling them for help (but it was my next thing to do). So I guess either they were watching my account and seeing me founder at WP installation, or they read this forum and picked out my account by the details I posted here.

    At the time I was far from my computer and couldn’t benefit from their help, but will call tomorrow and see what they can do. Will let you know how it turns out. Surely they can tell me what I’ve done wrong.

    Thanks again,

    John

    Thread Starter nodaddy

    (@nodaddy)

    19 years, 3 months ago

    Okay. Update here. Called Godaddy support today and I’m not sure what they did, but it’s working okay now. Even upgraded my hosting account from “free” to economy later to get rid of that obnoxious banner. Still it works.

    John

    Heartland

    (@heartland)

    18 years, 10 months ago

    Mine is set at mysql97.secureserver.net and cannot connect to the database with a Godaddy account.
    What is with this thing??

    macmooreno

    (@macmooreno)

    18 years, 10 months ago

    I’ve found it’s easiest to just use WordPress as it’s run through GoDaddy’s “Metropolis.” Check it out! Worth the extra bucks…

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

The topic ‘Godaddy install woes’ is closed to new replies.