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.

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

MySQL 8.4.0 : default_authentication_plugin=mysql_native_password has been removed #772

Open
MGeurts opened this issue May 6, 2024 · 7 comments

Comments

@MGeurts
Copy link

MGeurts commented May 6, 2024

The new mySQL 8.4.0 LTS version is out.
A breaking change, anounced in the log files by previous versions, is the removing of default_authentication_plugin=mysql_native_password, because native-password authentication is deprecated.
So the version switch from 8.3.0 to 8.4.0 leaves us with a non working MySQL server.

I think LARAGONs version switch algorithm for MySQL has to be altered.
Thanks in advance.

@MGeurts
Copy link
Author

MGeurts commented May 7, 2024

The --default-authentication-plugin=mysql_native_password is removed, because native-password authentication is deprecated. In mysql 8.4 it's still possible to use the native_password authentication, but the parameter is renamed to --mysql-native-password=ON because it not only sets the plugin, but also activates the plugin (which is now disabled by default)

Add --mysql-native-password=ON to your args along with and remove the --default-authentication-plugin=mysql_native_password.

@MGeurts
Copy link
Author

MGeurts commented May 7, 2024

@gitizen1
Copy link

gitizen1 commented May 9, 2024

Add --mysql-native-password=ON to your args along with and remove the --default-authentication-plugin=mysql_native_password.

Release Notes 8.4.0

Novice here, so please forgive any oversights on my part...

Is this something to be changed on my.ini for the mysql version or somewhere in Laragon? Every new run errors out for me as a result of my.ini rewrite automatically re-inserting this line: default-authentication-plugin=mysql_native_password

@MGeurts
Copy link
Author

MGeurts commented May 10, 2024

This has to be changed in the LARAGON Core scripts.
We'll have to wait for a new release, I guess.

@meorajrul
Copy link

see my guide here for now https://gist.github.com/meorajrul/b57803bf1b4ddfd2f93e6ad37c3ac5f2

@gitizen1
Copy link

gitizen1 commented May 10, 2024

see my guide here for now https://gist.github.com/meorajrul/b57803bf1b4ddfd2f93e6ad37c3ac5f2

Still no go... I can't downgrade it either -- errors galore!

Update: The fix seems to be working now. Thanks!

@abhirupnandy
Copy link

Steps taken for successfully installing -

  1. extract mysql-8.4 zip to ~/laragon/bin (where you've installed laragon in windows)
  2. open the folder and open my.conf / my.ini file (make sure to keep a backup of the original file before changing the current file).
  3. remove the line --default-authentication-plugin=mysql_native_password from the file and save it.
  4. change the data directory value (one line above the modified line to C:\laragon\data\mysql-8.4 (to keep it consistent with a default installation.
  5. now in terminal, navigate to the mysql-8.4 binaries (example: cd C:\laragon\bin\mysql\mysql-8.4.0-winx64\bin)
  6. run this command ./mysqld --initialize --datadir="C:\laragon\data\mysql-8.4" --basedir="C:\laragon\bin\mysql\mysql-8.4.0-winx64" --console --mysql-native-password=ON
  7. now follow the next steps from ...

see my guide here for now https://gist.github.com/meorajrul/b57803bf1b4ddfd2f93e6ad37c3ac5f2

** PS** After installing, if error shows up in HeidiSQL for root password, use "Prompt for credentials" option. After typing the password (previously generated in the terminal), you'll get option to change password for first time.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants