If you’re interested in learning more about PhpMyAdmin then check out the book “ Mastering PhpMydmin for Effective MySQL Management“. If you don’t add a $cfg line to the file, when you access phpMyAdmin you’ll get the message: “ The configuration file now needs a secret passphrase (blowfish_secret).“.The blowfish_secret passphrase should not be the same as the root password.Once all the services have been restarted go to phpMyAdmin and enter the username root and your password to access phpMyAmdin.Go to the WAMPServer and select Restart All Services.Add a secret passphrase to $cfg = ‘ ‘ for example: $cfg = ‘secret_pass’.If you don’t have one add it to your file Locate $cfg = ‘config’ and change from config to cookie so that you get a login window every time you access phpMyAdmin. Now you need to edit file normally located at C:\wamp\apps\phpmyadmin3.2.0.1 (note that the version indication may vary).You should now have at the top of the screen the message: “ The password for was changed successfully.“.On the Change Password section insert the desired password and press Go.Edit the root user privileges by clicking on the corresponding Edit Privileges button.Locate the user “ root” that has for a host.Enter the following command and press the Enter/Return key: mysqladmin -u root password. This will open up a new window with a command prompt. To correct this security issue you need to do the following: Use the XAMPP shell to change your root password. 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’.” “Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. After installing WAMP Server it is common when you first access phpMyAdmin to get the following message:
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |