• I am using IIS server on Windows7, I am trying to set up word press but run into problems with MYSQL. Can someone please give me some pointers? Thanks in advance.

    Trying to point to my installation at: http://localhost/w_wordpress/wp-admin/install.php

    I got 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.
    ***********************************************************************

    I confirmed that the user is set up in mysql.

    C:\w_wordpress>mysql -u root -p
    Enter password: ********
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 40
    Server version: 5.1.46-community MySQL Community Server (GPL)

    Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
    This software comes with ABSOLUTELY NO WARRANTY. This is free software,
    and you are welcome to modify and redistribute it under the GPL v2 license

    Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

    mysql> select user,password,host from user;
    ERROR 1046 (3D000): No database selected
    mysql> use mysql;
    Database changed
    mysql> select user,password,host from user;
    +———+——————————————-+———–+
    | user | password | host |
    +———+——————————————-+———–+
    | root | *29A5F504540369CEFD6DD8D0716E0B1C652BED30 | localhost |
    | wp_user | *737781E879359DFAE306B5DC2066697FFB3C08F9 | localhost |
    | wp | wp | localhost |
    +———+——————————————-+———–+
    3 rows in set (0.00 sec)

    mysql> quit
    Bye

    C:\w_wordpress>mysql -u wp_user -p
    Enter password: **
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 41
    Server version: 5.1.46-community MySQL Community Server (GPL)

    Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
    This software comes with ABSOLUTELY NO WARRANTY. This is free software,
    and you are welcome to modify and redistribute it under the GPL v2 license

    Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

    mysql> use mysql;
    ERROR 1044 (42000): Access denied for user ‘wp_user’@’localhost’ to database ‘mysql’
    mysql> use MY_WP
    Database changed
    mysql> show tables;
    Empty set (0.00 sec)

    mysql>
    mysql> show databases;
    +——————–+
    | Database |
    +——————–+
    | information_schema |
    | my_wp |
    +——————–+
    2 rows in set (0.00 sec)

    mysql> quit
    Bye

    C:\w_wordpress>mysql -u root -p
    Enter password: ********
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 43
    Server version: 5.1.46-community MySQL Community Server (GPL)

    Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
    This software comes with ABSOLUTELY NO WARRANTY. This is free software,
    and you are welcome to modify and redistribute it under the GPL v2 license

    Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

    mysql> show databases;
    +——————–+
    | Database |
    +——————–+
    | information_schema |
    | my_wp |
    | mysql |
    | test |
    | wp |
    +——————–+
    5 rows in set (0.00 sec)

    mysql>
    ***********************************************************************
    This is my wp-config.php

    // ** MySQL settings – You can get this info from your web host ** //
    /** The name of the database for WordPress */
    define(‘DB_NAME’, ‘MY_WP’);

    /** MySQL database username */
    define(‘DB_USER’, ‘wp_user’);

    /** MySQL database password */
    define(‘DB_PASSWORD’, ‘WP’);

    /** MySQL hostname */
    define(‘DB_HOST’, ‘localhost’);

    /** Database Charset to use in creating database tables. */
    define(‘DB_CHARSET’, ‘utf8’);

    /** The Database Collate type. Don’t change this if in doubt. */
    define(‘DB_COLLATE’, ”);

    /**#@+
    * Authentication Unique Keys.
    *
    * Change these to different unique phrases!
    * You can generate these using the {@link https://api.wordpress.org/secret-key/
    1.1/ WordPress.org secret-key service}
    * You can change these at any point in time to invalidate all existing cookies.
    This will force all users to have to log in again.
    *
    * @since 2.6.0
    ***********************************************************************

  • The topic ‘http://localhost/w_wordpress/wp-admin/install.php died!’ is closed to new replies.