1 rule apt_get_install mysql-server-5.5
2 rule insserv_remove mysql
13 rule adduser mysql-data \
21 sudo usermod
--home "$home" mysql
22 sudo adduser mysql mysql-data
23 sudo
install -d -m 755 -o mysql
-g mysql \
26 sudo
rm -rf /etc
/mysql
27 sudo
install -d -m 750 -o mysql
-g mysql \
34 sudo
install -m 644 -o mysql
-g mysql \
35 "$tool"/etc
/mysql
/my.cnf \
37 if sudo
test ! -d "$home"/data
39 sudo
install -d -m 750 -o mysql
-g mysql-data \
41 sudo
-u mysql mysql_install_db \
42 --datadir="$home"/data \
46 sudo
find "$tool"/etc
/mysql
/bin
/ -type f
-perm /+x
-exec \
47 install -m 755 -o root
-g root \
48 -t /home
/mysql
/bin
/ {} +
53 rule runit_sv_start
"$sv"
54 while ! sudo
-u mysql mysql
-u mysql
</dev
/null
58 # - ajoute l'accès par socket Unix à mysql
59 # - ajoute les droits de super-utilisateur à mysql
60 # - supprime l'accès par mot-de-passe à root
61 # - supprime les bases de données de l'utilisateurice anonyme
62 # - supprime l'utilisateurice anonyme
64 # GRANT USAGE ON *.* TO 'root'@'*' IDENTIFIED WITH auth_socket;
65 # CREATE USER 'root'@'localhost' IDENTIFIED WITH auth_socket;
66 # UPDATE mysql.user SET Password='' WHERE user='root';
67 # DELETE FROM mysql.user WHERE user = 'root' AND host NOT IN ('localhost', '127.0.0.1', '::1');
68 sudo mysql
-u root
--batch --verbose <<-EOF
69 DELETE FROM mysql.user WHERE user = 'root' and plugin = '';
70 DROP PROCEDURE IF EXISTS mysql.create_user_mysql;
72 CREATE PROCEDURE mysql.create_user_mysql ()
74 IF NOT (EXISTS (SELECT User
79 THEN GRANT ALL PRIVILEGES ON *.* TO 'mysql'@'localhost' IDENTIFIED WITH auth_socket;
83 CALL mysql.create_user_mysql();
84 DROP PROCEDURE mysql.create_user_mysql;
85 UPDATE mysql.user SET grant_priv='Y',super_priv='Y' WHERE user='mysql';
86 DELETE FROM mysql.db WHERE user = '';
87 DELETE FROM mysql.user WHERE user = '';
88 DROP PROCEDURE IF EXISTS mysql.create_user;
89 CREATE PROCEDURE mysql.create_user (username VARCHAR(16), hostname VARCHAR(60))
91 IF NOT (EXISTS (SELECT User
97 SET @QUERY = CONCAT("CREATE USER ", username, "@", hostname, " IDENTIFIED WITH auth_socket");
98 PREPARE stmt FROM @QUERY;