Jump to content
xisto Community

PurpleRoseCashware

Members
  • Content Count

    1
  • Joined

  • Last visited

Everything posted by PurpleRoseCashware

  1. "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."Here is how to fix it:1. go to phpmyadmin;2. click on the database you want to change the pw to (onl left);3. click on "privileges";4. click on the "edit privileges" icon on the right of the root user for localhost.5. go to the "change password" block;6. tick the "password" radio button;7. enter password and re-type that password;8. tick: ... keep the old one.9. click "go";10. now go open a MySql Console from the WAMPSERVER menu;11. it will ask you for a pw ? just hit the return since you don't have one yet (next time you go to the console you'll need to enter the new pw that you'r entering here). type the following:UPDATE mysql.user SET Password=PASSWORD("xxxxxx")WHERE User="root";(where xxxxxx is the password you entered in the previous step).12. Now type: FLUSH PRIVILEGES;13. go to your WAMP or MAMP folder, find the APPS folder, and than click on your PHPMYADMIN folder ( e.g my folder called phpmyadmin2.11.6 ) and find the config.inc.php14. open config.inc.php with wordpad and find the following text:$cfg['Servers'][$i]['password'] = '';now add the password that you used in step number 3 like this :$cfg['Servers'][$i]['password'] = 'yourPasswordHere'; 15. now save this modification, and close config.inc.phpYou should be all set now!
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.