Closed Bug 1759014 Opened 3 years ago Closed 3 years ago

Compatibility issues with MySQL 8.0

Categories

(Bugzilla :: Bugzilla-General, defect)

5.0.6
defect

Tracking

()

RESOLVED DUPLICATE of bug 1424043

People

(Reporter: matt.simons, Unassigned)

Details

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36

Steps to reproduce:

Fresh install of bugzilla and MySQL 8.0. During install and configure process experienced many errors

Actual results:

There were authentication errors and numerous syntax errors on queries. After digging into this it was determined that MySQL 8.0 uses a different authentication method and much of the query syntax for Bugzilla is not compatible with 8.0. Particularly 'groups' is now a reserved keyword but Bugzilla makes tables called groups which causes issues. After fixing this we continued to have syntax issues so installed MySQL 5.7 and now Bugzilla is working

Status: UNCONFIRMED → RESOLVED
Closed: 3 years ago
Resolution: --- → DUPLICATE
You need to log in before you can comment on or make changes to this bug.