Editing revision 8 of MySQL

Data is in /var/lib/mysql Config is in /etc/mysql/conf.d/mysql.cnf /etc/systemd/system/mariadb.service.d/local.conf and possibly ... after you change the second file systemctl daemon-reload ... and then for either: systemctl restart mariadb Tuning code * wget https://github.com/major/MySQLTuner-perl/tarball/master * tar xf master * cd major-MySQLTuner-perl-993bc18/ ./mysqltuner.pl * 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: