View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 1727 | RackTables | default | public | 2017-02-08 19:15 | 2017-05-15 18:50 |
| Reporter | infrastation | Assigned To | infrastation | ||
| Priority | normal | Severity | text | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 0.20.12 | ||||
| Target Version | 0.20.14 | Fixed in Version | 0.20.14 | ||
| Summary | 1727: replace GRANT with CREATE USER | ||||
| Description | The following files use or suggest to use GRANT ALL PRIVILEGES: * tests/README.md * tests/UpgradeTest.php * tests/travis_setup_mysql.sh * wwwroot/inc/install.php It turns out at some point in time this will stop to work: mysql> SHOW WARNINGS; +---------+------+------------------------------------------------------------------------------------------------------------------------------------+ | Level | Code | Message | +---------+------+------------------------------------------------------------------------------------------------------------------------------------+ | Warning | 1287 | Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. | +---------+------+------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) The job here is to read the documentation and switch to the more modern syntax. | ||||
| Tags | No tags attached. | ||||
 |
The current MySQL documentation suggests to use two statements (CREATE USER and GRANT) instead of one combined GRANT. The current code now implements this in the suggestions it makes. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-02-08 19:15 | infrastation | New Issue | |
| 2017-02-13 19:10 | infrastation | Description Updated | |
| 2017-05-15 18:50 | infrastation | Assigned To | => infrastation |
| 2017-05-15 18:50 | infrastation | Severity | minor => text |
| 2017-05-15 18:50 | infrastation | Status | new => closed |
| 2017-05-15 18:50 | infrastation | Resolution | open => fixed |
| 2017-05-15 18:50 | infrastation | Fixed in Version | => 0.20.14 |
| 2017-05-15 18:50 | infrastation | Target Version | => 0.20.14 |
| 2017-05-15 18:50 | infrastation | Note Added: 0003617 |
