MySQL upgrade form 5.7 to 8.0 on a Atlassian (Jira/Confluence)
Posted by: Marcelo Carvalho
Date: February 23, 2024 02:49PM

Upgrading from 5.7.42 to 8.0.36


Before upgrade I have changed the CHARTSET and COALLATION to Atlassian Databases/Tables/Columns to

utf8mb4 utf8mb4_bin

Done: $ sudo apt-get install mysql-server

No issues registered - exit status 0

Edited file my.cnf - inserted (temporaryly)

default_authentication_plugin=mysql_native_password

Still being hammered with 'tons' of same Waning line

2024-02-23T18:57:14.900087Z 47417 [Warning] [MY-013360] [Server] Plugin ?mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

Please what is my path to use "caching_sha2_password instead"

Please advise

Many thanks

Marcelo Carvalho
IT Senior System Administrator
Astranis Space Technologies Corp.
mcarvalho@astranis.com
https://www.astranis.com/

Marcelo Carvalho
IT Senior System Administrator
Astranis Space Technologies Corp.
mcarvalho@astranis.com

Options: ReplyQuote


Subject
Written By
Posted
MySQL upgrade form 5.7 to 8.0 on a Atlassian (Jira/Confluence)
February 23, 2024 02:49PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.