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 |