diff options
| -rwxr-xr-x | InstallItAll.sh | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/InstallItAll.sh b/InstallItAll.sh index b7077b8..15f7c03 100755 --- a/InstallItAll.sh +++ b/InstallItAll.sh | |||
| @@ -47,7 +47,9 @@ sudo /etc/init.d/mysql restart | |||
| 47 | 47 | ||
| 48 | echo "Setting up OpenSim users. This next prompt asks for your MySQL root users password." | 48 | echo "Setting up OpenSim users. This next prompt asks for your MySQL root users password." |
| 49 | # "create user if not exists" doesn't exist until MySQL 5.7, so we have to put up with a warning, which we can ignore. | 49 | # "create user if not exists" doesn't exist until MySQL 5.7, so we have to put up with a warning, which we can ignore. |
| 50 | mysql -u root -p -h localhost << zzzzEOFzzz | 50 | # Recent Debian based systems install with a passwordless root account, but it only works if run as the OS root user. |
| 51 | # Otherwise you can't get in. Yep, the -p seems to still be needed. | ||
| 52 | sudo mysql -u root -p -h localhost << zzzzEOFzzz | ||
| 51 | create database if not exists $MYSQL_DB; | 53 | create database if not exists $MYSQL_DB; |
| 52 | create user '$MYSQL_USER' identified by '$MYSQL_PASSWORD'; | 54 | create user '$MYSQL_USER' identified by '$MYSQL_PASSWORD'; |
| 53 | create user '$MYSQL_USER'@localhost identified by '$MYSQL_PASSWORD'; | 55 | create user '$MYSQL_USER'@localhost identified by '$MYSQL_PASSWORD'; |