Differences

This shows you the differences between two versions of the page.

--- public:radio:dormant:yaddnet_migration [14/04/24 02:32 BST] – [Tweaks] john
+++ public:radio:dormant:yaddnet_migration [06/03/25 06:49 GMT] (current) – external edit 127.0.0.1
@@ Line 13: / Line 13: @@
 Server IP:  64.235.39.127
-Users & Server SSH port : see [[private:yaddnet_server|]]
 ==== Create SQL database ====
@@ Line 26: / Line 26: @@
-=== The original Procesee ===
+=== The original Process ===
 ) sort out passwordless root access to MySQL
@@ Line 129: / Line 129: @@
   sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
   restart mysql
-In UBUNTU 20.4.... add the sql-mode stuff ''/lib/systemd/system/mysql.service''
-<code>
-# MySQL systemd service file
-[Unit]
-Description=MySQL Community Server
-After=network.target
-[Install]
-WantedBy=multi-user.target
-[Service]
-Type=notify
-User=mysql
-Group=mysql
-PIDFile=/run/mysqld/mysqld.pid
-PermissionsStartOnly=true
-ExecStartPre=/usr/share/mysql/mysql-systemd-start pre
-ExecStart=/usr/sbin/mysqld  --sql-mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
-TimeoutSec=infinity
-Restart=on-failure
-RuntimeDirectory=mysqld
-RuntimeDirectoryMode=755
-LimitNOFILE=10000
-# Set enviroment variable MYSQLD_PARENT_PID. This is required for restart.
-Environment=MYSQLD_PARENT_PID=1
-~
-~
-</code>
-Then
-  systemctl daemon-reload
-  systemctl restart mysql
 This (among other things) allows the group-by queries to work.