How to Insert a MD5 Password (or the Result of Any Other MySQL Function) Into a Field with “Navicat for MySQL”

MySQL already supports MD5() in terms of built-in functions. This is helpful whenever you want to insert something into a cell using the INSERT INTO users (id,username,password_hash) VALUES (1001,john_page,MD5(‘password_here’)) query.

But what happens when you already have a database and you want to change one single cell without fiddling manually with raw SQL queries, especially when you have Navicat SQL GUI software available? Luckily, Navicat has the so-called “Raw Mode” when viewing a table’s rows which allows us to insert data using expressions/functions which will be evaluated and converted to a string as soon as you press ENTER.

Here are the steps to follow if you want to convert a raw string into its MD5 representation and insert that representation as a cell within a MySQL cell:

  1. Open your desired table with Navicat (e.g. “users”)
  2. Choose “View->Raw Mode” from the top menu
  3. In your password field, type the expression, whose result you want inserted in that field, e.g. MD5(‘newpassword’)
  4. Hit “Enter” and “Ctrl+S” to apply the changes. Optionally disable “Raw mode” from the menu if you need to go back to the regular mode.

Enjoy the result of the MD5, without using complex raw SQL queries that are prone to typos.

Install the Most Popular Web Applications with 1 Click

InstantInstall allows you to install 9 of the most popular web applications by just uploading a simple PHP file to your server and pointing your browser to it.

You just need remote downloading enabled on your server (file_get_contents specifically) and the memory limit to a higher amount (to avoid script interruptions due to running out of memory).

Currently you can download and install the following PHP scripts using InstantInstall:

  1. WordPress – the most popular blogging platform
  2. bbPress – forum software, created by the WordPress crew
  3. Chyrp – lightweight blogging engine
  4. Drupal – CMS
  5. Joomla – portal engine
  6. phpBB – forum engine
  7. PrestaShop – eCommerce engine
  8. Symphony – web PHP framework
  9. Vanilla – forum software

[ad name=”In Post (LU)”]