761286 - Database needed for jstestnet-dev.allizom.org on dev1.db.phx1

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Brandon Burton [:solarce]]

Please create the following on dev1.db.phx1

1. database named jstestnet_dev
2. user named jstestnet_dev and password
3. access should be from genericrhel6, same as treestatus_dev

Comment 1

[Sheeri Cabral [:sheeri]]

Made!


mysql> create database jstestnet_dev;
Query OK, 1 row affected (0.02 sec)

mysql> select user,host from mysql.user where user='treestatus_dev';
+----------------+-------------+
| user           | host        |
+----------------+-------------+
| treestatus_dev | 10.8.70.20_ |
+----------------+-------------+
1 row in set (0.01 sec)

mysql> grant all on jstestnet_dev.* to jstestnet_dev@'10.8.70.20_' identified by 'EDLIDED';
Query OK, 0 rows affected (0.05 sec)

mysql> grant all on jstestnet_dev.* to jstestnet_dev@'10.8.70.21_' identified by 'ELIDED';
Query OK, 0 rows affected (0.01 sec)