• Resolved shikensha

    (@shikensha)


    I just ordered the Home Hosting package from Daily.co.uk and also purchased an SQL database to setup my WordPress blog but, I’m currently stuck on step 2 of the installation guide.

    After creating a database in the control panel I login via phpMyAdmin 2.9.2 but, I can’t find where the user privileges are set.

    If I try to run the following wp-config.php file, I get the message, “Error establishing a database connection.” Could any Daily.co.uk users let me know what I’m doing wrong please?

    =======

    <?php
    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘shikensha_1’); // The name of the database
    define(‘DB_USER’, ‘shikensha_1’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘apassword’); // …and password
    define(‘DB_HOST’, ‘web1.hosting.hostvue.com’); // 99% chance you won’t need to change this value
    define(‘DB_CHARSET’, ‘utf8’);
    define(‘DB_COLLATE’, ”);

    // You can have multiple installations in one database if you give each a unique prefix
    $table_prefix = ‘wp_’; // Only numbers, letters, and underscores please!

    // Change this to localize WordPress. A corresponding MO file for the
    // chosen language must be installed to wp-content/languages.
    // For example, install de.mo to wp-content/languages and set WPLANG to ‘de’
    // to enable German language support.
    define (‘WPLANG’, ”);

    /* That’s all, stop editing! Happy blogging. */

    define(‘ABSPATH’, dirname(__FILE__).’/’);
    require_once(ABSPATH.’wp-settings.php’);
    ?>

Viewing 10 replies - 1 through 10 (of 10 total)
  • What is the error message?
    Also, you do NOT set the privileges in phpMyadmin… you create the user and set the privileges in the control panel. (on many host you can skip that step)

    Are you sure that DB host here is web1.hosting.hostvue.com ?

    define(‘DB_HOST’, ‘web1.hosting.hostvue.com’); // 99% chance you won’t need to

    Try putting “localhost” there without ” ”

    Regards
    [sig moderated]

    Thread Starter shikensha

    (@shikensha)

    Moshu,
    Yes that’s what I thought so I’m using the user name and database name created in the cpanel. For some when I try running the script afterwards, it says “Error establishing a database connection.”

    Dinzan,
    I’m pretty sure it is. After logging into phpMyAdmin, I see something on the main page that says, “User: shikensha@web1.hosting.hostvue.com”.

    I could try asking someone to try and configure all this for me but, I want to know how to do it myself in case I ever need to deploy it again.

    shikensha,
    I had the same problem with my host, so I changed the db_host to the ip-adress of the server. Worked like a charm for me.

    define(‘DB_HOST’, ‘192.xx.x.xx’);

    shikensha,

    Anyways, Just try it once 😉 and lemme know..

    Thread Starter shikensha

    (@shikensha)

    Thank you for the fast feedback everyone but it looks like I just couldn’t follow instructions…

    I was trying to access “http://www.bakashikensha.com&#8221; to run the install script and that’s why it wasn’t running correctly. I was presuming the script was running since I was getting that database error message.

    After using the correct URL “http://www.bakashikensha.com/wp-admin/install.php&#8221;, it’s all working fine now ^^;

    Was worried I had wasted money on a rubbish host there (first time setting up my own domain and site!)…

    Cool !! Glad to know that

    Thread Starter shikensha

    (@shikensha)

    OK, I actually had the wrong DB_HOST name… The host admins at Daily just corrected the script for me. It should have been the same as the server name which was simply “db1” in this case and not “web1.hosting.hostvue.com”.

    Then you should mark this thread as resolved ( at the very top )

    Hi all,

    I run the Support team at Daily and we’ve had this one crop up a few times with db issues, so hope this helps:

    It’s normally this line:

    “define(‘DB_HOST’, ‘web1.hosting.hostvue.com’); // 99% chance you won’t need to change this value”

    It’ll often contain “localhost” or another value, but this should infact just be “db1”

    If in doubt of any settings, just check in your Daily Control Panel under the “MySQL” section to confirm database name, username, server etc. or give us a call/email and we can take a look.

    Ray

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

The topic ‘Database/User setup possible on Daily.co.uk?’ is closed to new replies.