1 |
################################################################ |
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'); |