From add2c2ba2ec0e3fd18b6f6612dda6ab78ea6affd Mon Sep 17 00:00:00 2001 From: Ryan Coe Date: Mon, 3 Feb 2020 17:21:53 -0800 Subject: [PATCH] package/mariadb: fix permissions of data dir when using systemd mysql_install_db is currently called in the systemd unit without --user=mysql that the sysv script uses. This will generate the initial database files with root permissions. However, mysqld runs as user mysql so this will cause problems. We fix this by calling chown instead of passing the user parameter because an upcoming version bump will fail when ran this way. Signed-off-by: Ryan Coe Signed-off-by: Peter Korsgaard --- package/mariadb/mysqld.service | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/package/mariadb/mysqld.service b/package/mariadb/mysqld.service index cd308310c6..3eaef173e1 100644 --- a/package/mariadb/mysqld.service +++ b/package/mariadb/mysqld.service @@ -2,7 +2,7 @@ Description=MySQL database server [Service] -ExecStartPre=/bin/sh -c 'test "`ls -1 /var/lib/mysql | wc -l`" != "0" || mysql_install_db --basedir=/usr --datadir=/var/lib/mysql' +ExecStartPre=/bin/sh -c 'test "`ls -1 /var/lib/mysql | wc -l`" != "0" || mysql_install_db --basedir=/usr --datadir=/var/lib/mysql && chown -R mysql:mysql /var/lib/mysql' ExecStart=/usr/bin/mysqld_safe Restart=always User=mysql -- 2.30.2