This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 40dee07b284 Add init-authority.sql (#19533)
40dee07b284 is described below
commit 40dee07b2846bf9c1a83559a2412e4e8a1bfaac7
Author: Liang Zhang <[email protected]>
AuthorDate: Wed Jul 27 09:58:35 2022 +0800
Add init-authority.sql (#19533)
* Refactor InsertCipherNameTokenGeneratorTest
* Add init-authority.sql
* Add init-authority.sql
* Add init-authority.sql
* Add init-authority.sql
* Add init-authority.sql
* Add init-authority.sql
* Add init-authority.sql
* try test
* Revert it-env.properties
* Add resource
* Add resource
---
.../shardingsphere-integration-test-env/pom.xml | 5 +++
.../atomic/storage/DockerStorageContainer.java | 5 ++-
.../runtime/scenario/path/ScenarioDataPath.java | 2 +-
.../init-sql/mysql/00-init-authority.sql} | 3 ++
.../init-sql/opengauss/00-init-authority.sql} | 4 ++
.../init-sql/oracle/00-init-authority.sql} | 3 ++
.../init-sql/postgresql/00-init-authority.sql} | 4 ++
.../init-sql/sqlserver/00-init-authority.sql} | 3 ++
.../pom.xml | 3 ++
.../env/mysql/{initdb.sql => 01-initdb.sql} | 6 +--
.../env/opengauss/{initdb.sql => 01-initdb.sql} | 16 ++++----
.../env/postgresql/{initdb.sql => 01-initdb.sql} | 15 ++++---
.../shardingsphere-integration-test-suite/pom.xml | 3 ++
.../h2/{actual-init.sql => 01-actual-init.sql} | 0
.../actual-init.sql => mysql/01-actual-init.sql} | 4 +-
.../oracle/{actual-init.sql => 01-actual-init.sql} | 3 --
.../{actual-init.sql => 01-actual-init.sql} | 20 +++++-----
.../01-actual-init.sql} | 6 ---
.../h2/{expected-init.sql => 01-expected-init.sql} | 0
.../01-expected-init.sql} | 4 +-
.../{expected-init.sql => 01-expected-init.sql} | 3 --
.../{expected-init.sql => 01-expected-init.sql} | 2 +-
.../01-expected-init.sql} | 6 ---
.../h2/{actual-init.sql => 01-actual-init.sql} | 0
.../actual-init.sql => mysql/01-actual-init.sql} | 8 ++--
.../oracle/{actual-init.sql => 01-actual-init.sql} | 3 --
.../{actual-init.sql => 01-actual-init.sql} | 40 +++++++++----------
.../01-actual-init.sql} | 10 +----
.../h2/{expected-init.sql => 01-expected-init.sql} | 0
.../01-expected-init.sql} | 5 +--
.../{expected-init.sql => 01-expected-init.sql} | 4 --
.../{expected-init.sql => 01-expected-init.sql} | 4 +-
.../01-expected-init.sql} | 6 ---
.../h2/{actual-init.sql => 01-actual-init.sql} | 0
.../actual-init.sql => mysql/01-actual-init.sql} | 4 +-
.../oracle/{actual-init.sql => 01-actual-init.sql} | 3 --
.../{actual-init.sql => 01-actual-init.sql} | 40 +++++++++----------
.../01-actual-init.sql} | 6 ---
.../h2/{expected-init.sql => 01-expected-init.sql} | 0
.../{expected-init.sql => 01-expected-init.sql} | 3 --
.../{expected-init.sql => 01-expected-init.sql} | 4 --
.../{expected-init.sql => 01-expected-init.sql} | 4 +-
.../{expected-init.sql => 01-expected-init.sql} | 4 --
.../mysql/{actual-init.sql => 01-actual-init.sql} | 3 --
.../{actual-init.sql => 01-actual-init.sql} | 46 +++++++++++-----------
.../{expected-init.sql => 01-expected-init.sql} | 0
.../{expected-init.sql => 01-expected-init.sql} | 0
.../h2/{actual-init.sql => 01-actual-init.sql} | 0
.../actual-init.sql => mysql/01-actual-init.sql} | 4 +-
.../oracle/{actual-init.sql => 01-actual-init.sql} | 3 --
.../{actual-init.sql => 01-actual-init.sql} | 2 +-
.../01-actual-init.sql} | 6 ---
.../h2/{expected-init.sql => 01-expected-init.sql} | 0
.../{expected-init.sql => 01-expected-init.sql} | 3 --
.../{expected-init.sql => 01-expected-init.sql} | 3 --
.../{expected-init.sql => 01-expected-init.sql} | 2 +-
.../{expected-init.sql => 01-expected-init.sql} | 3 --
.../h2/{actual-init.sql => 01-actual-init.sql} | 0
.../actual-init.sql => mysql/01-actual-init.sql} | 4 +-
.../oracle/{actual-init.sql => 01-actual-init.sql} | 3 --
.../{actual-init.sql => 01-actual-init.sql} | 6 +--
.../01-actual-init.sql} | 6 ---
.../h2/{expected-init.sql => 01-expected-init.sql} | 0
.../01-expected-init.sql} | 5 ++-
.../{expected-init.sql => 01-expected-init.sql} | 4 --
.../{expected-init.sql => 01-expected-init.sql} | 4 +-
.../01-expected-init.sql} | 7 ----
.../h2/{actual-init.sql => 01-actual-init.sql} | 0
.../actual-init.sql => mysql/01-actual-init.sql} | 6 +--
.../oracle/{actual-init.sql => 01-actual-init.sql} | 3 --
.../{actual-init.sql => 01-actual-init.sql} | 4 +-
.../01-actual-init.sql} | 7 +---
.../h2/{expected-init.sql => 01-expected-init.sql} | 0
.../data/expected/init-sql/mysql/expected-init.sql | 3 --
.../expected/init-sql/oracle/expected-init.sql | 4 --
.../expected/init-sql/postgresql/expected-init.sql | 4 +-
.../expected/init-sql/sqlserver/expected-init.sql | 4 --
.../h2/{actual-init.sql => 01-actual-init.sql} | 0
.../actual-init.sql => mysql/01-actual-init.sql} | 5 ++-
.../oracle/{actual-init.sql => 01-actual-init.sql} | 3 --
.../{actual-init.sql => 01-actual-init.sql} | 2 +-
.../01-actual-init.sql} | 7 ----
.../h2/{expected-init.sql => 01-expected-init.sql} | 0
.../01-expected-init.sql} | 4 +-
.../{expected-init.sql => 01-expected-init.sql} | 3 --
.../{expected-init.sql => 01-expected-init.sql} | 2 +-
.../01-expected-init.sql} | 6 ---
87 files changed, 170 insertions(+), 279 deletions(-)
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/pom.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/pom.xml
index 287294f049f..232c8478004 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/pom.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/pom.xml
@@ -51,6 +51,11 @@
</dependencies>
<build>
+ <testResources>
+ <testResource>
+ <directory>src/test/resources</directory>
+ </testResource>
+ </testResources>
<plugins>
<plugin>
<artifactId>maven-jar-plugin</artifactId>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/DockerStorageContainer.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/DockerStorageContainer.java
index 86ca66474c9..39fc4e6b568 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/DockerStorageContainer.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/DockerStorageContainer.java
@@ -68,8 +68,9 @@ public abstract class DockerStorageContainer extends
DockerITContainer implement
@Override
protected void configure() {
+ withClasspathResourceMapping("/container/init-sql/" +
databaseType.getType().toLowerCase() + "/00-init-authority.sql",
"/docker-entrypoint-initdb.d/", BindMode.READ_ONLY);
if (Strings.isNullOrEmpty(scenario)) {
- withClasspathResourceMapping("/env/" +
databaseType.getType().toLowerCase() + "/initdb.sql",
"/docker-entrypoint-initdb.d/", BindMode.READ_ONLY);
+ withClasspathResourceMapping("/env/" +
databaseType.getType().toLowerCase() + "/01-initdb.sql",
"/docker-entrypoint-initdb.d/", BindMode.READ_ONLY);
} else {
withClasspathResourceMapping(new
ScenarioDataPath(scenario).getInitSQLResourcePath(Type.ACTUAL, databaseType),
"/docker-entrypoint-initdb.d/", BindMode.READ_ONLY);
withClasspathResourceMapping(new
ScenarioDataPath(scenario).getInitSQLResourcePath(Type.EXPECTED, databaseType),
"/docker-entrypoint-initdb.d/", BindMode.READ_ONLY);
@@ -124,7 +125,7 @@ public abstract class DockerStorageContainer extends
DockerITContainer implement
public abstract String getRootUsername();
protected final String getNormalUsername() {
- return "normal_user";
+ return "test_user";
}
/**
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/runtime/scenario/path/ScenarioDataPath.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/runtime/scenario/path/ScenarioDataPath.java
index d415b978cfb..dbf10f63d81 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/runtime/scenario/path/ScenarioDataPath.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/runtime/scenario/path/ScenarioDataPath.java
@@ -80,7 +80,7 @@ public final class ScenarioDataPath {
* @return expected init SQL file
*/
public String getInitSQLFile(final Type type, final DatabaseType
databaseType) {
- String initSQLFileName = String.join("-", type.name().toLowerCase(),
BASIC_INIT_SQL_FILE);
+ String initSQLFileName = String.join("-", "01",
type.name().toLowerCase(), BASIC_INIT_SQL_FILE);
String initSQLResourceFile = String.join("/",
getInitSQLResourcePath(type, databaseType), initSQLFileName);
URL url =
ScenarioDataPath.class.getClassLoader().getResource(initSQLResourceFile);
assertNotNull(String.format("File `%s` must exist.",
initSQLResourceFile), url);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/mysql/00-init-authority.sql
similarity index 88%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/mysql/00-init-authority.sql
index e3b8a181bea..f54e95a7dc8 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/mysql/00-init-authority.sql
@@ -14,3 +14,6 @@
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
+
+CREATE USER IF NOT EXISTS 'test_user'@'%' IDENTIFIED BY 'Root@123';
+GRANT ALL ON *.* TO 'test_user'@'%';
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/opengauss/00-init-authority.sql
similarity index 86%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/opengauss/00-init-authority.sql
index e3b8a181bea..7305a5e0f83 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/opengauss/00-init-authority.sql
@@ -14,3 +14,7 @@
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
+
+CREATE USER test_user WITH ENCRYPTED PASSWORD 'Root@123';
+ALTER ROLE test_user CREATEDB REPLICATION;
+CREATE DATABASE test_user;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/oracle/00-init-authority.sql
similarity index 88%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/oracle/00-init-authority.sql
index e3b8a181bea..5e3cbcfce44 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/oracle/00-init-authority.sql
@@ -14,3 +14,6 @@
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
+
+CREATE USER 'test_user'@'%' IDENTIFIED BY 'Root@123';
+GRANT ALL PRIVILEGES ON *.* TO 'test_user'@'%';
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/postgresql/00-init-authority.sql
similarity index 86%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/postgresql/00-init-authority.sql
index e3b8a181bea..7305a5e0f83 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/postgresql/00-init-authority.sql
@@ -14,3 +14,7 @@
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
+
+CREATE USER test_user WITH ENCRYPTED PASSWORD 'Root@123';
+ALTER ROLE test_user CREATEDB REPLICATION;
+CREATE DATABASE test_user;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/sqlserver/00-init-authority.sql
similarity index 89%
copy from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
copy to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/sqlserver/00-init-authority.sql
index e3b8a181bea..f5402c90c4a 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/resources/container/init-sql/sqlserver/00-init-authority.sql
@@ -14,3 +14,6 @@
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
+
+CREATE USER 'test_user'@'%' IDENTIFIED BY 'Root@123';
+GRANT ALL ON *.* TO 'test_user'@'%';
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/pom.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/pom.xml
index 1b5a9014a68..a747890314e 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/pom.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/pom.xml
@@ -105,6 +105,9 @@
<configuration>
<outputDirectory>target/test-classes</outputDirectory>
<resources>
+ <resource>
+
<directory>${project.basedir}/../shardingsphere-integration-test-env/src/test/resources</directory>
+ </resource>
<resource>
<directory>src/test/resources</directory>
<filtering>true</filtering>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/initdb.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/01-initdb.sql
similarity index 80%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/initdb.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/01-initdb.sql
index 3b9acb988da..6c95fe0c2ba 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/initdb.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/01-initdb.sql
@@ -20,6 +20,6 @@ CREATE DATABASE scaling_it_1;
CREATE DATABASE scaling_it_2;
CREATE DATABASE scaling_it_3;
CREATE DATABASE scaling_it_4;
-CREATE USER IF NOT EXISTS 'normal_user'@'%' IDENTIFIED BY 'Root@123';
-GRANT Replication Client, Replication Slave, Select, Insert, Update, Delete,
Index ON *.* TO `normal_user`@`%`;
-GRANT Create, Drop ON TABLE *.* TO normal_user;
+
+GRANT REPLICATION CLIENT, REPLICATION SLAVE, SELECT, INSERT, UPDATE, DELETE,
INDEX ON *.* TO `test_user`@`%`;
+GRANT CREATE, DROP ON TABLE *.* TO test_user;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/opengauss/initdb.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/opengauss/01-initdb.sql
similarity index 67%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/opengauss/initdb.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/opengauss/01-initdb.sql
index 30ac3d22710..ee81d0cf561 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/opengauss/initdb.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/opengauss/01-initdb.sql
@@ -13,17 +13,17 @@
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
+--
CREATE DATABASE scaling_it_0;
CREATE DATABASE scaling_it_1;
CREATE DATABASE scaling_it_2;
CREATE DATABASE scaling_it_3;
CREATE DATABASE scaling_it_4;
-CREATE USER normal_user WITH ENCRYPTED PASSWORD 'Root@123';
-CREATE DATABASE normal_user;
-ALTER ROLE normal_user CREATEDB REPLICATION;
-GRANT CREATE, CONNECT ON DATABASE scaling_it_0 TO normal_user;
-GRANT CREATE, CONNECT ON DATABASE scaling_it_1 TO normal_user;
-GRANT CREATE, CONNECT ON DATABASE scaling_it_2 TO normal_user;
-GRANT CREATE, CONNECT ON DATABASE scaling_it_3 TO normal_user;
-GRANT CREATE, CONNECT ON DATABASE scaling_it_4 TO normal_user;
+CREATE DATABASE scaling;
+
+GRANT CREATE, CONNECT ON DATABASE scaling_it_0 TO test_user;
+GRANT CREATE, CONNECT ON DATABASE scaling_it_1 TO test_user;
+GRANT CREATE, CONNECT ON DATABASE scaling_it_2 TO test_user;
+GRANT CREATE, CONNECT ON DATABASE scaling_it_3 TO test_user;
+GRANT CREATE, CONNECT ON DATABASE scaling_it_4 TO test_user;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/initdb.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/01-initdb.sql
similarity index 67%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/initdb.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/01-initdb.sql
index 30ac3d22710..bd8f263008e 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/initdb.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/01-initdb.sql
@@ -19,11 +19,10 @@ CREATE DATABASE scaling_it_1;
CREATE DATABASE scaling_it_2;
CREATE DATABASE scaling_it_3;
CREATE DATABASE scaling_it_4;
-CREATE USER normal_user WITH ENCRYPTED PASSWORD 'Root@123';
-CREATE DATABASE normal_user;
-ALTER ROLE normal_user CREATEDB REPLICATION;
-GRANT CREATE, CONNECT ON DATABASE scaling_it_0 TO normal_user;
-GRANT CREATE, CONNECT ON DATABASE scaling_it_1 TO normal_user;
-GRANT CREATE, CONNECT ON DATABASE scaling_it_2 TO normal_user;
-GRANT CREATE, CONNECT ON DATABASE scaling_it_3 TO normal_user;
-GRANT CREATE, CONNECT ON DATABASE scaling_it_4 TO normal_user;
+CREATE DATABASE scaling;
+
+GRANT CREATE, CONNECT ON DATABASE scaling_it_0 TO test_user;
+GRANT CREATE, CONNECT ON DATABASE scaling_it_1 TO test_user;
+GRANT CREATE, CONNECT ON DATABASE scaling_it_2 TO test_user;
+GRANT CREATE, CONNECT ON DATABASE scaling_it_3 TO test_user;
+GRANT CREATE, CONNECT ON DATABASE scaling_it_4 TO test_user;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/pom.xml
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/pom.xml
index 6095c517b67..3eefa0699fe 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/pom.xml
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/pom.xml
@@ -77,6 +77,9 @@
<configuration>
<outputDirectory>target/test-classes</outputDirectory>
<resources>
+ <resource>
+
<directory>${project.basedir}/../shardingsphere-integration-test-env/src/test/resources</directory>
+ </resource>
<resource>
<directory>src/test/resources</directory>
<filtering>true</filtering>
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/h2/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/h2/01-actual-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/h2/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/h2/01-actual-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/sqlserver/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/mysql/01-actual-init.sql
similarity index 98%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/sqlserver/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/mysql/01-actual-init.sql
index 853b90916cb..a2d8e2cd9ca 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/sqlserver/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/mysql/01-actual-init.sql
@@ -15,8 +15,8 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
+SET character_set_database='utf8';
+SET character_set_server='utf8';
DROP DATABASE IF EXISTS db_0;
DROP DATABASE IF EXISTS db_1;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/oracle/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/oracle/01-actual-init.sql
similarity index 98%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/oracle/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/oracle/01-actual-init.sql
index bb5d2f925b0..84ea58d37eb 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/oracle/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/oracle/01-actual-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
DROP SCHEMA db_0;
DROP SCHEMA db_1;
DROP SCHEMA db_2;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/postgresql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/postgresql/01-actual-init.sql
similarity index 93%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/postgresql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/postgresql/01-actual-init.sql
index e5cf48d0c4d..65294850cfd 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/postgresql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -26,16 +26,16 @@ CREATE DATABASE db_7;
CREATE DATABASE db_8;
CREATE DATABASE db_9;
-GRANT ALL PRIVILEGES ON DATABASE db_0 TO root;
-GRANT ALL PRIVILEGES ON DATABASE db_1 TO root;
-GRANT ALL PRIVILEGES ON DATABASE db_2 TO root;
-GRANT ALL PRIVILEGES ON DATABASE db_3 TO root;
-GRANT ALL PRIVILEGES ON DATABASE db_4 TO root;
-GRANT ALL PRIVILEGES ON DATABASE db_5 TO root;
-GRANT ALL PRIVILEGES ON DATABASE db_6 TO root;
-GRANT ALL PRIVILEGES ON DATABASE db_7 TO root;
-GRANT ALL PRIVILEGES ON DATABASE db_8 TO root;
-GRANT ALL PRIVILEGES ON DATABASE db_9 TO root;
+GRANT ALL PRIVILEGES ON DATABASE db_0 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE db_1 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE db_2 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE db_3 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE db_4 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE db_5 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE db_6 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE db_7 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE db_8 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE db_9 TO test_user;
\c db_0;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/mysql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/sqlserver/01-actual-init.sql
similarity index 97%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/mysql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/sqlserver/01-actual-init.sql
index 006c077830e..1f3a8028295 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/mysql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/actual/init-sql/sqlserver/01-actual-init.sql
@@ -15,12 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-SET character_set_database='utf8';
-SET character_set_server='utf8';
-
DROP DATABASE IF EXISTS db_0;
DROP DATABASE IF EXISTS db_1;
DROP DATABASE IF EXISTS db_2;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/h2/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/h2/01-expected-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/h2/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/h2/01-expected-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/mysql/01-expected-init.sql
similarity index 95%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/mysql/01-expected-init.sql
index ddf137ae9e7..c94fbaf04ec 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/mysql/01-expected-init.sql
@@ -15,8 +15,8 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
+SET character_set_database='utf8';
+SET character_set_server='utf8';
DROP DATABASE IF EXISTS expected_dataset;
CREATE DATABASE expected_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/oracle/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/oracle/01-expected-init.sql
similarity index 95%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/oracle/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/oracle/01-expected-init.sql
index 41b4bef6dee..4e25f602f7d 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/oracle/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/oracle/01-expected-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
DROP SCHEMA expected_dataset;
CREATE SCHEMA expected_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/postgresql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/postgresql/01-expected-init.sql
similarity index 97%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/postgresql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/postgresql/01-expected-init.sql
index 19fa29d7f63..dfeb367b555 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/postgresql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/postgresql/01-expected-init.sql
@@ -18,7 +18,7 @@
DROP DATABASE IF EXISTS expected_dataset;
CREATE DATABASE expected_dataset;
-GRANT ALL PRIVILEGES ON DATABASE expected_dataset TO root;
+GRANT ALL PRIVILEGES ON DATABASE expected_dataset TO test_user;
\c expected_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/01-expected-init.sql
similarity index 92%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/mysql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/01-expected-init.sql
index a00413efb1f..5dffd88b12d 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/mysql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/01-expected-init.sql
@@ -15,12 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-SET character_set_database='utf8';
-SET character_set_server='utf8';
-
DROP DATABASE IF EXISTS expected_dataset;
CREATE DATABASE expected_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/01-actual-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/h2/01-actual-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/sqlserver/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
similarity index 99%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/sqlserver/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
index 8c9fc6e6bec..1e5ec1b9101 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/sqlserver/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
@@ -15,8 +15,8 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
+SET character_set_database='utf8';
+SET character_set_server='utf8';
DROP DATABASE IF EXISTS write_ds_0;
DROP DATABASE IF EXISTS write_ds_1;
@@ -80,8 +80,8 @@ CREATE TABLE write_ds_0.t_order_8 (order_id INT NOT NULL,
user_id INT NOT NULL,
CREATE TABLE write_ds_0.t_order_item_8 (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id));
CREATE TABLE write_ds_0.t_order_9 (order_id INT NOT NULL, user_id INT NOT
NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE write_ds_0.t_order_item_9 (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id));
-CREATE TABLE write_ds_0.t_single_table (single_id INT NOT NULL, id INT NOT
NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE write_ds_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
+CREATE TABLE write_ds_0.t_single_table (single_id INT NOT NULL, id INT NOT
NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE write_ds_0.t_order_federate (order_id INT NOT NULL, user_id INT
NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE INDEX order_index_t_order_0 ON write_ds_0.t_order_0 (order_id);
CREATE INDEX order_index_t_order_1 ON write_ds_0.t_order_1 (order_id);
@@ -407,8 +407,8 @@ CREATE TABLE read_ds_0.t_order_8 (order_id INT NOT NULL,
user_id INT NOT NULL, s
CREATE TABLE read_ds_0.t_order_item_8 (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id));
CREATE TABLE read_ds_0.t_order_9 (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE read_ds_0.t_order_item_9 (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id));
-CREATE TABLE read_ds_0.t_single_table (single_id INT NOT NULL, id INT NOT
NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE read_ds_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
+CREATE TABLE read_ds_0.t_single_table (single_id INT NOT NULL, id INT NOT
NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
CREATE TABLE read_ds_0.t_order_federate (order_id INT NOT NULL, user_id INT
NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE INDEX order_index_t_order_0 ON read_ds_0.t_order_0 (order_id);
CREATE INDEX order_index_t_order_1 ON read_ds_0.t_order_1 (order_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/oracle/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/oracle/01-actual-init.sql
similarity index 99%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/oracle/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/oracle/01-actual-init.sql
index f9ada1406e6..5c27eec754b 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/oracle/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/oracle/01-actual-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
DROP SCHEMA write_ds_0;
DROP SCHEMA write_ds_1;
DROP SCHEMA write_ds_2;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/postgresql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
similarity index 98%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/postgresql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
index 6aaebe945ea..16d130566d7 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/postgresql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -36,26 +36,26 @@ CREATE DATABASE read_ds_7;
CREATE DATABASE read_ds_8;
CREATE DATABASE read_ds_9;
-GRANT ALL PRIVILEGES ON DATABASE write_ds_0 TO root;
-GRANT ALL PRIVILEGES ON DATABASE write_ds_1 TO root;
-GRANT ALL PRIVILEGES ON DATABASE write_ds_2 TO root;
-GRANT ALL PRIVILEGES ON DATABASE write_ds_3 TO root;
-GRANT ALL PRIVILEGES ON DATABASE write_ds_4 TO root;
-GRANT ALL PRIVILEGES ON DATABASE write_ds_5 TO root;
-GRANT ALL PRIVILEGES ON DATABASE write_ds_6 TO root;
-GRANT ALL PRIVILEGES ON DATABASE write_ds_7 TO root;
-GRANT ALL PRIVILEGES ON DATABASE write_ds_8 TO root;
-GRANT ALL PRIVILEGES ON DATABASE write_ds_9 TO root;
-GRANT ALL PRIVILEGES ON DATABASE read_ds_0 TO root;
-GRANT ALL PRIVILEGES ON DATABASE read_ds_1 TO root;
-GRANT ALL PRIVILEGES ON DATABASE read_ds_2 TO root;
-GRANT ALL PRIVILEGES ON DATABASE read_ds_3 TO root;
-GRANT ALL PRIVILEGES ON DATABASE read_ds_4 TO root;
-GRANT ALL PRIVILEGES ON DATABASE read_ds_5 TO root;
-GRANT ALL PRIVILEGES ON DATABASE read_ds_6 TO root;
-GRANT ALL PRIVILEGES ON DATABASE read_ds_7 TO root;
-GRANT ALL PRIVILEGES ON DATABASE read_ds_8 TO root;
-GRANT ALL PRIVILEGES ON DATABASE read_ds_9 TO root;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_0 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_1 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_2 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_3 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_4 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_5 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_6 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_7 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_8 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE write_ds_9 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_0 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_1 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_2 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_3 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_4 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_5 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_6 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_7 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_8 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_ds_9 TO test_user;
\c write_ds_0
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/mysql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/sqlserver/01-actual-init.sql
similarity index 99%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/mysql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/sqlserver/01-actual-init.sql
index d110f045af3..d7acd97b83c 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/mysql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/actual/init-sql/sqlserver/01-actual-init.sql
@@ -15,12 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-SET character_set_database='utf8';
-SET character_set_server='utf8';
-
DROP DATABASE IF EXISTS write_ds_0;
DROP DATABASE IF EXISTS write_ds_1;
DROP DATABASE IF EXISTS write_ds_2;
@@ -83,8 +77,8 @@ CREATE TABLE write_ds_0.t_order_8 (order_id INT NOT NULL,
user_id INT NOT NULL,
CREATE TABLE write_ds_0.t_order_item_8 (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id));
CREATE TABLE write_ds_0.t_order_9 (order_id INT NOT NULL, user_id INT NOT
NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE write_ds_0.t_order_item_9 (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id));
-CREATE TABLE write_ds_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE TABLE write_ds_0.t_single_table (single_id INT NOT NULL, id INT NOT
NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
+CREATE TABLE write_ds_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE TABLE write_ds_0.t_order_federate (order_id INT NOT NULL, user_id INT
NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE INDEX order_index_t_order_0 ON write_ds_0.t_order_0 (order_id);
CREATE INDEX order_index_t_order_1 ON write_ds_0.t_order_1 (order_id);
@@ -410,8 +404,8 @@ CREATE TABLE read_ds_0.t_order_8 (order_id INT NOT NULL,
user_id INT NOT NULL, s
CREATE TABLE read_ds_0.t_order_item_8 (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id));
CREATE TABLE read_ds_0.t_order_9 (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE TABLE read_ds_0.t_order_item_9 (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id));
-CREATE TABLE read_ds_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE TABLE read_ds_0.t_single_table (single_id INT NOT NULL, id INT NOT
NULL, status VARCHAR(45) NULL, PRIMARY KEY (single_id));
+CREATE TABLE read_ds_0.t_broadcast_table (id INT NOT NULL, status VARCHAR(45)
NULL, PRIMARY KEY (id));
CREATE TABLE read_ds_0.t_order_federate (order_id INT NOT NULL, user_id INT
NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
CREATE INDEX order_index_t_order_0 ON read_ds_0.t_order_0 (order_id);
CREATE INDEX order_index_t_order_1 ON read_ds_0.t_order_1 (order_id);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/h2/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/h2/01-expected-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/h2/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/h2/01-expected-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/sqlserver/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
similarity index 97%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/sqlserver/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
index 82452290300..1c896543b52 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/sqlserver/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
@@ -15,9 +15,8 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
+SET character_set_database='utf8';
+SET character_set_server='utf8';
DROP DATABASE IF EXISTS write_dataset;
CREATE DATABASE write_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/oracle/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/oracle/01-expected-init.sql
similarity index 97%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/oracle/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/oracle/01-expected-init.sql
index bf73ec45637..36567acd850 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/oracle/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/oracle/01-expected-init.sql
@@ -15,10 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-
DROP SCHEMA write_dataset;
CREATE SCHEMA write_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/postgresql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql
similarity index 97%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/postgresql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql
index b839b959388..6a0f3545d8d 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/postgresql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql
@@ -18,7 +18,7 @@
DROP DATABASE IF EXISTS write_dataset;
CREATE DATABASE write_dataset;
-GRANT ALL PRIVILEGES ON DATABASE write_dataset TO root;
+GRANT ALL PRIVILEGES ON DATABASE write_dataset TO test_user;
\c write_dataset;
@@ -46,7 +46,7 @@ CREATE INDEX order_index_t_order ON t_order (order_id);
DROP DATABASE IF EXISTS read_dataset;
CREATE DATABASE read_dataset;
-GRANT ALL PRIVILEGES ON DATABASE read_dataset TO root;
+GRANT ALL PRIVILEGES ON DATABASE read_dataset TO test_user;
\c read_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/sqlserver/01-expected-init.sql
similarity index 95%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/mysql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/sqlserver/01-expected-init.sql
index 6c14b1d69ef..cf6b42eafe0 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/mysql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting/data/expected/init-sql/sqlserver/01-expected-init.sql
@@ -15,12 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-SET character_set_database='utf8';
-SET character_set_server='utf8';
-
DROP DATABASE IF EXISTS write_dataset;
CREATE DATABASE write_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/01-actual-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/h2/01-actual-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/sqlserver/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/mysql/01-actual-init.sql
similarity index 99%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/sqlserver/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/mysql/01-actual-init.sql
index 49e4096c853..059a424f9da 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/sqlserver/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/mysql/01-actual-init.sql
@@ -15,8 +15,8 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
+SET character_set_database='utf8';
+SET character_set_server='utf8';
DROP DATABASE IF EXISTS encrypt_write_ds_0;
DROP DATABASE IF EXISTS encrypt_write_ds_1;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/oracle/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/oracle/01-actual-init.sql
similarity index 99%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/oracle/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/oracle/01-actual-init.sql
index 90e75e9e6c2..2ba8bf20550 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/oracle/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/oracle/01-actual-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
DROP SCHEMA encrypt_write_ds_0;
DROP SCHEMA encrypt_write_ds_1;
DROP SCHEMA encrypt_write_ds_2;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/postgresql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/postgresql/01-actual-init.sql
similarity index 98%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/postgresql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/postgresql/01-actual-init.sql
index f1fa5b62d66..394c454824d 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/postgresql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -36,26 +36,26 @@ CREATE DATABASE encrypt_read_ds_7;
CREATE DATABASE encrypt_read_ds_8;
CREATE DATABASE encrypt_read_ds_9;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_0 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_1 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_2 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_3 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_4 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_5 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_6 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_7 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_8 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_9 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_0 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_1 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_2 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_3 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_4 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_5 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_6 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_7 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_8 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_9 TO root;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_0 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_1 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_2 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_3 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_4 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_5 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_6 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_7 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_8 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_9 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_0 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_1 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_2 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_3 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_4 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_5 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_6 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_7 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_8 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_9 TO test_user;
\c encrypt_write_ds_0
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/mysql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/sqlserver/01-actual-init.sql
similarity index 99%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/mysql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/sqlserver/01-actual-init.sql
index c78b1e9aaba..ae68f3aad86 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/mysql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/actual/init-sql/sqlserver/01-actual-init.sql
@@ -15,12 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-SET character_set_database='utf8';
-SET character_set_server='utf8';
-
DROP DATABASE IF EXISTS encrypt_write_ds_0;
DROP DATABASE IF EXISTS encrypt_write_ds_1;
DROP DATABASE IF EXISTS encrypt_write_ds_2;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/h2/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/h2/01-expected-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/h2/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/h2/01-expected-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/mysql/01-expected-init.sql
similarity index 97%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/mysql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/mysql/01-expected-init.sql
index 7f8e3aecde4..e84619306ed 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/mysql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/mysql/01-expected-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
SET character_set_database='utf8';
SET character_set_server='utf8';
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/oracle/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/oracle/01-expected-init.sql
similarity index 97%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/oracle/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/oracle/01-expected-init.sql
index 4e93ed61170..7070da7ad25 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/oracle/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/oracle/01-expected-init.sql
@@ -15,10 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-
DROP SCHEMA write_dataset;
CREATE SCHEMA write_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/postgresql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/postgresql/01-expected-init.sql
similarity index 97%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/postgresql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/postgresql/01-expected-init.sql
index 833d2a1619d..15ebba010e8 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/postgresql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/postgresql/01-expected-init.sql
@@ -18,7 +18,7 @@
DROP DATABASE IF EXISTS write_dataset;
CREATE DATABASE write_dataset;
-GRANT ALL PRIVILEGES ON DATABASE write_dataset TO root;
+GRANT ALL PRIVILEGES ON DATABASE write_dataset TO test_user;
\c write_dataset;
@@ -50,7 +50,7 @@ CREATE INDEX user_index_t_user ON t_user (user_id);
DROP DATABASE IF EXISTS read_dataset;
CREATE DATABASE read_dataset;
-GRANT ALL PRIVILEGES ON DATABASE read_dataset TO root;
+GRANT ALL PRIVILEGES ON DATABASE read_dataset TO test_user;
\c read_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/sqlserver/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/sqlserver/01-expected-init.sql
similarity index 97%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/sqlserver/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/sqlserver/01-expected-init.sql
index e15828b14de..3fe256330ba 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/sqlserver/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/dbtbl_with_readwrite_splitting_and_encrypt/data/expected/init-sql/sqlserver/01-expected-init.sql
@@ -15,10 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-
DROP DATABASE IF EXISTS write_dataset;
CREATE DATABASE write_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/mysql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/mysql/01-actual-init.sql
similarity index 99%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/mysql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/mysql/01-actual-init.sql
index f593787502f..5d5e0611f6f 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/mysql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/mysql/01-actual-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
SET character_set_database='utf8';
SET character_set_server='utf8';
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/postgresql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/postgresql/01-actual-init.sql
similarity index 96%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/postgresql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/postgresql/01-actual-init.sql
index ea3ed69c34b..8e0d8477797 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/postgresql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -40,29 +40,29 @@ CREATE DATABASE rdl_test_0;
CREATE DATABASE rdl_test_1;
CREATE DATABASE rdl_test_2;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_0 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_1 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_2 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_3 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_4 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_5 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_6 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_7 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_8 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_9 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_0 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_1 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_2 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_3 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_4 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_5 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_6 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_7 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_8 TO root;
-GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_9 TO root;
-GRANT ALL PRIVILEGES ON DATABASE rdl_test_0 TO root;
-GRANT ALL PRIVILEGES ON DATABASE rdl_test_1 TO root;
-GRANT ALL PRIVILEGES ON DATABASE rdl_test_2 TO root;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_0 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_1 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_2 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_3 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_4 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_5 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_6 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_7 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_8 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_write_ds_9 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_0 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_1 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_2 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_3 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_4 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_5 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_6 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_7 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_8 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE encrypt_read_ds_9 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE rdl_test_0 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE rdl_test_1 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE rdl_test_2 TO test_user;
\c encrypt_write_ds_0
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/01-expected-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/mysql/01-expected-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/postgresql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/postgresql/01-expected-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/postgresql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/empty_rules/data/expected/init-sql/postgresql/01-expected-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/h2/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/h2/01-actual-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/h2/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/h2/01-actual-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/sqlserver/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/mysql/01-actual-init.sql
similarity index 93%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/sqlserver/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/mysql/01-actual-init.sql
index 32401c405ec..9a775be636f 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/sqlserver/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/mysql/01-actual-init.sql
@@ -15,8 +15,8 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
+SET character_set_database='utf8';
+SET character_set_server='utf8';
DROP DATABASE IF EXISTS encrypt;
CREATE DATABASE encrypt;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/oracle/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/oracle/01-actual-init.sql
similarity index 93%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/oracle/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/oracle/01-actual-init.sql
index a28a0f97f7c..b7228cf0855 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/oracle/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/oracle/01-actual-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
DROP SCHEMA encrypt;
CREATE SCHEMA encrypt;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/postgresql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/postgresql/01-actual-init.sql
similarity index 96%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/postgresql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/postgresql/01-actual-init.sql
index 405ba4264c5..afa1a28bfe9 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/postgresql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -17,7 +17,7 @@
CREATE DATABASE encrypt;
-GRANT ALL PRIVILEGES ON DATABASE encrypt TO root;
+GRANT ALL PRIVILEGES ON DATABASE encrypt TO test_user;
\c encrypt
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/mysql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/sqlserver/01-actual-init.sql
similarity index 88%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/mysql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/sqlserver/01-actual-init.sql
index 138eed16ffc..f595a9eb8f8 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/mysql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/actual/init-sql/sqlserver/01-actual-init.sql
@@ -15,12 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-SET character_set_database='utf8';
-SET character_set_server='utf8';
-
DROP DATABASE IF EXISTS encrypt;
CREATE DATABASE encrypt;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/h2/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/h2/01-expected-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/h2/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/h2/01-expected-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/mysql/01-expected-init.sql
similarity index 93%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/mysql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/mysql/01-expected-init.sql
index 66f2e33a38b..f465841e6fa 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/mysql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/mysql/01-expected-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
SET character_set_database='utf8';
SET character_set_server='utf8';
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/oracle/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/oracle/01-expected-init.sql
similarity index 93%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/oracle/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/oracle/01-expected-init.sql
index bd6576d74ad..bd84df6b0f5 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/oracle/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/oracle/01-expected-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
DROP SCHEMA expected_dataset;
CREATE SCHEMA expected_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/postgresql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/postgresql/01-expected-init.sql
similarity index 95%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/postgresql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/postgresql/01-expected-init.sql
index 2d397036083..0213247913d 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/postgresql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/postgresql/01-expected-init.sql
@@ -18,7 +18,7 @@
DROP DATABASE IF EXISTS expected_dataset;
CREATE DATABASE expected_dataset;
-GRANT ALL PRIVILEGES ON DATABASE expected_dataset TO root;
+GRANT ALL PRIVILEGES ON DATABASE expected_dataset TO test_user;
\c expected_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/sqlserver/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/sqlserver/01-expected-init.sql
similarity index 93%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/sqlserver/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/sqlserver/01-expected-init.sql
index c73305a0ea6..af873171b47 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/sqlserver/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/encrypt/data/expected/init-sql/sqlserver/01-expected-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
DROP DATABASE IF EXISTS expected_dataset;
CREATE DATABASE expected_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/h2/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/h2/01-actual-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/h2/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/h2/01-actual-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/sqlserver/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
similarity index 96%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/sqlserver/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
index 28e2cfee4cc..18c9beeac3d 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/sqlserver/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/mysql/01-actual-init.sql
@@ -15,8 +15,8 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
+SET character_set_database='utf8';
+SET character_set_server='utf8';
DROP DATABASE IF EXISTS write_ds;
DROP DATABASE IF EXISTS read_0;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/oracle/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/oracle/01-actual-init.sql
similarity index 96%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/oracle/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/oracle/01-actual-init.sql
index 2be2f302885..be62c1c2485 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/oracle/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/oracle/01-actual-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
DROP SCHEMA write_ds;
DROP SCHEMA read_0;
DROP SCHEMA read_1;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/postgresql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
similarity index 94%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/postgresql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
index df7ec1d78b9..602a3e60dae 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/postgresql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -19,9 +19,9 @@ CREATE DATABASE write_ds;
CREATE DATABASE read_0;
CREATE DATABASE read_1;
-GRANT ALL PRIVILEGES ON DATABASE write_ds TO root;
-GRANT ALL PRIVILEGES ON DATABASE read_0 TO root;
-GRANT ALL PRIVILEGES ON DATABASE read_1 TO root;
+GRANT ALL PRIVILEGES ON DATABASE write_ds TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_0 TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE read_1 TO test_user;
\c write_ds
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/mysql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/sqlserver/01-actual-init.sql
similarity index 93%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/mysql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/sqlserver/01-actual-init.sql
index f8bc0292a4c..ac04100f470 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/mysql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/actual/init-sql/sqlserver/01-actual-init.sql
@@ -15,12 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-SET character_set_database='utf8';
-SET character_set_server='utf8';
-
DROP DATABASE IF EXISTS write_ds;
DROP DATABASE IF EXISTS read_0;
DROP DATABASE IF EXISTS read_1;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/h2/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/h2/01-expected-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/h2/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/h2/01-expected-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/sqlserver/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
similarity index 95%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/sqlserver/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
index cc5583522de..c9a433a4504 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/sqlserver/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/mysql/01-expected-init.sql
@@ -15,8 +15,9 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
+SET character_set_database='utf8';
+SET character_set_server='utf8';
+
DROP DATABASE IF EXISTS write_dataset;
CREATE DATABASE write_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/oracle/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/oracle/01-expected-init.sql
similarity index 95%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/oracle/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/oracle/01-expected-init.sql
index 387d80b35f2..ede0e9e30e5 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/oracle/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/oracle/01-expected-init.sql
@@ -15,10 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-
DROP SCHEMA write_dataset;
CREATE SCHEMA write_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/postgresql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql
similarity index 95%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/postgresql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql
index 179ffaf3e7f..32c518ecf29 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/postgresql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/postgresql/01-expected-init.sql
@@ -18,7 +18,7 @@
DROP DATABASE IF EXISTS write_dataset;
CREATE DATABASE write_dataset;
-GRANT ALL PRIVILEGES ON DATABASE write_dataset TO root;
+GRANT ALL PRIVILEGES ON DATABASE write_dataset TO test_user;
\c write_dataset;
@@ -38,7 +38,7 @@ CREATE INDEX order_index_t_order ON t_order (order_id);
DROP DATABASE IF EXISTS read_dataset;
CREATE DATABASE read_dataset;
-GRANT ALL PRIVILEGES ON DATABASE read_dataset TO root;
+GRANT ALL PRIVILEGES ON DATABASE read_dataset TO test_user;
\c read_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/sqlserver/01-expected-init.sql
similarity index 92%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/mysql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/sqlserver/01-expected-init.sql
index bff28676260..3f25aacdf95 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/mysql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/readwrite_splitting/data/expected/init-sql/sqlserver/01-expected-init.sql
@@ -15,13 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-SET character_set_database='utf8';
-SET character_set_server='utf8';
-
-
DROP DATABASE IF EXISTS write_dataset;
CREATE DATABASE write_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/h2/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/h2/01-actual-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/h2/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/h2/01-actual-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/sqlserver/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/mysql/01-actual-init.sql
similarity index 94%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/sqlserver/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/mysql/01-actual-init.sql
index 0820ceb79bc..2a6a680148f 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/sqlserver/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/mysql/01-actual-init.sql
@@ -15,16 +15,14 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
+SET character_set_database='utf8';
+SET character_set_server='utf8';
DROP DATABASE IF EXISTS db;
CREATE DATABASE db;
CREATE TABLE db.t_shadow (order_id BIGINT NOT NULL, user_id INT NOT NULL,
order_name VARCHAR(32) NOT NULL, type_char CHAR(1) NOT NULL, type_boolean
BOOLEAN NOT NULL, type_smallint SMALLINT NOT NULL, type_enum ENUM('spring',
'summer', 'autumn', 'winter'), type_decimal DECIMAL(18,2) NOT NULL, type_date
DATE NOT NULL, type_time TIME NOT NULL, type_timestamp TIMESTAMP NOT NULL,
PRIMARY KEY (order_id));
-
DROP DATABASE IF EXISTS shadow_db;
CREATE DATABASE shadow_db;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/oracle/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/oracle/01-actual-init.sql
similarity index 94%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/oracle/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/oracle/01-actual-init.sql
index d6fda109874..f43074ef191 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/oracle/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/oracle/01-actual-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
DROP SCHEMA db;
CREATE SCHEMA db;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/postgresql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/postgresql/01-actual-init.sql
similarity index 94%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/postgresql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/postgresql/01-actual-init.sql
index bbc29ad1ef5..95f510dae8b 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/postgresql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -18,8 +18,8 @@
CREATE DATABASE db;
CREATE DATABASE shadow_db;
-GRANT ALL PRIVILEGES ON DATABASE db TO root;
-GRANT ALL PRIVILEGES ON DATABASE shadow_db TO root;
+GRANT ALL PRIVILEGES ON DATABASE db TO test_user;
+GRANT ALL PRIVILEGES ON DATABASE shadow_db TO test_user;
\c db
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/mysql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/sqlserver/01-actual-init.sql
similarity index 90%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/mysql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/sqlserver/01-actual-init.sql
index 5b043200a0b..c764bcce2aa 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/mysql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/actual/init-sql/sqlserver/01-actual-init.sql
@@ -15,17 +15,12 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-SET character_set_database='utf8';
-SET character_set_server='utf8';
-
DROP DATABASE IF EXISTS db;
CREATE DATABASE db;
CREATE TABLE db.t_shadow (order_id BIGINT NOT NULL, user_id INT NOT NULL,
order_name VARCHAR(32) NOT NULL, type_char CHAR(1) NOT NULL, type_boolean
BOOLEAN NOT NULL, type_smallint SMALLINT NOT NULL, type_enum ENUM('spring',
'summer', 'autumn', 'winter'), type_decimal DECIMAL(18,2) NOT NULL, type_date
DATE NOT NULL, type_time TIME NOT NULL, type_timestamp TIMESTAMP NOT NULL,
PRIMARY KEY (order_id));
+
DROP DATABASE IF EXISTS shadow_db;
CREATE DATABASE shadow_db;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/h2/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/h2/01-expected-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/h2/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/h2/01-expected-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/mysql/expected-init.sql
index 92d5b17af8a..56e69205c1b 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/mysql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/mysql/expected-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
SET character_set_database='utf8';
SET character_set_server='utf8';
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/oracle/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/oracle/expected-init.sql
index b068b3fee42..b8c1c0e4845 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/oracle/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/oracle/expected-init.sql
@@ -15,10 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-
DROP SCHEMA prod_dataset;
CREATE SCHEMA prod_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/postgresql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/postgresql/expected-init.sql
index db1eb5fc828..0c6d3086c4c 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/postgresql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/postgresql/expected-init.sql
@@ -18,7 +18,7 @@
DROP DATABASE IF EXISTS prod_dataset;
CREATE DATABASE prod_dataset;
-GRANT ALL PRIVILEGES ON DATABASE prod_dataset TO root;
+GRANT ALL PRIVILEGES ON DATABASE prod_dataset TO test_user;
\c prod_dataset;
@@ -31,7 +31,7 @@ CREATE TABLE t_shadow (order_id BIGINT NOT NULL, user_id INT
NOT NULL, order_nam
DROP DATABASE IF EXISTS shadow_dataset;
CREATE DATABASE shadow_dataset;
-GRANT ALL PRIVILEGES ON DATABASE shadow_dataset TO root;
+GRANT ALL PRIVILEGES ON DATABASE shadow_dataset TO test_user;
\c shadow_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/sqlserver/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/sqlserver/expected-init.sql
index 9f45236a32a..dae338df1d3 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/sqlserver/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/shadow/data/expected/init-sql/sqlserver/expected-init.sql
@@ -15,10 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-
DROP DATABASE IF EXISTS prod_dataset;
CREATE DATABASE prod_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/h2/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/h2/01-actual-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/h2/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/h2/01-actual-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/sqlserver/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/mysql/01-actual-init.sql
similarity index 98%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/sqlserver/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/mysql/01-actual-init.sql
index f4596594997..5b5d5ddd6e9 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/sqlserver/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/mysql/01-actual-init.sql
@@ -15,10 +15,11 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
+SET character_set_database='utf8';
+SET character_set_server='utf8';
DROP DATABASE IF EXISTS tbl;
+
CREATE DATABASE tbl;
CREATE TABLE tbl.t_order_0 (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/oracle/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/oracle/01-actual-init.sql
similarity index 98%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/oracle/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/oracle/01-actual-init.sql
index 1b6ed351b17..531c14da98a 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/oracle/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/oracle/01-actual-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
DROP SCHEMA tbl;
CREATE SCHEMA tbl;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/postgresql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/postgresql/01-actual-init.sql
similarity index 99%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/postgresql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/postgresql/01-actual-init.sql
index 0e89a77e437..d3b7f74e23b 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/postgresql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/postgresql/01-actual-init.sql
@@ -17,7 +17,7 @@
CREATE DATABASE tbl;
-GRANT ALL PRIVILEGES ON DATABASE tbl TO root;
+GRANT ALL PRIVILEGES ON DATABASE tbl TO test_user;
\c tbl
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/mysql/actual-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/sqlserver/01-actual-init.sql
similarity index 96%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/mysql/actual-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/sqlserver/01-actual-init.sql
index a4ed02e41a3..5cdd266633f 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/mysql/actual-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/actual/init-sql/sqlserver/01-actual-init.sql
@@ -15,14 +15,7 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-SET character_set_database='utf8';
-SET character_set_server='utf8';
-
DROP DATABASE IF EXISTS tbl;
-
CREATE DATABASE tbl;
CREATE TABLE tbl.t_order_0 (order_id INT NOT NULL, user_id INT NOT NULL,
status VARCHAR(45) NULL, PRIMARY KEY (order_id));
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/h2/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/h2/01-expected-init.sql
similarity index 100%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/h2/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/h2/01-expected-init.sql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/sqlserver/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/mysql/01-expected-init.sql
similarity index 95%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/sqlserver/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/mysql/01-expected-init.sql
index 14baa4223cb..9451ca33f32 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/sqlserver/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/mysql/01-expected-init.sql
@@ -15,8 +15,8 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
+SET character_set_database='utf8';
+SET character_set_server='utf8';
DROP DATABASE IF EXISTS expected_dataset;
CREATE DATABASE expected_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/oracle/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/oracle/01-expected-init.sql
similarity index 95%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/oracle/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/oracle/01-expected-init.sql
index 8eeeadbbe64..0e046784ba8 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/oracle/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/oracle/01-expected-init.sql
@@ -15,9 +15,6 @@
-- limitations under the License.
--
-CREATE USER 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
DROP SCHEMA expected_dataset;
CREATE SCHEMA expected_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/postgresql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/postgresql/01-expected-init.sql
similarity index 96%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/postgresql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/postgresql/01-expected-init.sql
index 8e054365463..f2d4656d986 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/postgresql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/postgresql/01-expected-init.sql
@@ -18,7 +18,7 @@
DROP DATABASE IF EXISTS expected_dataset;
CREATE DATABASE expected_dataset;
-GRANT ALL PRIVILEGES ON DATABASE expected_dataset TO root;
+GRANT ALL PRIVILEGES ON DATABASE expected_dataset TO test_user;
\c expected_dataset;
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/mysql/expected-init.sql
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/sqlserver/01-expected-init.sql
similarity index 91%
rename from
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/mysql/expected-init.sql
rename to
shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/sqlserver/01-expected-init.sql
index 2c80596da6a..9ab53c0501f 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/mysql/expected-init.sql
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/scenario/tbl/data/expected/init-sql/sqlserver/01-expected-init.sql
@@ -15,12 +15,6 @@
-- limitations under the License.
--
-CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'Root@123';
-GRANT All privileges ON *.* TO 'root'@'%';
-
-SET character_set_database='utf8';
-SET character_set_server='utf8';
-
DROP DATABASE IF EXISTS expected_dataset;
CREATE DATABASE expected_dataset;
