KB Home | Advanced Search | News | Glossary | Login
Navel Knowledge Base Logo
Home » Categories » MySQL » Configuration
All Categories
Expand
Category
Apache (16)
Expand
Category
App Tools (4)
Expand
Category
CentOS (11)
Expand
Category
CMS (2)
Expand
Category
CSS Tricks (4)
Expand
Category
Electronis > (1)
Expand
Category
JavaScript (9)
Expand
Category
jQuery (5)
Expand
Category
Linux Command Line (13)
Expand
Category
MikroTik (1)
Collapse
Category
MySQL (23)
Expand
Category
Command Line (2)
Collapse
Category
Configuration (8)
article
[Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.
article
How to enable explicit_defaults_for_timestamp?
article
SHOW VARIABLES Statement
article
How do I disable Strict Mode in MySQL?
article
MySQL-PHP get and echo NOW() value?
article
Your Password does not satisfy the Current Policy Requirements
article
How to change the MySQL root account password on CentOS7?
article
How can I disable MySQL Strict Mode?
Expand
Category
phpMyAdmin (1)
article
How to change the MySQL root account password on CentOS7?
article
Optimizing query for large number of rows in mysql
article
UTF8 DB Text Fix
article
mysqldump exports only one table
article
How to export a mysql database using Command Prompt?
article
How do I import an SQL file using the command line in MySQL?
article
LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
article
Export and Import all MySQL databases at one time
article
Server error: Connection reset by peer | End of script output before headers
article
"End of script output before headers" in Apache + PHP
article
Incorrect string value: ’\xF0\x9F\x8E\xB6\xF0\x9F...’ MySQL
article
Host ’xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
Expand
Category
Network (1)
Expand
Category
Nginx (1)
Expand
Category
PHP (12)
Expand
Category
PHP Tricks (2)
Expand
Category
Smarty (1)
empty
Category
Smarty Tricks (0)
Expand
Category
SSL (1)
Expand
Category
Third-party (2)
Expand
Category
TypeScript (1)
Expand
Category
Virtualization (18)
Expand
Category
VMware (1)
Expand
Category
Webmin (10)
Expand
Category
Windows (6)
Expand
Category
WordPress (9)
Configuration Articles RSS FeedIcon Subscriber Subscribe
[Warning] ’NO_AUTO_CREATE_USER’ sql mode was not set.
Viewed 2002 times since Sun, Sep 27, 2020
[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... Read More
How to enable explicit_defaults_for_timestamp?
Viewed 1033 times since Sun, Sep 27, 2020
explicit_defaults_for_timestamp = 1   Reference: https://stackoverflow.com/questions/15701636/how-to-enable-explicit-defaults-for-timestamp Read More
SHOW VARIABLES Statement
Viewed 656 times since Sun, Sep 27, 2020
mysql>SHOWVARIABLES;   Reference: https://dev.mysql.com/doc/refman/5.7/en/show-variables.html Read More
How can I disable MySQL Strict Mode?
Viewed 769 times since Mon, Sep 28, 2020
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'sql_mode';"   1. To Disable Strict Mode via SQL: You can disable... Read More
How do I disable Strict Mode in MySQL?
Viewed 667 times since Mon, Sep 28, 2020
Look for the following line:sql-mode = "STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" Change it to:sql-mode="" (Blank) Restart the MySQL Service.   Reference: https://www.knowledgebase-script.com/kb/article/how-do-i... Read More
MySQL-PHP get and echo NOW() value?
Viewed 626 times since Mon, Sep 28, 2020
mysqlddefault-time-zone='timezone'SETGLOBAL time_zone =timezone; <?php$query = "SELECT NOW() as `now`";$result = $mysqli->query($query);$row = $result->fetch_array();$now = $row['now'];echo "$now\n";?> Reference... Read More
Your Password does not satisfy the Current Policy Requirements
Viewed 595 times since Sat, Sep 19, 2020
SHOW VARIABLES LIKE 'validate_password%';SET GLOBAL validate_password_policy=LOW; [mysqld]validate_password_policy=LOW Code:# mysql -u root –pThe statement given below is used to remove the installed validate_password plugin. Code... Read More
How to change the MySQL root account password on CentOS7?
Viewed 553 times since Sat, Sep 5, 2020
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... Read More
 
Subscribe to knowledgebase
Get notified when new articles are added to the knowledgebase.