Bug #89267 | Unable to access 8.0.4 server after starting on top of 5.7.20 database | ||
---|---|---|---|
Submitted: | 16 Jan 2018 15:34 | Modified: | 21 Mar 2018 15:21 |
Reporter: | Simon Mudd (OCA) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Command-line Clients | Severity: | S2 (Serious) |
Version: | 8.0.4 | OS: | CentOS (7) |
Assigned to: | Rahul Sisondia | CPU Architecture: | Any |
Tags: | mysql_upgrade, unknown error, upgrade |
[16 Jan 2018 15:34]
Simon Mudd
[16 Jan 2018 15:36]
Simon Mudd
Not mentioned. This was with CentOS 7 rpms.
[16 Jan 2018 15:37]
Simon Mudd
A colleague said to me: For being able to connect to MySQL, you need to remove "--skip-grant-tables".
[16 Jan 2018 16:14]
Simon Mudd
For clarity on a previous comment: "stop mysqld and restart" refers to starting mysql normally with no special options, not to restart with the special startup options shown.
[17 Jan 2018 10:21]
MySQL Verification Team
Hello Simon, Thank you for the report and feedback. Thanks, Umesh
[17 Jan 2018 10:22]
MySQL Verification Team
test results
Attachment: 89267.results (application/octet-stream, text), 6.96 KiB.
[31 Jan 2018 8:56]
Rahul Sisondia
Workaround - Don't specify the password at the client while connecting to the server which is started with --skip-grant-tables option.
[6 Feb 2018 16:15]
Daniƫl van Eeden
Something like this seems to work: 1. stop 5.7.21 2. swap binaries for 8.0.4 3. start mysql with skip-networking and skip-grant-tables etc. 4. sudo mysql_upgrade --no-defaults $(sudo my_print_defaults client | egrep '^--socket' | head -1) 5. restart mysql
[21 Mar 2018 15:21]
Paul DuBois
Posted by developer: Fixed in 8.0.11. If the server was started with --skip-grant-tables, clients that authenticate using the caching_sha2_password plugin were unable to connect.