diff options
| author | Charles <sircharlesaze@gmail.com> | 2020-02-22 05:03:12 +0100 |
|---|---|---|
| committer | Charles <sircharlesaze@gmail.com> | 2020-02-22 05:03:12 +0100 |
| commit | f128d6470b18ef8fff4e6ce0b269b2b673ab91ca (patch) | |
| tree | 56241f649a3f829735ee98811cbe8ffa8238dea0 /srcs/mysql/scripts | |
| parent | dc44b6fa6c2e52d80e228704888fc2b89a3d0c44 (diff) | |
| download | ft_services-f128d6470b18ef8fff4e6ce0b269b2b673ab91ca.tar.gz ft_services-f128d6470b18ef8fff4e6ce0b269b2b673ab91ca.tar.bz2 ft_services-f128d6470b18ef8fff4e6ce0b269b2b673ab91ca.zip | |
mysql base (WIP), nginx config from ft_server
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; |