Godaddy SQL problem

  • nickeaston

    (@nickeaston)


    20 years ago

    My domain is hosted by Godaddy; SQL appears to be managed by a third party called Starfield Technologies and there is no choice for the created database–it’s the same as the username. The only choices are new table name and number of fields.

    The error message is: 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.

    Here are the customized script lines:
    <?php
    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘neaston’); // The name of the database
    define(‘DB_USER’, ‘neaston’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘********’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

Viewing 14 replies - 31 through 44 (of 44 total)

  • THANKS MACMANX!

    Now it’s saying the URL is forbidden, HELP!

    Moderator James Huff

    (@macmanx)

    What did you do before it said the URL was forbidding. Did you change any settings? Alter any files? Are we talking about an Error 403 Forbidden error? Please be as verbose as possible next time.

    5 minutes and I was up in my GoDaddy account. you just have to make sure to change the host from ‘localhost’ to whatever is in the control panel. Obviously change the other values of Username, Database Password, and Database name (same as username). Very Very Easy. Nice application, thanks.

    Hi, I am also trying to install WP on a godaddy.com server. I am very familiar with PHP and have installed WP on other servers before with no problems at all.

    I have modified the config file with the host name provided by godaddy, user, password & db name.

    But I get this message when going to the install.php file:

    “Your PHP installation appears to be missing the MySQL which is required for WordPress.”

    I used the phpMyAdmin installation on that server to create a table in the db and wrote a simple php script to make sure that the DB was indeed there and working correctly…which it is. The script I wrote connected to the db and pulled out the info from the database, so I don’t think there’s any issues with the database set up.

    Has anyone else had this problem and figured out why this message is coming up during the installation process?

    Thanks.

    I got the blog installed and working on GoDaddy.

    In case anyone else has this problem in the future, this is what I did. As I said above, I was sure that MySQL was installed and working on my server, so I commented out the following line out of the wp-settings.php file:

    if ( !extension_loaded(‘mysql’) )
    die( ‘Your PHP installation appears to be missing the MySQL which is required for WordPress.’ );

    (Lines 39 & 40 in the file. Add /* at the beginning, and */ at the end to comment out the line)

    Basically it skips over the part where it checks if the MySQL extension is loaded on the server. I’m not sure if there’s any issues with doing this, but the program now runs fine.

    Here is the error I keep getting when I try to Import CSV data file into the Godaddy MSSQLAdmin web system. It would not insert all data from the CSV file into all the table columns. I just could not figure it out. I am a first time user of the Godaddy MSSQLAdmin database System. Please help!

    Table : [hpc2005].[tbl_HeritagePres]
    Columns : [pgID], [siteName], [linkLabel], [linkOrder], [pgName], [pgCaption], [pgType], [pgLocation], [pgURL], [pgAssoc], [pgHeader], [pgContent], [appLink], [appCode], [navHeader], [dateUpdated]
    CSV file : HeritagePres8.csv
    Import Report : Import processed in 3.23 seconds
    18 rows have been inserted into [hpc2005].[tbl_HeritagePres]
    217 lines have been ignored

    Line 2 : wrong number of columns (line has been ignored)
    Line 3 : wrong number of columns (line has been ignored)
    Line 4 : wrong number of columns (line has been ignored)
    Line 5 : wrong number of columns (line has been ignored)
    Line 6 : wrong number of columns (line has been ignored)
    Line 7 : wrong number of columns (line has been ignored)
    Line 8 : wrong number of columns (line has been ignored)
    Line 9 : wrong number of columns (line has been ignored)
    Line 10 : wrong number of columns (line has been ignored)
    Line 11 : wrong number of columns (line has been ignored)
    Line 12 : wrong number of columns (line has been ignored)
    Line 13 : wrong number of columns (line has been ignored)
    Line 15 : wrong number of columns (line has been ignored)
    Line 16 : wrong number of columns (line has been ignored)
    Line 17 : wrong number of columns (line has been ignored)
    Line 18 : wrong number of columns (line has been ignored)
    Line 19 : wrong number of columns (line has been ignored)
    Line 20 : wrong number of columns (line has been ignored)
    Line 21 : wrong number of columns (line has been ignored)
    Line 22 : wrong number of columns (line has been ignored)

    Hey Stangill,

    I did exactly what you said to do regarding the wp-settings file. And i still am recieving the message:

    “Your PHP installation appears to be missing the MySQL which is required for WordPress.”

    My wp-config.php file is correct i believe:define(‘DB_NAME’, ‘WordPress56’); define(‘DB_USER’, ‘WordPress56’);
    define(‘DB_PASSWORD’, ‘********’);
    define(‘DB_HOST’, ‘mysql59.secureserver.net’);

    I transfered all the files using Smart FTP:

    My Login: SnoBrdr56
    Password: ********

    Can anyone help???????

    i had a similar problem sometime back, and i finally found the problem.

    there was a problem with their mysql servers.

    good luck guys

    bmoseley07

    (@bmoseley07)

    Brilliant, stangill. that was the exact problem I had. I think wordpress should put that in their instructions or FAQ or something.

    Just adding to those reporting godaddy probs with wordpress. No solutions yet. In case it helps others troubleshooting, here’s what it is.

    After install I get this error trying activate the blog:
    “There doesn’t seem to be a wp-config.php file. I need this before we can get started. Need more help? We got it. You can create a wp-config.php file through a web interface, but this doesn’t work for all server setups. The safest way is to manually create the file.”

    -Linux economy package
    modified config.php to read correctly (I believe)
    define(‘DB_NAME’, ‘niceguy’);
    define(‘DB_USER’, ‘niceguy’);
    define(‘DB_PASSWORD’, ‘…….’);
    define(‘DB_HOST’, ‘mysq17.secureserver.net’);

    Tried stangill’s mod to wp-settings but no change

    Tried deleting and reinstalling using ws-ftp instead of dreamweaver or control panel — no change

    Called tech support; they said they weren’t trained to help

    tried creating a new database — no change

    I’m out of ideas.

    Update — I gave it one more try, this time with success. I did another clean install, but first I deleted the first two databases that didn’t work and created a third. Other procedures were the same, and now it seems to work. At least I have a dashboard (haven’t gotten into plugins yet.) From this I ‘m guessing that some database servers at godaddy work with wordpress and some don’t.

    OK, I’m not new to wordpress, I switched to godaddy from namesecure. I set up a MySql database, uploaded the files and I’m getting a bizarre 404 error message. It looks like the Internet explorer 404 page, not a real godaddy one. Check out:
    manintheceiling.com/blog/wp-admin/install.php.
    Anything in this “blog” directory where I put my wordpress files simply does not work. Any suggestions?

    I just found the post from stangill suggesting I comment out the line in wp-admin.php which produces the error message, and I (apparently) had a good wp install. Time to do some more testing, but all seems good for now. Thanks, stangill!

Viewing 14 replies - 31 through 44 (of 44 total)
  • The topic ‘Godaddy SQL problem’ is closed to new replies.