blob: f4d5d151e2aff12e1ee6341be82b4b1023501a73 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
#!/bin/bash
set -x
create_users_and_dbs() {
/usr/bin/mysqld_safe > /dev/null 2>&1 &
timeout=30
# wait up to 30 secs...
while ! /usr/bin/mysqladmin -u root status > /dev/null 2>&1
do
timeout=$(($timeout - 1))
if [ $timeout -eq 0 ]; then
echo -e "\nCould not connect to database server. Aborting..."
exit 1
fi
echo -n "."
sleep 1
done
echo "Creating user..."
mysqladmin -h127.0.0.1 --port=3306 -u root password root
mysql -h127.0.0.1 --port=3306 -uroot -proot -e "create database compass"
mysql -h127.0.0.1 --port=3306 -uroot -proot -e "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root'"
mysqladmin -uroot -proot shutdown
}
listen_on_all_interfaces() {
cat > /etc/mysql/conf.d/mysql-listen.cnf <<EOF
[mysqld]
bind-address=0.0.0.0
[mysqld_safe]
bind-address=0.0.0.0
EOF
}
if [ ! -f /etc/db_created ]; then
create_users_and_dbs
listen_on_all_interfaces
touch /etc/db_created
fi
/usr/bin/mysqld_safe
|
