• Hi all and nice to be part of the forum

    I Am trying to install wordpress on ym server. I created an sql database called WordPress, then created a new user Name: Gus Pass: jones, this is what it looks like in my server.
    Users in WordPress
    jones_Gus (Privileges: ALL PRIVILEGES)

    Connection Strings
    Perl $dbh = DBI->connect(“DBI:mysql:jones_Wordpress:localhost”,”jones_Gus”,”<PASSWORD HERE>”);
    PHP $dbh=mysql_connect (“localhost”, “jones_Gus”, “<PASSWORD HERE>”) or die (‘I cannot connect to the database because: ‘ . mysql_error());
    mysql_select_db (“jones_Wordpress”);

    I altered the php file to this
    <?php
    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘WordPress’); // The name of the database
    define(‘DB_USER’, ‘Gus’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘jones’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

    // 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-includes/languages.
    // For example, install de.mo to wp-includes/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’);
    ?>

    I uploaded it to my server but when i run the install php I get this:
    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. This could mean your host’s database server is down.

    Are you sure you have the correct username and password?
    Are you sure that you have typed the correct hostname?
    Are you sure that the database server is running?
    If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.
    et this:

    In my sql datbase I have several installations done with fantastico and they are the same to look at as the sql database I created.

    I only alterd the top part putting in my db name etc nothing else.
    Ant ideas what I am doing wrong?

    first time to try this.

    Gus

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter fas

    (@fas)

    I have sorted it I didnt put a prefix jones in before the info ie

    define(‘DB_NAME’, ‘jones_Wordpress’); // The name of the database
    define(‘DB_USER’, ‘jones_Gus’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘jones’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

    Cheers all

    Gus

    Perhaps you can mark this resolved, then?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Errors’ is closed to new replies.