MySQL Forums
Forum List  »  Install & Repo

Changes to My.inii file or something else
Posted by: Deborah Bauer
Date: June 30, 2018 02:50PM

These are errors that pop up in computername.ERR file when I start MySQL80

I changed the My.ini file for the first two items:

---------------------------------------------------

2018-06-30T17:27:17.039269Z 0 [Warning] [MY-011071] [Server] option 'read_buffer_size': unsigned value 0 adjusted to 8192

2018-06-30T17:27:17.039304Z 0 [Warning] [MY-011071] [Server] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1

-------------------------------------------------------------------------
But I did not know what to change or where for the next two items as I could not find these in the My.ini file. I am running the community MYSQL80 on a standalone computer for learning purposes. Please give me valuable advice as I am trying to learn, saying ignore without why does not help me learn.
-------------------------------------------------------------------------

2018-06-30T17:27:17.039355Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.

2018-06-30T17:27:17.041961Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.11) starting as process 12144
2018-06-30T17:27:18.791023Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

Options: ReplyQuote


Subject
Written By
Posted
Changes to My.inii file or something else
June 30, 2018 02:50PM


Sorry, you can't reply to this topic. It has been closed.

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.