Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MySQL 8: user creation #4

Closed
4 of 6 tasks
bschmalhofer opened this issue May 6, 2020 · 1 comment
Closed
4 of 6 tasks

MySQL 8: user creation #4

bschmalhofer opened this issue May 6, 2020 · 1 comment
Milestone
OTOBO 10.0.1

Comments

@bschmalhofer
Copy link
Contributor

bschmalhofer commented May 6, 2020 •
edited by svenoe
Loading

In MySQL 8, the default authentication plugin has changed from 'mysql_native_password' to 'caching_sha2_password'. The goal is to stay with 'mysql_native_password'.
Also creating users with GRANT is no longer supported.

TODO:

  • Check the install docs and the code for database user creation
  • Switch to 'CREATE USER ... IDENTIFIED WITH mysql_native_password
  • Test with MySQL 8
  • Test with MySQL 5.7
  • Test with MySQL 5.6
  • Maybe test with older MySQL version if they are still relevant.
@bschmalhofer bschmalhofer mentioned this issue May 6, 2020
Closed
5 tasks
bschmalhofer added a commit to bschmalhofer/otobo that referenced this issue May 7, 2020
@bschmalhofer
Issue RotherOSS#4: adapt the user creation and the setup of privileges
74a841d 
Should be compatible with MySQL 5.6, 5.7, and 8.0
svenoe added a commit that referenced this issue May 7, 2020
@svenoe
Fix Issue #4: adapt the user creation and the setup of privileges
94c171c 
Merge pull request #5 from bschmalhofer/issue-4-create_mysql_user
@bschmalhofer
Copy link
Contributor Author

I suppose that there is no need to worry about MySQL 5.6 or earlier. Closing the issue.

@bschmalhofer bschmalhofer added this to the OTOBO 10.0 milestone Jul 22, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
OTOBO 10.0.1
Development

No branches or pull requests
1 participant
@bschmalhofer