You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
34 lines
1.3 KiB
34 lines
1.3 KiB
#!/bin/sh
|
|
|
|
if [ ! -d "/run/mysqld" ]; then
|
|
mkdir -p /run/mysqld && chown -R mysql:mysql /run/mysqld
|
|
fi
|
|
|
|
if [ ! -d "/var/lib/mysql/mysql" ]; then
|
|
|
|
chown -R mysql:mysql /var/lib/mysql
|
|
|
|
mysql_install_db --basedir=/usr --datadir=/var/lib/mysql --user=mysql --rpm > /dev/null
|
|
|
|
mysqld --user=mysql --bootstrap << EOF
|
|
USE mysql;
|
|
FLUSH PRIVILEGES;
|
|
DELETE FROM mysql.user WHERE User='';
|
|
DROP DATABASE test;
|
|
DELETE FROM mysql.db WHERE Db='test';
|
|
DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');
|
|
ALTER USER 'root'@'localhost' IDENTIFIED BY '$MYSQL_ROOT_PWD';
|
|
CREATE DATABASE $WP_DATABASE_NAME CHARACTER SET utf8 COLLATE utf8_general_ci;
|
|
CREATE USER '$WP_DATABASE_USR'@'%' IDENTIFIED by '$WP_DATABASE_PWD';
|
|
GRANT ALL PRIVILEGES ON $WP_DATABASE_NAME.* TO '$WP_DATABASE_USR'@'%';
|
|
|
|
CREATE DATABASE $GITEA_DATABASE_NAME CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci';
|
|
CREATE USER '$GITEA_DATABASE_USR'@'%' IDENTIFIED BY '$GITEA_DATABASE_PWD';
|
|
GRANT ALL PRIVILEGES ON $GITEA_DATABASE_NAME.* TO '$GITEA_DATABASE_USR'@'%';
|
|
FLUSH PRIVILEGES;
|
|
EOF
|
|
fi
|
|
sed -i "s|skip-networking|# skip-networking|g" /etc/my.cnf.d/mariadb-server.cnf
|
|
sed -i "s|.*bind-address\s*=.*|bind-address=0.0.0.0|g" /etc/my.cnf.d/mariadb-server.cnf
|
|
|
|
mysqld --user=mysql --console
|
|
|