1 "$tool"/local
/apt-get-install mysql-server-5.5
2 "$tool"/local
/insserv-remove mysql
6 "$tool"/local
/adduser
"$sv" \
13 "$tool"/local
/adduser
"$sv"-data \
21 sudo usermod
--home "$home" "$sv"
22 sudo adduser
"$sv" "$sv"-data
23 sudo
install -d -m 755 -o "$sv" -g "$sv" \
25 sudo
rm -rf /etc
/mysql
26 sudo
install -d -m 750 -o "$sv" -g "$sv"-data \
33 sudo
install -m 644 -o "$sv" -g "$sv" \
34 "$tool"/etc
/mysql
/my.cnf \
36 if sudo
test ! -d "$home"/data
38 sudo
install -d -m 750 -o "$sv" -g "$sv"-data \
40 sudo
-u "$sv" mysql_install_db \
41 --datadir="$home"/data \
48 "$tool"/local
/runit-sv-start
"$sv"
49 while ! sudo mysql
-u root
</dev
/null
52 sudo mysql
-u root
--batch --verbose <<-EOF
53 -- NOTE: supprime le login anonyme
54 DELETE FROM mysql.db WHERE User = '';
55 DELETE FROM mysql.user WHERE User = '';
57 -- NOTE: supprime l'accès par mot-de-passe à root
58 DELETE FROM mysql.user WHERE User = 'root' and Plugin = '';
60 DROP PROCEDURE IF EXISTS mysql.create_super_user;
62 CREATE PROCEDURE mysql.create_super_user (username VARCHAR(16), hostname VARCHAR(60))
64 IF NOT (EXISTS (SELECT User
70 SET @QUERY = CONCAT("CREATE USER ", username, "@", hostname, " IDENTIFIED WITH auth_socket");
71 PREPARE stmt FROM @QUERY;
77 CALL mysql.create_super_user('mysql', 'localhost');
78 GRANT ALL PRIVILEGES ON *.* TO 'mysql'@'localhost';
79 UPDATE mysql.user SET Grant_priv='Y',Super_priv='Y' WHERE User='mysql';
81 CALL mysql.create_super_user('backup', 'localhost');
82 GRANT EVENT,LOCK TABLES,RELOAD,SELECT,SHOW VIEW ON *.* TO 'backup'@'localhost';
86 sudo adduser backup
"$sv"-data
87 sudo adduser backup
"$sv"
89 sudo
find "$tool"/local
/backup \
90 -mindepth 1 -maxdepth 1 -type f
-perm /+x \
92 -exec install -m 750 -o backup
-g backup \
94 sudo
install -m 640 -o root
-g root \
95 "$tool"/etc
/cron.d
/mysql-backup \
96 /etc
/cron.d
/mysql-backup
97 sudo
install -m 640 -o root
-g root \
98 "$tool"/etc
/sudoers.d
/mysql-backup \
99 /etc
/sudoers.d
/mysql-backup