{"id":11078,"date":"2018-04-05T10:05:53","date_gmt":"2018-04-05T08:05:53","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/"},"modified":"2018-04-05T10:05:53","modified_gmt":"2018-04-05T08:05:53","slug":"password-validation-in-mysql","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/","title":{"rendered":"Password Validation in MySQL"},"content":{"rendered":"<h3>Introduction on validate_password plugin<\/h3>\n<p>Since version 5.6.6 MySQL provides a new security plugins named Password Validation Plugin. The password-validation plugin aims to test passwords strength and improve security. The goal of this blog is to provide you a short overview of the functionalities provided through this plugin and illustrate these functionalities with concrete examples.<\/p>\n<p>As explained into the documentation The validate_password plugin implements two capabilities:<\/p>\n<p>1. The plugin checks the password against the current password policy and rejects the password if it is weak<br \/>\n2. The VALIDATE_PASSWORD_STRENGTH() SQL function assesses the strength of potential passwords. The function takes a password argument and returns an integer from 0 (weak) to 100 (strong).<\/p>\n<p>validate_password plugin implements three level of password checking that are described below:<\/p>\n<ul>\n<li>LOW &#8211; policy tests password length only.<\/li>\n<li>MEDIUM (Default) &#8211; policy adds the conditions that passwords must contain at least 1 numeric character, 1 lowercase character, 1 uppercase character, and 1 special (nonalphanumeric) character<\/li>\n<li>STRONG &#8211; policy adds the condition that password substrings of length 4 or longer must not match words in the dictionary file, if one has been specified.<\/li>\n<\/ul>\n<p>validate_password plugin provides several checks that can be seen using the show variables command:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">SHOW VARIABLES LIKE 'validate_password.%';\n+--------------------------------------+--------+\n| Variable_name                        | Value  |\n+--------------------------------------+--------+\n| validate_password.check_user_name    | ON     |\n| validate_password.dictionary_file    |        |\n| validate_password.length             | 8      |\n| validate_password.mixed_case_count   | 1      |\n| validate_password.number_count       | 1      |\n| validate_password.policy             | MEDIUM |\n| validate_password.special_char_count | 1      |\n+--------------------------------------+--------+\n7 rows in set (0,01 sec)\n\n<\/pre>\n<h3>Tests with validate_password.policy=LOW<\/h3>\n<p>First let&#8217;s set the validate_password.policy to LOW to check which tests are done by the plugin. It should only check password length.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">SET GLOBAL validate_password.policy=LOW;\n\n+--------------------------------------+-------+\n| Variable_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Value |\n+--------------------------------------+-------+\n| validate_password.check_user_name\u00a0\u00a0\u00a0 | ON\u00a0\u00a0\u00a0 |\n| validate_password.dictionary_file\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\n| validate_password.length\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 8\u00a0\u00a0\u00a0\u00a0 |\n| validate_password.mixed_case_count\u00a0\u00a0 | 1\u00a0\u00a0\u00a0\u00a0 |\n| validate_password.number_count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 1\u00a0\u00a0\u00a0\u00a0 |\n| validate_password.policy\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | LOW\u00a0\u00a0 |\n| validate_password.special_char_count | 1\u00a0\u00a0\u00a0\u00a0 |\n+--------------------------------------+-------+\n<\/pre>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">create user 'steulet'@'localhost' identified by '1234567';\nERROR 1819 (HY000): Your password does not satisfy the current policy requirements\n\ncreate user 'steulet'@'localhost' identified by '12345678';\nQuery OK, 0 rows affected (0,01 sec)<\/pre>\n<p>&nbsp;<\/p>\n<h3>Tests with validate_password.policy=MEDIUM<\/h3>\n<p>MEDIUM policy adds the conditions that passwords must contain at least 1 numeric character, 1 lowercase character, 1 uppercase character, and 1 special (nonalphanumeric) character<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">SET GLOBAL validate_password.policy=MEDIUM;\nQuery OK, 0 rows affected (0,00 sec)\n\nSHOW VARIABLES LIKE 'validate_password.%';\n+--------------------------------------+-------------------------------------+\n| Variable_name | Value |\n+--------------------------------------+-------------------------------------+\n| validate_password.check_user_name | ON |\n| validate_password.dictionary_file |  |\n| validate_password.length | 8 |\n| validate_password.mixed_case_count | 1 |\n| validate_password.number_count | 1 |\n| validate_password.policy | MEDIUM |\n| validate_password.special_char_count | 1 |\n+--------------------------------------+-------------------------------------+\n7 rows in set (0.00 sec)<\/pre>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">create user 'hueber'@'localhost' identified by '12345678';\nERROR 1819 (HY000): Your password does not satisfy the current policy requirements\n\ncreate user 'hueber'@'localhost' identified by '1234567L';\nERROR 1819 (HY000): Your password does not satisfy the current policy requirements\n\ncreate user 'hueber'@'localhost' identified by '123456zL';\nERROR 1819 (HY000): Your password does not satisfy the current policy requirements\n\ncreate user 'hueber'@'localhost' identified by '12345!zL';\nQuery OK, 0 rows affected (0.01 sec)<\/pre>\n<p>&nbsp;<\/p>\n<h3>Tests with validate_password.policy=STRONG<\/h3>\n<p>In order to check the validate_password.policy=STRONG I uploaded a password file used for brute force attack. You can download this file from: https:\/\/github.com\/danielmiessler\/SecLists\/blob\/master\/Passwords\/Most-Popular-Letter-Passes.txt<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">SET GLOBAL validate_password.dictionary_file='\/u01\/mysqldata\/mysqld2\/PasswordList';\nQuery OK, 0 rows affected (0,00 sec)<\/pre>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">SET GLOBAL validate_password.policy=strong;\nQuery OK, 0 rows affected (0,00 sec)<\/pre>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">SHOW VARIABLES LIKE 'validate_password.%';\n+--------------------------------------+-------------------------------------+\n| Variable_name | Value |\n+--------------------------------------+-------------------------------------+\n| validate_password.check_user_name | ON |\n| validate_password.dictionary_file | \/u01\/mysqldata\/mysqld2\/PasswordList |\n| validate_password.length | 8 |\n| validate_password.mixed_case_count | 1 |\n| validate_password.number_count | 1 |\n| validate_password.policy | STRONG |\n| validate_password.special_char_count | 1 |\n+--------------------------------------+-------------------------------------+<\/pre>\n<p>7 rows in set (0.00 sec)<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">create user 'neuhaus'@'localhost' identified by 'Manager1;';\nERROR 1819 (HY000): Your password does not satisfy the current policy requirements\n\ncreate user 'neuhaus'@'localhost' identified by 'Password1;';\nERROR 1819 (HY000): Your password does not satisfy the current policy requirements<\/pre>\n<p>If I decrease the validate_password.policy to medium, the plugin doesn&#8217;t check the dictionary file anymore:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">SET GLOBAL validate_password.policy=medium;\nQuery OK, 0 rows affected (0,00 sec)\n\ncreate user 'neuhaus'@'localhost' identified by 'Password1;';\nQuery OK, 0 rows affected (0,00 sec)<\/pre>\n<h3>Function VALIDATE_PASSWORD_STRENGTH()<\/h3>\n<p>As explained above the validate_password_strength test a password and returns an integer from 0 (weak) to 100 (strong) representing the password strength.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">select VALIDATE_PASSWORD_STRENGTH('abcd');\n+------------------------------------+\n| VALIDATE_PASSWORD_STRENGTH('abcd') |\n+------------------------------------+\n| 25 |\n+------------------------------------+\n1 row in set (0.00 sec)<\/pre>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">select VALIDATE_PASSWORD_STRENGTH('password');\n+----------------------------------------+\n| VALIDATE_PASSWORD_STRENGTH('password') |\n+----------------------------------------+\n| 50 |\n+----------------------------------------+\n1 row in set (0.00 sec)<\/pre>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">select VALIDATE_PASSWORD_STRENGTH('Manager1!');\n+-----------------------------------------+\n| VALIDATE_PASSWORD_STRENGTH('Manager1!') |\n+-----------------------------------------+\n| 75 |\n+-----------------------------------------+\n1 row in set (0.00 sec)<\/pre>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">select VALIDATE_PASSWORD_STRENGTH('aZbq!1)m8N');\n+------------------------------------------+\n| VALIDATE_PASSWORD_STRENGTH('aZbq!1)m8N') |\n+------------------------------------------+\n| 100 |\n+------------------------------------------+\n1 row in set (0.00 sec)<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction on validate_password plugin Since version 5.6.6 MySQL provides a new security plugins named Password Validation Plugin. The password-validation plugin aims to test passwords strength and improve security. The goal of this blog is to provide you a short overview of the functionalities provided through this plugin and illustrate these functionalities with concrete examples. As&hellip;&nbsp;<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[],"class_list":["post-11078","post","type-post","status-publish","format-standard","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Password Validation in MySQL - dbi services Blog<\/title>\n<meta name=\"description\" content=\"MySQL provides a new security plugins named Password Validation Plugin. The password-validation plugin aims to test passwords strength and improve security\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Password Validation in MySQL\" \/>\n<meta property=\"og:description\" content=\"MySQL provides a new security plugins named Password Validation Plugin. The password-validation plugin aims to test passwords strength and improve security\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-05T08:05:53+00:00\" \/>\n<meta name=\"author\" content=\"Gr\u00e9gory Steulet\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gr\u00e9gory Steulet\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/password-validation-in-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/password-validation-in-mysql\\\/\"},\"author\":{\"name\":\"Gr\u00e9gory Steulet\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/eae2ad4145ad07d92358ce1b4bbd7aff\"},\"headline\":\"Password Validation in MySQL\",\"datePublished\":\"2018-04-05T08:05:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/password-validation-in-mysql\\\/\"},\"wordCount\":348,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/password-validation-in-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/password-validation-in-mysql\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/password-validation-in-mysql\\\/\",\"name\":\"Password Validation in MySQL - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2018-04-05T08:05:53+00:00\",\"description\":\"MySQL provides a new security plugins named Password Validation Plugin. The password-validation plugin aims to test passwords strength and improve security\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/password-validation-in-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/password-validation-in-mysql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/password-validation-in-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Password Validation in MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/eae2ad4145ad07d92358ce1b4bbd7aff\",\"name\":\"Gr\u00e9gory Steulet\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/GRS_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/GRS_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/GRS_web-min-scaled.jpg\",\"caption\":\"Gr\u00e9gory Steulet\"},\"description\":\"Gr\u00e9gory Steulet is Partner Manager and CFO at dbi services. He previously served as CFO and COO of the Sequotech Group. Earlier in his career, he spent more than ten years in database and infrastructure management, with experience in Oracle technologies, high availability, Avaloq banking applications and open-source technologies such as MySQL and Unix\\\/Linux. Although his current role is no longer focused on database administration, he continues to share his experience through occasional blog posts. Before joining dbi services, Gr\u00e9gory was a Senior Consultant at Trivadis and an IT Administrator at Box Telecom. He holds an Executive MBA, a Bachelor's degree in Business Administration and Computer Science, and Certificates of Advanced Studies in Mergers and Acquisitions and Data Protection. His industry experience includes telecommunications, financial services, logistics and pharmaceuticals.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/gregory-steulet\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Password Validation in MySQL - dbi services Blog","description":"MySQL provides a new security plugins named Password Validation Plugin. The password-validation plugin aims to test passwords strength and improve security","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Password Validation in MySQL","og_description":"MySQL provides a new security plugins named Password Validation Plugin. The password-validation plugin aims to test passwords strength and improve security","og_url":"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2018-04-05T08:05:53+00:00","author":"Gr\u00e9gory Steulet","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Gr\u00e9gory Steulet","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/"},"author":{"name":"Gr\u00e9gory Steulet","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/eae2ad4145ad07d92358ce1b4bbd7aff"},"headline":"Password Validation in MySQL","datePublished":"2018-04-05T08:05:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/"},"wordCount":348,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/","url":"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/","name":"Password Validation in MySQL - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-04-05T08:05:53+00:00","description":"MySQL provides a new security plugins named Password Validation Plugin. The password-validation plugin aims to test passwords strength and improve security","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/password-validation-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Password Validation in MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/eae2ad4145ad07d92358ce1b4bbd7aff","name":"Gr\u00e9gory Steulet","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/GRS_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/GRS_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/GRS_web-min-scaled.jpg","caption":"Gr\u00e9gory Steulet"},"description":"Gr\u00e9gory Steulet is Partner Manager and CFO at dbi services. He previously served as CFO and COO of the Sequotech Group. Earlier in his career, he spent more than ten years in database and infrastructure management, with experience in Oracle technologies, high availability, Avaloq banking applications and open-source technologies such as MySQL and Unix\/Linux. Although his current role is no longer focused on database administration, he continues to share his experience through occasional blog posts. Before joining dbi services, Gr\u00e9gory was a Senior Consultant at Trivadis and an IT Administrator at Box Telecom. He holds an Executive MBA, a Bachelor's degree in Business Administration and Computer Science, and Certificates of Advanced Studies in Mergers and Acquisitions and Data Protection. His industry experience includes telecommunications, financial services, logistics and pharmaceuticals.","url":"https:\/\/www.dbi-services.com\/blog\/author\/gregory-steulet\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11078"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11078\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}