Skip to content

Instantly share code, notes, and snippets.

@icai

icai/gist:6e97609099c0d4aef38b82b79d9357d3

Created December 17, 2024 12:17
Show Gist options
  • Save icai/6e97609099c0d4aef38b82b79d9357d3 to your computer and use it in GitHub Desktop.
Save icai/6e97609099c0d4aef38b82b79d9357d3 to your computer and use it in GitHub Desktop.
Download ZIP
mysql9 mysql_native_password fix without backup
Raw
gistfile1.txt
mysql9 mysql_native_password fix
code /usr/local/etc/my.cnf
```ini
[mysqld]
skip-grant-tables
```
brew services restart mysql
mysqldump -u root --all-databases > all_databases_backup.sql
after that, use the new one.
mysql -u root -p < all_databases_backup.sql
@icai
Copy link
Author

icai commented Dec 17, 2024

/usr/local/var/mysql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment