Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 33818

All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

3
votes
2answers
Context: MySQL version On MySQL 5.7.17 (as shown by SHOW VARIABLES LIKE "%version%";) Context: MySQL timezone settings and with SELECT @@global.time_zone, @@session.time_zone; yielding … and date values are not stored with timezone information in MySQL (there is no clear description of this in The DATE, DATETIME, and TIMESTAMP Types, except "MySQL converts TIMESTAMP values from the …
asked Feb 14 '18 by David Tonhofer
0
votes
Based on this documentation from Red Hat: Chapter 3. SELinux Contexts and man page reading: I want to have logfiles in /var/log/mysql instead of /var/log/mariadb and leave SELinux enabled. The … newly created log directory /var/log/mysql will by default be unaccessible to MySQL server due to SELinux. So: grep for string setroubleshoot in /var/log/ and run the indicated sealert commands to find …
answered Oct 8 '18 by David Tonhofer
0
votes
According to the page mysql.user Table at the very bottom: When the plugin column is empty, MariaDB defaults to authenticating accounts with either the mysql_native_password or the mysql_old …
answered Dec 5 '18 by David Tonhofer