• Resolved floppy

    (@floppy)


    My database details are:
    Database Name: floppydb
    Server Name: mysql245
    IP Address: 213.171.218.245
    Database Users for floppydb: floppy

    on wp-config.php i have added:

    define(‘DB_NAME’, ‘floppydb’);
    define(‘DB_USER’, ‘floppy’);
    define(‘DB_PASSWORD’, ‘xxxxxx’);
    define(‘DB_HOST’, ‘mysql245’);

    But i get the:
    ‘Error establishing a database connection’

    i have tried many variations and followed other topics on here but i don’t know what to do.

Viewing 9 replies - 1 through 9 (of 9 total)
  • Shouldn’t there be more to your Server name, then just: mysql245? Like, mysql245.hostersdomain.com, or, mysql245.hostersserverdomain.com, or something of that nature..?

    spencerp

    Thread Starter floppy

    (@floppy)

    i would have thought – yes buti read this:
    https://www.ads-software.com/support/topic/76437
    where the person put in their mysql245 name and they said it worked.

    i have tried putting in: 213.171.218.245
    but that doesn’t work either

    Well, I can tell ya from experience here, after doing X number of WordPress installs, each HOST NAME might vary from time to time.

    Even if it’s on the same host, as three previous ones I had, sometimes their HOST NAME varied.. One thing I started doing, and it seems to help.. Is, log into your phpMyAdmin, and *usually* up top, after being logged in, after going to view your Database(s).. it should show your DB HOST name up there..

    No matter what it is, see what’s up there, and let us know ok? Or, maybe your DB USER name isn’t quite right, or, your DB Password, or something..

    That message usually means, what it says.. it’s not connecting some how.. so, please check things I mentioned above once.. then report back ok.. =)

    spencerp

    Thread Starter floppy

    (@floppy)

    hi spencerp
    thanks for replying.
    got shell access – tried typing in phpMyAdmin – no such command.
    put a info.php file onto server – comes up with info but not sure what to look for. (it does say it has mod rewrite a s a module – which was important somewhere along the line).

    as for pwd + details. they are as they are at the top here. I don’t know if i am using the wrong pwd for the wrong bit – its all named a bit differently so you never know for certain what goes where.

    is there information here:
    https://www.floppyrecords.co.uk/info.php
    that helps?

    and thanks again.
    tom

    Thread Starter floppy

    (@floppy)

    has anyone installed wordpress onto fasthosts successfully?

    You php info looks okay. One of two things could be wrong!
    1. Your database server is actually down.
    2. You have the wrong information in your wp-config.php file.

    If you are not sure of your database host or database name then ask your host company to help with that information. Also note you need a Linux account and if you have the Home plan, you have to pay extra for MySQL database. If I’ve got it correct, here’s the link to their support: https://www.fasthosts.co.uk/support/

    If you do have access to something like phpMyAdmin then you can try to maintain your database. At the top of the phpMyAdmin screen it usually says what the database server name is. Most times it is localhost.

    Try
    define('DB_NAME', 'floppydb_mysql245');
    instead of
    define('DB_NAME', 'floppydb');

    Thread Starter floppy

    (@floppy)

    its working!
    thanks for everyone’s help. i phoned fasthosts. it was all my fault, of course, i had my password wrong.
    anyway.
    the answer was:

    define(‘DB_NAME’, ‘floppydb’);
    define(‘DB_USER’, ‘floppy’);
    define(‘DB_PASSWORD’, ‘xxxxxx’);
    define(‘DB_HOST’, ‘213.171.218.245’);

    which is exactly the information they give about your database in fasthosts admin.

    Glad to hear it’s working! =) Can ya change the status of this to [Resolved] now please?… ??

    spencerp

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Installing WordPress on Fasthosts’ is closed to new replies.