Install just fine UNTIL I change the root SQL password

  • ltacf

    (@ltacf)


    11 years, 4 months ago

    I’ve read different answers to this issue but there are so many contextual differences and none have helped. Here is my context:

    Windows 7
    Installing EasyPHP (Apache and mySQL) on localhost
    user = root@localhost with no password
    WordPress 3.5 install

    I can successfully access WordPress and EasyPHP’s MySQLAdministration but I see the following message:

    “Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user ‘root’.”

    So I change my password in the WordPress wp-config.php. Then I start to lose access. So I try to also change the PHP file config.inc.php to also have the password for root. Still problems.

    I don’t understand where root@localhost comes into play. Is it a WordPress file as well as a PHP file as well as a mySQL file? How does one secure the root account as suggested without losing access?

    Thanks,

    Linda

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

    (@esmi)

    11 years, 4 months ago

    Do you intend to open your local server to public access?

    Thread Starter ltacf

    (@ltacf)

    11 years, 4 months ago

    No sir! My company has the production site installed which is secured. It is the test site, the one on my own hard drive where I have this issue. I realize that my own PC is not as important, but I still would like to protect it.

    Thanks in advance for any help,

    Linda

    Hashbrown044

    (@hashbrown044)

    11 years, 4 months ago

    If I understand correctly, you only changed the password in your WP install(the config files). The WP password should match your mySQL password. Be sure to change the password in the mySQL environment too.

    Start your EasyPHP’s MySQLAdministration and set the root password there as well.

    Thread Starter ltacf

    (@ltacf)

    11 years, 3 months ago

    Hashbrown044,

    Thanks for the information. Will you provide more detail? There are at least two EasyPHP menu options that may apply: 1) the Administration menu option and 2) the Configuration menu option brings up another menu from which you can select mySQL to bring up the my.ini file.

    I don’t know which file(s) to change in the “mySQL environment” and I don’t which file(s) to change in the MySQLAdministration.

    Thanks in advance,

    Linda

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Install just fine UNTIL I change the root SQL password’ is closed to new replies.