# localhost which is more compatible and is not less secure. # Instead of skip-networking the default is now to listen only on Sql-mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' # The following values assume you have at least 32M ram # Here is entries for some specific programs # Remember to edit /etc/mysql/debian.cnf when changing the socket location. # It has been reported that passwords should be enclosed with ticks/quotes

# This will be passed to all mysql clients # -print-defaults to see which it would actually understand and use. # Run program with -help to get a list of available options and with # One can use all long options that the program supports. # - '~/.my.cnf' to set user-specific options. # - '/etc/mysql/my.cnf' to set global options, # The MySQL database server configuration file. Remove the file /etc/mysql/my.cnf.migrated Run 'update-alternatives -remove my.cnf /etc/mysql/my.cnf.migrated' Move your customisations from this file to /etc/mysql/conf.d/ and # /etc/mysql/my.cnf across multiple variants: # To switch to the new packaging configuration for automated management of # operation using your previously customised configuration. # /etc/mysql/my.cnf, with just this comment added at the top, to maintain MySQL The full contents of the my.cnf file information is posted below: # This file has been automatically moved from your previous Weirdly, the file always seems to revert back to full rights for everyone (777). Mysql won’t run and I end up removing and reinstalling mysql 8 all over again. When I attempt to restrict access to the my.cnf file by doing the following: chown mysql:mysql /etc/mysql/my.cnf

However, I need to do things like load data from files stored on the server and need to configure things like sql_mode to respect these scenarios. which, upon first installation of the mysql 8 ignores that file (because it’s listed as world writeable) and runs msyql fine. I have a my.cnf file located in /etc/mysql/. I recently upgraded to Ubuntu 20.04 and mysql8.

Mysql community server limitation