db-command/features/db-users.feature at 7f2d7d9b210fbf6b127d74d7bf8ea6d46dac2605 · wp-cli/db-command · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
Feature: Manage database users

  Scenario: Create database user without privileges
    Given an empty directory
    And WP files
    And wp-config.php

    When I run `wp db create`
    Then STDOUT should be:
      """
      Success: Database created.
      """

    When I run `wp db users create testuser localhost --password=testpass123`
    Then STDOUT should contain:
      """
      Success: Database user 'testuser'@'localhost' created.
      """

    When I run `wp db query "SELECT User, Host FROM mysql.user WHERE User='testuser'"`
    Then STDOUT should contain:
      """
      testuser
      """

  Scenario: Create database user with privileges
    Given an empty directory
    And WP files
    And wp-config.php

    When I run `wp db create`
    Then STDOUT should be:
      """
      Success: Database created.
      """

    When I run `wp db users create appuser localhost --password=secret123 --grant-privileges`
    Then STDOUT should contain:
      """
      created with privileges on database
      """
    And STDOUT should contain:
      """
      appuser
      """

  Scenario: Create database user with custom host
    Given an empty directory
    And WP files
    And wp-config.php

    When I run `wp db create`
    Then STDOUT should be:
      """
      Success: Database created.
      """

    When I run `wp db users create remoteuser '%' --password=remote123`
    Then STDOUT should contain:
      """
      Success: Database user 'remoteuser'@'%' created.
      """

  Scenario: Create database user with no password
    Given an empty directory
    And WP files
    And wp-config.php

    When I run `wp db create`
    Then STDOUT should be:
      """
      Success: Database created.
      """

    When I run `wp db users create nopassuser localhost`
    Then STDOUT should contain:
      """
      Success: Database user 'nopassuser'@'localhost' created.
      """