<?xml version="1.0"?>

<rss version="2.0">


<channel>
<title>Home - All Categories - MySQL  - Configuration  </title>
<link>https://www.navel.ir/category/mysql/configuration/</link>
<description>This RSS Feed contains Articles of Category in the knowledge base. You can click on the title to view its content. Powered by PHPKB Knowledge Base Software (http://www.knowledgebase-script.com)</description>
<item>
										<guid>https://www.navel.ir/article/warning-no_auto_create_user-sql-mode-was-not-set-34.html</guid>
										<title>[Warning] `NO_AUTO_CREATE_USER` sql mode was not set.</title>
										<link>https://www.navel.ir/article/warning-no_auto_create_user-sql-mode-was-not-set-34.html</link>
										<description><![CDATA[[mysqld]sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER,STRICT_TRANS_TABLESReference: https://stackoverflow.com/questions/2317650/setting-global-sql-mode-in-mysqlhttps://dba.stackexchange.com/questions/120421/mysql-5-7-9-log-set-session-mode...]]></description>

									</item>
<item>
										<guid>https://www.navel.ir/article/how-to-enable-explicit_defaults_for_timestamp-33.html</guid>
										<title>How to enable explicit_defaults_for_timestamp?</title>
										<link>https://www.navel.ir/article/how-to-enable-explicit_defaults_for_timestamp-33.html</link>
										<description><![CDATA[explicit_defaults_for_timestamp = 1 &nbsp; Reference: https://stackoverflow.com/questions/15701636/how-to-enable-explicit-defaults-for-timestamp]]></description>

									</item>
<item>
										<guid>https://www.navel.ir/article/show-variables-statement-32.html</guid>
										<title>SHOW VARIABLES Statement</title>
										<link>https://www.navel.ir/article/show-variables-statement-32.html</link>
										<description><![CDATA[mysql&gt;SHOWVARIABLES; &nbsp; Reference: https://dev.mysql.com/doc/refman/5.7/en/show-variables.html]]></description>

									</item>
<item>
										<guid>https://www.navel.ir/article/mysql-mariadb-error-on-the-server-with-plesk-could-not-increase-number-of-max_open_files-to-more-than-16384-134.html</guid>
										<title>MySQL/MariaDB error on the server with Plesk: Could not increase number of max_open_files to more than 16384</title>
										<link>https://www.navel.ir/article/mysql-mariadb-error-on-the-server-with-plesk-could-not-increase-number-of-max_open_files-to-more-than-16384-134.html</link>
										<description><![CDATA[ Applicable to:  Plesk for Linux   Symptoms   The following error can be seen when checking MySQL/MariaDB status via the&nbsp; systemctl status mariadb &nbsp;command: [Warning] Could not increase number of max_open_files to more than 16384 (request:...]]></description>

									</item>
<item>
										<guid>https://www.navel.ir/article/how-can-i-disable-mysql-strict-mode-38.html</guid>
										<title>How can I disable MySQL Strict Mode?</title>
										<link>https://www.navel.ir/article/how-can-i-disable-mysql-strict-mode-38.html</link>
										<description><![CDATA[This is enabled by default, but you can disable it in one of a couple ways. First, verify which mode(s) MYSQL is running with: $ mysql -u root -p -e "SHOWVARIABLESLIKE&#039;sql_mode&#039;;" &nbsp; 1. To Disable Strict Mode via SQL: You can disable...]]></description>

									</item>
<item>
										<guid>https://www.navel.ir/article/how-do-i-disable-strict-mode-in-mysql-37.html</guid>
										<title>How do I disable Strict Mode in MySQL?</title>
										<link>https://www.navel.ir/article/how-do-i-disable-strict-mode-in-mysql-37.html</link>
										<description><![CDATA[ Look for the following line:sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" Change it to:sql-mode="" (Blank) Restart&nbsp;the&nbsp;MySQL Service.  &nbsp; Reference: https://www.knowledgebase-script.com/kb/article/how-do-i...]]></description>

									</item>
<item>
										<guid>https://www.navel.ir/article/mysql-php-get-and-echo-now-value-35.html</guid>
										<title>MySQL-PHP get and echo NOW() value?</title>
										<link>https://www.navel.ir/article/mysql-php-get-and-echo-now-value-35.html</link>
										<description><![CDATA[mysqlddefault-time-zone=&#039;timezone&#039;SETGLOBAL time_zone =timezone; &lt;?php$query = "SELECT NOW() as `now`";$result = $mysqli-&gt;query($query);$row = $result-&gt;fetch_array();$now = $row[&#039;now&#039;];echo "$now&#92;n";?&gt; Reference...]]></description>

									</item>
<item>
										<guid>https://www.navel.ir/article/your-password-does-not-satisfy-the-current-policy-requirements-28.html</guid>
										<title>Your Password does not satisfy the Current Policy Requirements</title>
										<link>https://www.navel.ir/article/your-password-does-not-satisfy-the-current-policy-requirements-28.html</link>
										<description><![CDATA[SHOW VARIABLES LIKE &#039;validate_password%&#039;;SET GLOBAL validate_password_policy=LOW; [mysqld]validate_password_policy=LOW Code:# mysql -u root &ndash;pThe statement given below is used to remove the installed validate_password plugin. Code...]]></description>

									</item>
<item>
										<guid>https://www.navel.ir/article/how-to-change-the-mysql-root-account-password-on-centos7-13.html</guid>
										<title>How to change the MySQL root account password on CentOS7?</title>
										<link>https://www.navel.ir/article/how-to-change-the-mysql-root-account-password-on-centos7-13.html</link>
										<description><![CDATA[1. Stop mysql:systemctl stop mysqld 2. Set the mySQL environment option systemctl set-environment MYSQLD_OPTS="--skip-grant-tables" 3. Start mysql usig the options you just setsystemctl start mysqld 4. Login as rootmysql -u root 5. Update the root...]]></description>

									</item>

</channel>

</rss>