Hack The Sec-Leading Resource Of Linux Tutorial: Disable_mysql

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" itemprop="headline">
How to Disable MySQL Strict Mode <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a>'s, and <a href="http://www.hackthesec.co.in/search/label/MaraiDB">MariaDB</a>'s, strict mode controls how invalid or missing values in data changing queries are handled; this includes INSERT, UPDATE, and CREATE TABLE statements. With strict mode enabled, which is the default state, invalid or missing data may cause warnings or errors when attempting to process the query.</h1>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk_GBnDAlvdhClBCGn5NtcSwdsMn5A1x2i8f5oTuZxiuKjHCzo_hAGQjp6a4qijIkrZP1hprkgjGxIN_HHx6yIN-CcLPMMGAHksZxBQ_g3eQwIF5Me92JDdOfyRSj2TD_-7r-HbpwB9r7e/s1600/mysql-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk_GBnDAlvdhClBCGn5NtcSwdsMn5A1x2i8f5oTuZxiuKjHCzo_hAGQjp6a4qijIkrZP1hprkgjGxIN_HHx6yIN-CcLPMMGAHksZxBQ_g3eQwIF5Me92JDdOfyRSj2TD_-7r-HbpwB9r7e/s1600/mysql-hackthesec.png" /></a></div>
<h1 class="entry-title" itemprop="headline">
When strict mode is disabled the same query would have its invalid, or missing, values adjusted and would produce a simple warning. This may seem like the preferred result, however with strict mode disabled certain actions may cause unexpected results; for instance, if the value being inserted exceeds the maximum character limit, then it will be truncated to fit the limit. Make Backups, Always! Whenever modifying files on a server it’s always best practice to take some form of a backup beforehand. This ensures you have a way to revert changes if something goes awry; it’s also beneficial because it helps track when and what changes were made. While logged into SSH with the root user, do the following:</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">cp -a /usr/my.cnf{,.strict.bak}
cp -a /etc/my.cnf{,.strict.bak}</pre>
<h1 class="entry-title" itemprop="headline">
Note: The above command uses 'BASH brace expansion' in order to make a backup copy of the file in its original directory. Edit the Configuration Files Depending on the server and the current configurations you may need to edit one, or both, of the following files on the server. Generally, the relevant configuration lines are only in one of them, however, it could be in either one without causing issues; so generally it’s best to check both. To edit the files, you will open the file with your favorite command line editor. In this example, we use 'vim'.</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">vim /usr/my.cnf
vim /etc/my.cnf</pre>
<h1 class="entry-title" itemprop="headline">
Within each file above you will be looking for a line with the following content:</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES</pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3idFl4fPIUSFLmSTgboyPHtduc7tRU8cGfGlJ9TqV6hYt86Wi_p2XC0jz_DrTkVfFnr0Qy98kEyhac-pkT1kgclbo3H_KzUYG0UqEiV97z6HrbyN3PLM-azS2AJIlW7fDLXgYfZp6rZVJ/s1600/sql_mode-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3idFl4fPIUSFLmSTgboyPHtduc7tRU8cGfGlJ9TqV6hYt86Wi_p2XC0jz_DrTkVfFnr0Qy98kEyhac-pkT1kgclbo3H_KzUYG0UqEiV97z6HrbyN3PLM-azS2AJIlW7fDLXgYfZp6rZVJ/s1600/sql_mode-hackthesec.png" /></a></div>
<h1 class="entry-title" itemprop="headline">
If you find a line similar to the above that is setting the "sql_mode" variable then you will need to replace it with the following line to disable MySQL strict mode.</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">sql_mode=""</pre>
<h1 class="entry-title" itemprop="headline">
Once this adjustment has been made, or you've confirmed the file does not need to be adjusted you will then save and close the file. Restart the MySQL Service Finally, to make these changes effective you will need to restart the MySQL service as it will only read the configuration files when it initially loads up. In order to force MySQL to use the new configuration files you will do the following:</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">systemctl restart mysql

/etc/init.d/mysql restart</pre>
<h1 class="entry-title" itemprop="headline">
After issuing this command on the server the MySQL service will be restarted and will load the changes made. If all the directions were followed and completed, then MySQL strict mode should now be disabled. To verify that the process was completed properly you can run the following:</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">mysql -e "SELECT @@sql_mode;"</pre>
<h1 class="entry-title" itemprop="headline">
The output may look similar to the following:</h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">+--------------------------------------------+
| @@sql_mode
+--------------------------------------------+
| NO_AUTO_CREATE_USER
+--------------------------------------------+</pre>
<h1 class="entry-title" itemprop="headline">
If you have any questions or are not comfortable making these changes yourself, please feel free to contact admin@hackthesec.co.in Thanks & Regards<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></h1>
</div>

How to Disable MySQL Strict Mode

How to Disable MySQL Strict Mode MySQL 's, and MariaDB 's, strict mode controls how invalid or missing values in data changing que...