Date: Monday, December 31, 2018 @ 15:40:21 Author: mtorromeo Revision: 420029
fixed error in my.cnf Modified: percona-server/trunk/PKGBUILD percona-server/trunk/my.cnf ----------+ PKGBUILD | 2 +- my.cnf | 28 ++++++++++++---------------- 2 files changed, 13 insertions(+), 17 deletions(-) Modified: PKGBUILD =================================================================== --- PKGBUILD 2018-12-31 14:56:11 UTC (rev 420028) +++ PKGBUILD 2018-12-31 15:40:21 UTC (rev 420029) @@ -20,7 +20,7 @@ 'rocksdb-systemlibs.patch') sha256sums=('ab00626775b85ea506c1d992d66acee50f0bfbde54b830731f61652e87ff93da' '8aa4e330c870ef50a896634c931adf468b21f8a69b77007e45c444151229f665' - 'ae451839c368f0db25a63bb0a6a890194897a8e74818bd4245140933c29e5f83' + 'b467b04d6d06152b2abc33f2a6de63fef0fc922dd5119d2ee1d07d3c1a489731' 'e638a2657085f15b6728f43c1fd6aa551b27608fbf6b435e33afd3606a0cfb0e' '1537fdbb92dd1c135c1eb9f4d10c44fd02e652db66c933d731990a1196f1397c' 'fe1cb2b079c56ff0f827c7dfb25d004b2190410406820c490dc6152cfe392b70' Modified: my.cnf =================================================================== --- my.cnf 2018-12-31 14:56:11 UTC (rev 420028) +++ my.cnf 2018-12-31 15:40:21 UTC (rev 420029) @@ -1,24 +1,19 @@ # For advice on how to change settings please see -# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html +# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html [client] -#password = your_password -port = 3306 socket = /run/mysqld/mysqld.sock [mysqld] -port = 3306 -socket = /run/mysqld/mysqld.sock -datadir = /var/lib/mysql - # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # -# Remove leading # to turn on a very important data integrity option: logging -# changes to the binary log between backups. -# log_bin +# Remove the leading "# " to disable binary logging +# Binary logging captures changes between backups and is enabled by +# default. It's default setting is log_bin=binlog +# disable_log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. @@ -26,13 +21,14 @@ # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M +# +# Remove leading # to revert to previous value for default_authentication_plugin, +# this will increase compatibility with older clients. For background, see: +# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin +# default-authentication-plugin=mysql_native_password -# Disabling symbolic-links is recommended to prevent assorted security risks -symbolic-links=0 +datadir = /var/lib/mysql +socket = /run/mysqld/mysqld.sock -# Recommended in standard MySQL setup -sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES - -[mysqld_safe] log-error = /var/log/mysqld.log pid-file = /run/mysqld/mysqld.pid