MySQL does not have a version upgrade function, so I always reinstall a new version.
MySQL 8.3 and 8.4 cannot be clean installed on macOS 14.4 :
https://forums.mysql.com/read.php?11,723964
This time is "MySQL 8.4.1 and 9.0 cannot be clean installed on macOS 14.5"
Step 1: First, uninstall the old MySQL version, then download the latest version of mysql-9.0.0-macos14-x86_64.dmg or mysql-8.4.1-macos14-x86_64.dmg.
Note: There is no any "my.cnf" file in /etc/mysql/
Step 2: Open macOS Terminal and enter...
mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
mysql -uroot -p --ssl-mode=REQUIRED
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
mysql -uroot -p --ssl-mode=DISABLED
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
MySQL 9.0 and MySQL 8.4.1 have the same error message.