MySQL Forums
Forum List  »  Newbie

Re: MySQL Error Log
Posted by: Zach Ellis
Date: October 03, 2023 05:06PM

Hello Paul Grimes

I'm new to mysql dba so if someone more experienced comes go with them.

threads about the bottom three warnings might have the answer to that has the same format of the warnings

this link below is from the oracle support team didn't look at it needed to make an account to view it but it matches with the version your using 5.7. You can make an account to go through it.

from the manual regarding the first warning

This system variable determines whether the server enables certain nonstandard
behaviors for default values and NULL-value handling in TIMESTAMP columns. By default, explicit_defaults_for_timestamp is enabled, which disables the nonstandard behaviors. Disabling explicit_defaults_for_timestamp results in a warning.

if you want that error gone you have to enable it. The variable is dynamic so you don't have to reset the server.

beside from the warnings was there anything else or was it just those warnings

hope this helps
Zach Ellis

Options: ReplyQuote

Written By
October 03, 2023 03:57AM
Re: MySQL Error Log
October 03, 2023 05:06PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.