MYSQL WP database unable to connect

  • Hamoudy

    (@hamoudy)


    17 years, 6 months ago

    I’m having problems connecting to the WordPress Database. I’m setting this up on my local server, I have downloaded and set up the latest MYSQL version 5.024 also downloaded the MYSQL administration tool and added database name ” wordpress” also username called it ” wordpress”

    when i try to run the http://localhost/wp/wp-admin/install.php.

    I get Error establishing a database connection

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

    I can command prompt to mysql and login with user name created so i know it works from there but not from wordpress

    any suggestions?

Viewing 9 replies - 1 through 9 (of 9 total)
  • spencerp

    (@spencerp)

    17 years, 6 months ago

    Are you sure that the user you’ve created, has permissions for ALL on the database? Also, you might want to read this here.

    spencerp

    spencerp

    (@spencerp)

    17 years, 6 months ago

    By the way, your DUPE thread was closed:
    http://wordpress.org/support/topic/90139?replies=1

    Also, do a phpinfo to confirm the php and mysql are talking. Put this: <?php phpinfo(); ?> into a blank PHP file, called whatever.. upload it, or add it and bring it up in the browser.. see what it says.. k

    spencerp

    Also, not sure, but this read might also help.

    Thread Starter Hamoudy

    (@hamoudy)

    17 years, 6 months ago

    Thanks for responding.

    when i did a phpinfo it gave me this for mysql

    Active Persistent Links 0
    Active Links 0
    Client API version 3.23.49

    Directive Local Value Master Value
    mysql.allow_persistent On On
    mysql.connect_timeout 60 60
    mysql.default_host no value no value
    mysql.default_password no value no value
    mysql.default_port no value no value
    mysql.default_socket no value no value
    mysql.default_user no value no value
    mysql.max_links Unlimited Unlimited
    mysql.max_persistent Unlimited Unlimited
    mysql.trace_mode Off Off
    ———————————————-

    I assume since its sayin no value next to host of port that its not talkin to it right.

    Yes I gave the user access and i even tried the root username nad password still cant connect..

    Thread Starter Hamoudy

    (@hamoudy)

    17 years, 6 months ago

    I forgot to mention that im using MySQL administration tool not phpmyadmin

    spencerp

    (@spencerp)

    17 years, 6 months ago

    This might make your life so much easier..
    http://www.tamba2.org.uk/wordpress/xampp/

    spencerp

    Thread Starter Hamoudy

    (@hamoudy)

    17 years, 6 months ago

    One issue is that I need to set this up on Windows 2000 which is already using IIS for different applications . In that tutorial it says i NEED to disable IIS.

    I’m almost thinking to go back to an older version of mysql…

    spencerp

    (@spencerp)

    17 years, 6 months ago

    Ah yeah.. I forgot about you using the IIS.. Sorry about that.. Um, yeah..I’d try an earlier version of the MySql once.. and see. I’m not really the greatest at the Database stuff sigh.. Hopefully someone else see’s this thread and chips in their 2 cents.. that’s if they can afford too.. LoL!

    spencerp

    Thread Starter Hamoudy

    (@hamoudy)

    17 years, 6 months ago

    HELP! ANYONE?

    chinatour

    (@chinatour)

    17 years, 4 months ago

    This
    ———–
    define(‘DB_NAME’, ‘wordpress’); // The name of the database
    define(‘DB_USER’, ‘wordpress’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘wordpress’); // …and password
    ——–
    should be some thing like this
    ————-
    define(‘DB_NAME’, ‘name of your database’); // The name of the database
    define(‘DB_USER’, ‘name of the user’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘password of the user’); // …and password
    ————————-

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘MYSQL WP database unable to connect’ is closed to new replies.