Hi all ive done a clean install of ubuntu 20 and i installed mysql 8.
Firstly i have problems with connecting to my server due to the password auth mechanism used by mysql 8 ive fou d that if i alter my database user account to use the mysql_native_password authentication i can connect.
Secondly mysql does not start at boot time i get some vauge error might be the cinfig file got messed up so im going to purge mysql and reinatall
How do i get mysql 8 to use the mysql_native_password authentication plugin instead of the sha2 preferred plugin?
And how do i get mysql to start at boot?
Any help you can give is much appreciated
Sent from my POT-LX1 using Tapatalk
Firstly i have problems with connecting to my server due to the password auth mechanism used by mysql 8 ive fou d that if i alter my database user account to use the mysql_native_password authentication i can connect.
Secondly mysql does not start at boot time i get some vauge error might be the cinfig file got messed up so im going to purge mysql and reinatall
How do i get mysql 8 to use the mysql_native_password authentication plugin instead of the sha2 preferred plugin?
And how do i get mysql to start at boot?
Any help you can give is much appreciated
Sent from my POT-LX1 using Tapatalk