Description:
The community installer fails to finish installing MySQL 8.0.29 unless I stop it, uninstall it, and reinstall it specifying that it use legacy authentication methods. This is the second time I've experienced this issue recently. The obvious problem to me is this error:
"Option --authentication-policy is set to an invalid value. Please check if the specified authentication plugins are valid."
But why I'm receiving this on a brand new installation on a fresh version of Windows I could not say.
Here's the log output:
Beginning configuration step: Writing configuration file
Saving my.ini configuration file...
Saved my.ini configuration file.
Ended configuration step: Writing configuration file
Beginning configuration step: Updating Windows Firewall rules
Adding a Windows Firewall rule for MySQL80 on port 3306.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow
Ok.
Successfully added the Windows Firewall rule.
Adding a Windows Firewall rule for MySQL80 on port 33060.
Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow
Ok.
Successfully added the Windows Firewall rule.
Ended configuration step: Updating Windows Firewall rules
Beginning configuration step: Adjusting Windows service
Attempting to grant Network Service require filesystem permissions.
Granted permissions.
Adding new service
New service added
Ended configuration step: Adjusting Windows service
Beginning configuration step: Initializing database (may take a long time)
Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 8.0.29...
Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.29) initializing of server in progress as process 5864
InnoDB initialization has started.
InnoDB initialization has ended.
Option --authentication-policy is set to an invalid value. Please check if the specified authentication plugins are valid.
Process for mysqld, with ID 5864, was run successfully and exited with code 0.
Successfully started process for MySQL Server 8.0.29.
MySQL Server 8.0.29 intialized the database successfully.
Ended configuration step: Initializing database (may take a long time)
Beginning configuration step: Starting the server
Attempting to start service MySQL80...
How to repeat:
Install using these options
Setup Type: Full
Check Requirements: Install the necessary VS requirements
Download: Downloads all the products
Installation: The server (and other products) install with no problem
Product configuration / Type and Networking / Config type: Server Computer
Product configuration / Type and Networking / Connectivity:
TCP/IP: checked
Port 3306
X Protocol Port: 33060
Open Windows firewall: checked
Named Pipe / Pipe name: Checked MYSQL
Show Advanced and Logging Options: Unchecked
Product configuration / Authentication Method
Use string password encryption for Authentication: Selected
Product configuration / Accounts and Roles
Enter the Root password:
Product configuration / Windows Service
Configure MySQL Server as a Windows Service: Checked
Service Name: MySQL80
Start the MySQL Server at Startup: Checked
Run Windows Service as: Standard System Account
Product configuration / Apply Configuration
Hangs on the Starting the server stop.
Cancel the installation. Remove the software. Reinstall but select
Use Legacy Authentication Method on the Product configuration / Authentication Method screen and the installation completes just fine.
