This is more secure because the hash is not reversible, i.e. When it verifies your password, it encrypts it and checks the encryption against the stored hash, if they match the password is accepted. MySql 4.0 compatible will generate a 16 byte password hash (MySql does not store the actual password, it stores an encrypted 16 byte hash of the password. Unless you require backwards compatibility with older database engines, leave MySql 4.1+ selected. you cannot discover the password by reversing the encryption process). MySql 4.1+ will generate a 41 byte password hash (MySql does not store the actual password, it stores an encrypted 41 byte hash of the password. The Generate Password function generates passwords of 16 characters in length, so it is reasonable to assume this is the maximum. There is no mention in the MySql documentation of maximum password length. Numerous forums report errors trying to use other ASCII characters. Click on Go to accept it.Ī password should be composed of basic ASCII characters (‘a’.’z’, ‘A’.’Z’, and “0’.’9’). (3) Click on the icon in the Action column:Įnter a password and retype it to confirm it. This will bring you to the phpmyadmin main page. WARNING: you will need to update your phpmyadmin configuration file to login using the new password, otherwise you will no longer be able to use phpmyadmin.Įven if you assign a password to root, someone can still gain access to it by inspecting the phpmyadmin configuration file (where the password is plainly visible).Ĭlick on images for full sized versions. The procedure should be the same for other versions of XAMPP.Ī XAMPP installation procedure for Windows XP can be found here. This tutorial assumes that you have XAMPP 1.7.3 installed. However, for local development and testing, this should not be a problem. This poses a security risk if the computer or database are publically accessible. By default, databases in XAMPP are created with the user root having a blank password.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |