Cask: MySQL server upgrade: Cannot upgrade from 80300 to 90100

[Lundissimo]

Output of brew config

HOMEBREW_VERSION: 4.4.14
ORIGIN: https://github.com/Homebrew/brew
HEAD: f84082963da8af8c9ccd6dffbe932eba457e2b78
Last commit: 4 days ago
Branch: stable
Core tap JSON: 03 Jan 01:52 UTC
Core cask tap JSON: 03 Jan 01:55 UTC
HOMEBREW_PREFIX: /usr/local
HOMEBREW_REPOSITORY: /usr/local/homebrew
HOMEBREW_CASK_OPTS: []
HOMEBREW_MAKE_JOBS: 16
Homebrew Ruby: 3.3.6 => /usr/local/homebrew/Library/Homebrew/vendor/portable-ruby/3.3.6/bin/ruby
CPU: 16-core 64-bit kabylake
Clang: 15.0.0 build 1500
Git: 2.39.3 => /Applications/Xcode.app/Contents/Developer/usr/bin/git
Curl: 8.7.1 => /usr/bin/curl
macOS: 14.7.2-x86_64
CLT: 16.2.0.0.1.1733547573
Xcode: 15.4

Output of brew doctor

Please note that these warnings are just used to help the Homebrew maintainers
with debugging if you file an issue. If everything you use Homebrew for is
working fine: please don't worry or file an issue; just ignore this. Thanks!

Warning: Some installed casks are deprecated or disabled.
You should find replacements for the following casks:
  webpack-dashboard

Warning: Some installed kegs have no formulae!
This means they were either deleted or installed manually.
You should find replacements for the following formulae:
  libav
  mcrypt
  qtfaststart
  crush-tools

Warning: Some installed formulae are deprecated or disabled.
You should find replacements for the following formulae:
  devdash
  libav
  [email protected]
  [email protected]
  [email protected]
  youtube-dl

Warning: Unbrewed dylibs were found in /usr/local/lib.
If you didn't put them there on purpose they could cause problems when
building Homebrew formulae and may need to be deleted.

Unexpected dylibs:
  /usr/local/lib/libaacs.dylib
  /usr/local/lib/libcharset.1.dylib
  /usr/local/lib/libiconv.2.dylib
  /usr/local/lib/libjpeg.62.0.0.dylib
  /usr/local/lib/libpng.3.dylib
  /usr/local/lib/libpng12.0.dylib

Warning: Unbrewed header files were found in /usr/local/include.
If you didn't put them there on purpose they could cause problems when
building Homebrew formulae and may need to be deleted.

Unexpected header files:
  /usr/local/include/ft2build.h
  /usr/local/include/libcharset.h
  /usr/local/include/libpng12/png.h
  /usr/local/include/libpng12/pngconf.h
  /usr/local/include/localcharset.h
  /usr/local/include/python2.6/sip.h
  /usr/local/include/zconf.h
  /usr/local/include/zlib.h

Warning: Unbrewed '.la' files were found in /usr/local/lib.
If you didn't put them there on purpose they could cause problems when
building Homebrew formulae and may need to be deleted.

Unexpected '.la' files:
  /usr/local/lib/libcharset.la
  /usr/local/lib/libfreetype.la
  /usr/local/lib/libiconv.la
  /usr/local/lib/libjpeg.la
  /usr/local/lib/libmcrypt.la
  /usr/local/lib/libpng12.la
  /usr/local/lib/libtesseract.la

Warning: Unbrewed '.pc' files were found in /usr/local/lib/pkgconfig.
If you didn't put them there on purpose they could cause problems when
building Homebrew formulae and may need to be deleted.

Unexpected '.pc' files:
  /usr/local/lib/pkgconfig/libpng12.pc

Warning: Unbrewed static libraries were found in /usr/local/lib.
If you didn't put them there on purpose they could cause problems when
building Homebrew formulae and may need to be deleted.

Unexpected static libraries:
  /usr/local/lib/libcharset.a
  /usr/local/lib/libpng12.a

Warning: Broken symlinks were found. Remove them with `brew cleanup`:
  /usr/local/bin/java
  /usr/local/lib/libSQLite3.dylib

Description of issue

After 'brew upgrade', [email protected] was installed. But mysql fails because it must upgrade from [email protected]. I installed [email protected], but the error persists. How can I get past this?

Relevant casks

[email protected]

[SMillerDev]

The upgrade would have output the following message:

https://formulae.brew.sh/formula/mysql#:~:text=Upgrading%20from%20MySQL%20%3C8.4%20to%20MySQL%20%3E9.0%20requires%20running%20MySQL%208.4%20firs,-t

[Lundissimo]

Yes, Homebrew output that message after upgrade. After installing 8.4, I'm told that it's "keg only" so no mysql symlinks were created. I then did 'brew uninstall mysql' and 'brew uninstall [email protected]' trying to start from scratch. But subsequent 'install mysql' says it can't upgrade from 8.3. But there is no longer any [email protected] available.

[SMillerDev]

Did you start the [email protected] service like the instructions said?

[Lundissimo]

Yes, sorry I omitted the fact that I followed the instructions in the report. I installed [email protected] and was able to do 'brew link [email protected]' after removing mysql first. With 8.4 running, I did "brew install mysql" which still reports "Upgrading from MySQL <8.4 to MySQL >9.0 requires running MySQL 8.4 first". After restarting and stopping [email protected] and reinstalling 'mysql' (9.1), I finally worked, including "Data dictionary upgrading from version '80300' to '90000'.", and mysql 9.1 now works!

[SMillerDev]

I installed [email protected] and was able to do 'brew link [email protected]' after removing mysql first.

This isn't needed to run it. Next time you can just run it directly without linking