diff options
Diffstat (limited to 'srcs/mysql/scripts')
| -rwxr-xr-x | srcs/mysql/scripts/setup_mysql.sh | 8 | ||||
| -rwxr-xr-x | srcs/mysql/scripts/setup_mysql_db.sql | 5 |
2 files changed, 13 insertions, 0 deletions
diff --git a/srcs/mysql/scripts/setup_mysql.sh b/srcs/mysql/scripts/setup_mysql.sh new file mode 100755 index 0000000..56f767f --- /dev/null +++ b/srcs/mysql/scripts/setup_mysql.sh @@ -0,0 +1,8 @@ +#!/bin/sh + +addgroup mysql mysql + +MYSQLD_DIR=/run/mysqld + +mkdir $MYSQLD_DIR +chown mysql:mysql $MYSQL_DIR diff --git a/srcs/mysql/scripts/setup_mysql_db.sql b/srcs/mysql/scripts/setup_mysql_db.sql new file mode 100755 index 0000000..ea66998 --- /dev/null +++ b/srcs/mysql/scripts/setup_mysql_db.sql @@ -0,0 +1,5 @@ +CREATE DATABASE wordpressdb; +CREATE USER 'wordpressuser'@'localhost' IDENTIFIED BY 'wordpresspass'; +GRANT ALL PRIVILEGES ON wordpressdb.* TO 'wordpressuser'@'localhost' +IDENTIFIED BY 'wordpresspass'; +FLUSH PRIVILEGES; |
