Cannot access my MySQL server in Win8

  • Resolved hapzfl

    (@hapzfl)


    11 years, 2 months ago

    I used to have a local WordPress site running under Vista. I never tried it under Win7 after I uploaded my site on a commercial server. But now I have a need to install and run WordPress locally and so far my installation under Win8 failed miserably.

    I downloaded and installed the newest version of MySQL (5.5.29), installed the newest version of XAMP and have WordPress waiting.

    My problem: I cannot access my MySQL database via http://localhost/xampp/index.php and then selecting phpAdmin to set up the database for access by WordPress.

    That’s the error message I get no matter what account/PW or settings in config.inc.php I use:

    #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
    phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

    W/o that access to MySQL via the XAMP/phpAdmin I am stuck.

    Why is MySQL refusing access?
    Is there another way to get WordPress running?

    I hope somebody has a solution for this puzzle?!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Clayton James

    (@claytonjames)

    11 years, 2 months ago

    I downloaded and installed the newest version of MySQL (5.5.29), installed the newest version of XAMP and have WordPress waiting.

    XAMMP comes pre-configured with MySQL, Apache and PHP. My advice is to begin by uninstalling the stand alone version of MySQL. Then you may want to seek out one of the numerous tutorial for installing and configuring XAMMP and WordPress on Windows.

    #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)

    This is a pretty common issue with phpMyAdmin on localhost installs. You may need to consult some documentation and instructions on setting up phpMyAdmin.

    xampp #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)

    Thread Starter hapzfl

    (@hapzfl)

    11 years, 2 months ago

    Thanks for your prompt reply. I was partially successful after uninstalling the stand alone version of MySQL. At least I was able to
    access the database via phpAdmin; but WordPress still would not run.

    I finally gave up and uninstalled everything associated with XAMP.That was necessary tosucceed with the next step:

    Downloading and installing the MS Web Platform Installer. Using the MS Web Matrix I now have WordPress running successfully and locally under Win8.

    Clayton James

    (@claytonjames)

    11 years, 2 months ago

    Glad you got it working!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Cannot access my MySQL server in Win8’ is closed to new replies.