Help with MySQL on a Windows server

  • Resolved FGJR-Hermits

    (@fgjr-hermits)


    13 years, 3 months ago

    So I’m running WordPress on a Widnows 2008 R2 server with IIS 7, PHP, and MySQL. I just went to add another site and for the life of me I cannot remember what my MySQL root password is!!! UGH!!!! I’m usually very good about documenting these things, but I guess I screwed this one up.

    I see instructions on the web on how to reset the root MySQL password, but how will that effect my existing site. Am I going to need to change something in WordPress for it to connect correctly? Or as long as the User and Password for the site doesn’t get changed in MySQL I’m fine??

    Any help is GREATLY appreciated! ??

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

  • if you’re using the same database, it won’t affect the original site IF you change the table_prefix in the second site’s wp-config.php

    you should be able to change the mysql password, but will have to also change it in your original site’s config file

    Thread Starter FGJR-Hermits

    (@fgjr-hermits)

    Sam..

    Thanks for the reply!!! Maybe I can go in depth a little more.

    The original site will have and does have its own database. The problem I’m running into is that the setup script is trying to connect to the MySQL in order to setup a new DB. I cant remember the ‘root’ password for it to have access to create a new DB.

    So, with that being said. If I change the ‘root’ password to MySQL so that I can use the script to create the new DB for the new site, will my original site be affected at all? I’m thinking no because the original’s site username and password to MySQL isn’t going to change. Only the ‘root’ password for MySQL will change.

    Am I correct in my logic?

    Thanks again for your time! ??

    ahhh

    Am I correct in my logic?

    Totally correct

    Thread Starter FGJR-Hermits

    (@fgjr-hermits)

    Thanks so much Samuel!!! I appreciate you taking the time ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Help with MySQL on a Windows server’ is closed to new replies.