Editing MySQL

Data is in /var/lib/mysql Config files: * THIS IS THE REAL ONE: /etc/mysql/conf.d/mysql.cnf * /etc/mysql/my.cnf <-- all this does is include everything in /etc/mysql/conf.d/ * /etc/systemd/system/mariadb.service.d/local.conf is automatically generated? * the defaults, I think, are in /etc/alternatives/my.cnf ... after you change THE REAL ONE systemctl daemon-reload ... and then for either: systemctl restart mariadb Tuning code wget https://raw.githubusercontent.com/BMDan/tuning-primer.sh/main/tuning-primer.sh chmod u+x that then run it * is in daniel/major-MySQLTuner-perl-5aa880a/ Status: systemctl status mariadb See log: journalctl -u mariadb.service ==2023-01-27== add bind-address=127.0.0.1 # to prevent connections from outside of the machine ... and change logging to "local1" ==2021-05-30== Upgrade from 10.1 to 10.3 Following directions from https://mariadb.com/docs/deploy/upgrade-community-server-cs103-debian9/ create /data/backup/preupgrade_backup mariabackup --backup -uroot --target-dir=/data/backup/preupgrade_backup mariabackup --prepare --target-dir=/data/backup/preupgrade_backup apt remove * "mariadb-*" * galeria-3 * libmariadbclient-dev * libmariadbclient-dev-compat * libmariadbclient18 And then. * "mariadb_repo_setup" failed * install mariadb-server mariadb-backup * set the root password. * apt install libdbd-mysql-perl ==2010-03== cswmysql5 startup file, /etc/opt/csw/init.d/cswmysql5: change MYSQL_VAR=/var/opt/csw/mysql5 to MYSQL_VAR=/local/mysql ==2008-12== installing Perl 5.8.9, to hook up mysql, to cope with gcc: language strconst not recognized gcc: language strconst not recognized edit the Makefile and remove ''-xstrconst and -mt''

Summary:

This change is a minor edit.

Username: