1 |
dpavlin |
25 |
################################################################ |
2 |
|
|
# WARNING - DO NOT run this script against a production system # |
3 |
|
|
# with LibData currently installed. # |
4 |
|
|
################################################################ |
5 |
|
|
|
6 |
|
|
# Create libdata |
7 |
|
|
CREATE DATABASE libdata; |
8 |
|
|
|
9 |
|
|
# Create libstats |
10 |
|
|
CREATE DATABASE libstats; |
11 |
|
|
|
12 |
|
|
# Create libsession |
13 |
|
|
CREATE DATABASE libsession; |
14 |
|
|
|
15 |
|
|
# Insert users into mysql.user table |
16 |
|
|
INSERT INTO mysql.user VALUES ('%', 'libsession', password('ch4ngeME'), |
17 |
|
|
'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N','N','N','N','N','N','N'); |
18 |
|
|
INSERT INTO mysql.user VALUES ('%', 'libdata', password('changEth1s'), |
19 |
|
|
'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N','N','N','N','N','N','N'); |
20 |
|
|
|
21 |
|
|
# Insert database/users from mysql.db table |
22 |
|
|
INSERT INTO mysql.db VALUES ('%', 'libsession', 'libsession', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N'); |
23 |
|
|
INSERT INTO mysql.db VALUES ('%', 'libdata', 'libdata', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); |