github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/database/config_1.sql (about)

     1  
     2  create account default_1 ADMIN_NAME admin IDENTIFIED BY '111111';
     3  -- @session:id=1&user=default_1:admin&password=111111
     4  create role role1;
     5  grant create database on account * to role1;
     6  create user user1 identified by '123456' default role role1;
     7  create role role2;
     8  grant create database on account * to role2;
     9  create user user2 identified by '123456' default role role2;
    10  -- @session
    11  -- @session:id=2&user=default_1:user1:role1&password=123456
    12  create database db1;
    13  alter database db1 set mysql_compatibility_mode = '0.7.0';
    14  -- @session
    15  -- @session:id=3&user=default_1:user2:role2&password=123456
    16  alter database db1 set mysql_compatibility_mode = '0.8.0';
    17  -- @session
    18  drop account default_1;
    19  
    20  drop role if exists role1,role2;
    21  drop user if exists alter_user1,alter_user2,alter_user3,alter_user4;
    22  -- alter set mysql_compatibility_mode:sys account moadmin user
    23  create database alter_db;
    24  use alter_db;
    25  alter database alter_db set mysql_compatibility_mode = '1.0.0';
    26  alter database alter_db set mysql_compatibility_mode = '0.8.0';
    27  drop database alter_db;
    28  
    29  -- alter set mysql_compatibility_mode:sys account non moadmin user
    30  create user alter_user1 identified by '123';
    31  create role role1;
    32  create role role2;
    33  grant all on account * to role1;
    34  grant all on account * to role2;
    35  grant role1 to alter_user1;
    36  create user alter_user2 identified by '123';
    37  grant role2 to alter_user2;
    38  -- @session:id=4&user=sys:alter_user1:role1&password=123
    39  create database alter_db1;
    40  use alter_db1;
    41  alter database alter_db1 set mysql_compatibility_mode = '0.9.0';
    42  -- @session
    43  -- @session:id=5&user=sys:alter_user2:role2&password=123
    44  use alter_db1;
    45  alter database alter_db1 set mysql_compatibility_mode = '0.9.1';
    46  -- @session
    47  drop role role1,role2;
    48  drop user alter_user1,alter_user2;
    49  drop database alter_db1;
    50  
    51  -- alter set mysql_compatibility_mode: non sys account moadmin user
    52  create account alter_account ADMIN_NAME admin IDENTIFIED BY '12345';
    53  -- @session:id=6&user=alter_account:admin&password=12345
    54  create database alter_db2;
    55  use alter_db2;
    56  alter database alter_db2 set mysql_compatibility_mode = '1.0.0';
    57  drop database alter_db2;
    58  -- @session
    59  
    60  -- alter set mysql_compatibility_mode:non sys account non moadmin user
    61  -- @session:id=6&user=alter_account:admin&password=12345
    62  create user alter_user3 identified by '123';
    63  create role role1;
    64  create role role2;
    65  grant all on account * to role1;
    66  grant all on account * to role2;
    67  grant role1 to alter_user3;
    68  create user alter_user4 identified by '123';
    69  grant role2 to alter_user4;
    70  -- @session
    71  -- @session:id=7&user=alter_account:alter_user3:role1&password=123
    72  create database alter_db3;
    73  use alter_db3;
    74  alter database alter_db3 set mysql_compatibility_mode = '1.1.0';
    75  -- @session
    76  -- @session:id=8&user=alter_account:alter_user4:role2&password=123
    77  use alter_db3;
    78  alter database alter_db3 set mysql_compatibility_mode = '1.0.1';
    79  -- @session
    80  drop account alter_account;