{"id":148,"date":"2020-09-03T12:56:02","date_gmt":"2020-09-03T10:56:02","guid":{"rendered":"https:\/\/infosecscout.com\/?p=148"},"modified":"2023-11-22T13:02:25","modified_gmt":"2023-11-22T12:02:25","slug":"set-md5-password-phpmyadmin","status":"publish","type":"post","link":"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/","title":{"rendered":"How to Set a MD5 Password in PHPMyAdmin?"},"content":{"rendered":"\n<p>The MD5 encryption algorithm is still one of the most used in the world, and specially in MySQL tables.<br>In this tutorial, I&#8217;ll show you how it works in a database, and especially how to generate it easily with PHPMyAdmin.<\/p>\n\n\n\n<p><strong>When inserting a new line with PHPMyAdmin, there is a dropdown menu on the left of the field. Pick the MD5 function in the list and enter the value in clear text. It will automatically convert it in MD5 on insertion.<\/strong><\/p>\n\n\n\n<p>Today, I&#8217;ll give you a step-by-step tutorial on how to create a table to store MD5, how to set your MD5 Password and how to manage this in PHP directly.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/#Creating_a_demo_table\" title=\"Creating a demo table\">Creating a demo table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/#Insert_a_new_line_with_PHPMyAdmin\" title=\"Insert a new line with PHPMyAdmin\">Insert a new line with PHPMyAdmin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/#Set_a_MD5_Password_in_MySQL_andor_PHP_directly\" title=\"Set a MD5 Password in MySQL and\/or PHP directly\">Set a MD5 Password in MySQL and\/or PHP directly<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/#MySQL\" title=\"MySQL\">MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/#PHP\" title=\"PHP\">PHP<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/#Create_a_user_in_PHP\" title=\"Create a user in PHP\">Create a user in PHP<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/#Verify_a_user_and_password_in_PHP\" title=\"Verify a user and password in PHP\">Verify a user and password in PHP<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/#Security_issues_with_MD5\" title=\"Security issues with MD5\">Security issues with MD5<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/#Why_is_MD5_not_secure\" title=\"Why is MD5 not secure?\">Why is MD5 not secure?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/#What_you_can_do_to_improve_security\" title=\"What you can do to improve security?\">What you can do to improve security?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/#An_example_with_salt_in_PHP\" title=\"An example with salt in PHP\">An example with salt in PHP<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/infosecscout.com\/set-md5-password-phpmyadmin\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creating_a_demo_table\"><\/span>Creating a demo table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Before going further, I&#8217;ll create a basic MySQL table to show you how it works.<br>My table will simply be &#8220;users&#8221;, with three fields:<\/p>\n\n\n\n<ul><li><strong>auto_id &#8211; INT(11):<\/strong> I often create a first field like this one. The goal is to have an auto-incremented number for each line (you can check the A_I checkbox on the same line to do the same).<\/li><li><strong>login &#8211; VARCHAR(32)<\/strong>: It&#8217;s just an example, you can use an email address or whatever instead. In this basic example, it&#8217;ll be a login.<\/li><li><strong>password &#8211; VARCHAR(32)<\/strong>: The one that interest us today. An MD5 hash is composed of 32 hexadecimal characters, so you need to have 32 in length.<\/li><\/ul>\n\n\n\n<p>Here is the corresponding MySQL query to create the table if you want to try while reading this post:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE `users` (\n  `auto_id` int(11) NOT NULL,\n  `login` varchar(32) NOT NULL,\n  `password` varchar(32) NOT NULL\n)<\/code><\/pre>\n\n\n\n<p> And the result:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/table_users.jpg\" alt=\"\" class=\"wp-image-150\" width=\"179\" height=\"104\"\/><\/figure>\n\n\n\n<p>We are now ready to insert a new line in this table!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Insert_a_new_line_with_PHPMyAdmin\"><\/span>Insert a new line with PHPMyAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>In PHPMyAdmin, you can insert new lines with a form,<\/strong> you don&#8217;t need to type the MySQL query each time. In this part, I&#8217;ll show you how to do this, but if you are also interested in the MySQL query, I&#8217;ll give it to you just after.<\/p>\n\n\n\n<p><strong>Here is how to set a MD5 password while inserting your values in PHPMyAdmin:<\/strong><\/p>\n\n\n\n<ul><li>Browse to the &#8220;users&#8221; table (or whatever the name of your table is)<\/li><li>In the top menu, <strong>click on &#8220;Insert&#8221;<\/strong><br><img loading=\"lazy\" decoding=\"async\" width=\"814\" height=\"60\" class=\"wp-image-152\" style=\"width: 814px;\" src=\"https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/insert-menu.jpg\" alt=\"\" srcset=\"https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/insert-menu.jpg 814w, https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/insert-menu-300x22.jpg 300w, https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/insert-menu-768x57.jpg 768w\" sizes=\"(max-width: 814px) 100vw, 814px\" \/><\/li><li>A form shows up with all the fields from your MySQL table<br><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"166\" class=\"wp-image-153\" style=\"width: 700px;\" src=\"https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/insert-form.jpg\" alt=\"\" srcset=\"https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/insert-form.jpg 700w, https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/insert-form-300x71.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/li><li>Then you can<strong> fill your form<\/strong>:<ul><li>The &#8220;auto_id&#8221; needs to stay empty (will be automatically set)<\/li><li>Type the &#8220;login&#8221; you want to create<\/li><li>Enter the &#8220;password&#8221; in clear mode in the value column<\/li><\/ul><\/li><li>Before submitting the form, you need to encrypt the password in MD5<br>To do this, <strong>find the &#8220;MD5&#8221; function in the dropdown list<\/strong>.<\/li><li>Your form should look like this:<br><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"152\" class=\"wp-image-154\" style=\"width: 700px;\" src=\"https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/insert-filled.jpg\" alt=\"\" srcset=\"https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/insert-filled.jpg 700w, https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/insert-filled-300x65.jpg 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><br>Not so complicated hum? \ud83d\ude42<\/li><li>You can now<strong> submit the form<\/strong>, and insert another line if you want<\/li><\/ul>\n\n\n\n<p>Once done, the lines look like this:<br><img loading=\"lazy\" decoding=\"async\" width=\"536\" height=\"84\" class=\"wp-image-157\" style=\"width: 536px;\" src=\"https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/md5line.jpg\" alt=\"\" srcset=\"https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/md5line.jpg 536w, https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/md5line-300x47.jpg 300w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><br>The password is correctly encrypted in the field<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Set_a_MD5_Password_in_MySQL_andor_PHP_directly\"><\/span>Set a MD5 Password in MySQL and\/or PHP directly<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this part, I&#8217;ll show you how to do the same thing directly in MySQL, but also with PHP.<br>This should be more convenient than PHPMyAdmin to do this automatically.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQL\"><\/span>MySQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If you followed the previous method with PHPMyAdmin, you may have seen the MySQL query displayed on your screen.<br>In any case, <strong>here is an example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO users \n(auto_id, login, password) \nVALUES \n(NULL, 'myuser', MD5('clearpassword'));<\/code><\/pre>\n\n\n\n<p>So, we just add the &#8220;MD5()&#8221; function to the password in text, and it will insert a line with a MD5 hash.<\/p>\n\n\n\n<p>By the way, the auto_id field is not mandatory, and will be filled automatically even if you don&#8217;t set it to &#8220;NULL&#8221; in the query. <br><strong>This query will do the same thing for example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO users \n(login, password) \nVALUES \n('myuser', MD5('clearpassword'));<\/code><\/pre>\n\n\n\n<p>Once you have the MySQL Query set for your new users, you can click on &#8220;SQL&#8221; and paste it directly in PHPMyAdmin.<br>You can <a rel=\"noreferrer noopener\" href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/insert.html\" target=\"_blank\">find the MySQL documentation here<\/a> if you have any specific thing to handle. But for my basic table, it&#8217;s enough \ud83d\ude42<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"PHP\"><\/span>PHP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You now know almost everything, the only step missing is how to check the used password is correct on sign in.<br>I&#8217;ll show you with PHP as it&#8217;s the most used language for MySQL, but you can find similar functions in other languages too.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Create_a_user_in_PHP\"><\/span>Create a user in PHP<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p><strong>In PHP, there is a pack of functions, starting by mysqli_* that allow you to work with MySQL database.<\/strong><br>In this first example, we&#8217;ll see how to insert a new line directly from PHP.<\/p>\n\n\n\n<p>Let&#8217;s start immediately with the code sample:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n\/\/Connect to your database\n$mysqli = new mysqli(\"localhost\",\"user\",\"password\",\"db\");\n\n\/\/Verify connection\nif ($mysqli -&gt; connect_errno) {\n   die(\"Database error: \".$mysqli-&gt;connect_error);\n}\n\n\/\/Run your query\n$mysqli-&gt;query(\"INSERT INTO users \n(login, password) \nVALUES \n('myuser', MD5('clearpassword'))\");\n\n\/\/Other operations if needed\n?&gt;<\/code><\/pre>\n\n\n\n<p><strong>Here is a short explanation:<\/strong><\/p>\n\n\n\n<ul><li>The first lines will manage the database connection.<\/li><li>The next paragraph is to check that you are correctly connected (or if there is an error we stop here, the credentials are probably wrong).<\/li><li>Then, we run the same query as seen in the MySQL section.<\/li><li>At the end you can add any other request or PHP code you want to complete your registration. But at this point the MD5 part is already done.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Verify_a_user_and_password_in_PHP\"><\/span>Verify a user and password in PHP<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Good, now we have seen how to set a MD5 password in our table, from PHPMyAdmin or directly with PHP.<br>But how to check that the password entered on login (in clear text) is the same as the one in the database (in MD5)?<\/p>\n\n\n\n<p><strong>The MD5 algorithm is not reversible, so the only way is to encrypt the password typed in the form before trying to match it with the database.<br>Something like that for example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n\/\/Start with the MySQL connection as in the previous example\n\n\/\/Get the values from the form submitted\n$user = $_POST&#91;'username'];\n$pass = $_POST&#91;'password'];\n\n\/\/Look for a corresponding user\n$result = $mysqli-&gt;query(\"SELECT * FROM users WHERE login='\".$user.\"' AND password='\".md5($password).\"'\");\n\nif($result-&gt;num_rows) {\n   \/\/user match\n}\nelse {\n   \/\/error, incorrect user or password\n}<\/code><\/pre>\n\n\n\n<p>It&#8217;s a basic example you need to complete, but it should give you an idea on how it works. <br>And yes, PHP has also a built-in MD5 function, so it&#8217;s easy to use (<a href=\"https:\/\/www.php.net\/manual\/en\/function.md5.php\">documentation<\/a>).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Security_issues_with_MD5\"><\/span>Security issues with MD5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>If you don&#8217;t know, you have to be cautious when you use the MD5 algorithm to store passwords. It&#8217;s one of the less secure currently in the world, so if you can it&#8217;s better to avoid it.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_is_MD5_not_secure\"><\/span>Why is MD5 not secure?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>I already wrote an article on the topic, so I&#8217;ll give too many details in here, but in short, there are at least 3 reasons why using MD5 is not a good idea:<\/p>\n\n\n\n<ol><li><strong>Dictionary tables<\/strong>: On MD5Online, there is a database with over 1,150 billions password available. There is a pretty high chance that some of your passwords are available in it. <a href=\"https:\/\/www.md5online.org\/md5-decrypt.html\" target=\"_blank\" rel=\"noreferrer noopener\">You can try our MD5 decrypter for free here<\/a>.<\/li><li><strong>Brute force<\/strong>: A brute force attack is a method to find a password by trying millions of possibilities. Components are better and better currently to do this (thanks to the big improvements in GPU computing)<br>Here is an illustration from <a rel=\"noreferrer noopener\" href=\"https:\/\/www.hivesystems.io\/\" target=\"_blank\">Hive Systems<\/a>:<br><img loading=\"lazy\" decoding=\"async\" width=\"692\" height=\"688\" class=\"wp-image-165\" style=\"width: 692px;\" src=\"https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/image001.jpg\" alt=\"\" srcset=\"https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/image001.jpg 692w, https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/image001-300x298.jpg 300w, https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/image001-150x150.jpg 150w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><br>And it&#8217;s not just for the MD5 algorithm, is global, whatever the algorithm.<\/li><li><strong>Collisions<\/strong>: With MD5, two words can have the same MD5 hash. So it&#8217;s potentially two different passwords that can be used for the same encrypted password. It&#8217;s not a good thing in security.<\/li><\/ol>\n\n\n\n<p>If you want to know more about these reasons, check my post on &#8220;<a href=\"https:\/\/infosecscout.com\/why-md5-is-not-safe\/\" data-type=\"post\" data-id=\"53\" target=\"_blank\" rel=\"noreferrer noopener\">Why MD5 is not safe?<\/a>&#8220;.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_you_can_do_to_improve_security\"><\/span>What you can do to improve security?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You can find more details in the linked post above on how to improve security with several solutions. <br>But for now, I want to introduce one specific way: adding salt \ud83d\ude42<\/p>\n\n\n\n<p><strong>A salt is a word you add before and\/or after the password to encrypt.<\/strong><br>For example, instead of hashing &#8220;azerty&#8221;, you do it with &#8220;md5onlineazerty&#8221;<br>This way, even if your database is hacked, it will be more difficult to find the corresponding password to the hash (this salt is probably not a good example, but just to show you the idea).<\/p>\n\n\n\n<p><strong>When someone tries to sign in, you will do the same thing, you take the password entered the form, and you add the salt before hashing the whole string in MD5.<\/strong><br>We&#8217;ll see in the last part how to implement this in PHP.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"An_example_with_salt_in_PHP\"><\/span>An example with salt in PHP<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>In PHP, using salt is very similar to what we have already done earlier:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n\/\/Start with the MySQL connection as in the previous example\n\n\/\/Get the values from the form submitted\n$salt = \"mysaltstring\";\n$user = $_POST&#91;'username'];\n$pass = $salt.$_POST&#91;'password'];\n\n\/\/Look for a corresponding user\n$result = $mysqli-&gt;query(\"SELECT * FROM users WHERE login='\".$user.\"' AND password='\".md5($password).\"'\");\n\nif($result-&gt;num_rows) {\n   \/\/user match\n}\nelse {\n   \/\/error, incorrect user or password\n}<\/code><\/pre>\n\n\n\n<p>The only change in PHP is the concatenation between salt and password (&#8220;.&#8221;).<br>It&#8217;s the same thing for the registration process<\/p>\n\n\n\n<p>If this process with salt is still complicated for you, feel free to <a rel=\"noreferrer noopener\" href=\"https:\/\/infosecscout.com\/md5-salt-hash\/\" target=\"_blank\">check my post on MD5 Salt here<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>That&#8217;s it, you now have a good overview on how to use MD5 password in PHPMyAdmin, and also in MySQL and PHP.<\/p>\n\n\n\n<p>I hope this post was useful for you, please share it on your favorite social network or forum! \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The MD5 encryption algorithm is still one of the most used in the world, and specially in MySQL tables.In this tutorial, I&#8217;ll show you how it works in a database, and especially how to generate it easily with PHPMyAdmin. When inserting a new line with PHPMyAdmin, there is a dropdown menu on the left of&#8230;<\/p>\n","protected":false},"author":1,"featured_media":171,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[14],"tags":[],"taxonomy_info":{"category":[{"value":14,"label":"Security"}]},"featured_image_src_large":["https:\/\/infosecscout.com\/wp-content\/uploads\/2020\/09\/Vignette-RPIFR-1-1024x683.jpg",1024,683,true],"author_info":{"display_name":"Patrick Fromaget","author_link":"https:\/\/infosecscout.com\/about\/"},"comment_info":0,"category_info":[{"term_id":14,"name":"Security","slug":"security","term_group":0,"term_taxonomy_id":14,"taxonomy":"category","description":"Check out our easy-to-follow tips and facts in Security Information. Learn how passwords work and more, all explained in a way that's easy to understand.","parent":0,"count":21,"filter":"raw","cat_ID":14,"category_count":21,"category_description":"Check out our easy-to-follow tips and facts in Security Information. Learn how passwords work and more, all explained in a way that's easy to understand.","cat_name":"Security","category_nicename":"security","category_parent":0}],"tag_info":false,"_links":{"self":[{"href":"https:\/\/infosecscout.com\/wp-json\/wp\/v2\/posts\/148"}],"collection":[{"href":"https:\/\/infosecscout.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/infosecscout.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/infosecscout.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/infosecscout.com\/wp-json\/wp\/v2\/comments?post=148"}],"version-history":[{"count":18,"href":"https:\/\/infosecscout.com\/wp-json\/wp\/v2\/posts\/148\/revisions"}],"predecessor-version":[{"id":350,"href":"https:\/\/infosecscout.com\/wp-json\/wp\/v2\/posts\/148\/revisions\/350"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/infosecscout.com\/wp-json\/wp\/v2\/media\/171"}],"wp:attachment":[{"href":"https:\/\/infosecscout.com\/wp-json\/wp\/v2\/media?parent=148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/infosecscout.com\/wp-json\/wp\/v2\/categories?post=148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/infosecscout.com\/wp-json\/wp\/v2\/tags?post=148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}