Navicat new database 3680 error solution on mac
1. Close mysql in settings. If it cannot be closed, enter:
sudo /usr/local/mysql/support-files/ stop
2. Enter in the terminal:
cd /usr/local/mysql/bin/
3. After entering, log in to manage permissions:
sudo su
4. After entering, you need to skip mysql security verification
./mysqld_safe --skip-grant-tables &
Later, you will find that the mysql that was closed in front has started running again
6. Enter:
./mysql
7. Enter:
FLUSH PRIVILEGES;
8. Next, you can change the password:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('Here is your new password');
9. Restart mysql
sudo /usr/local/mysql/support-files/ restart
10. Enter:
mysql -uroot -p
Enter the modified password to log in and then enter the navicat new database and found that there is no prompt for an error of 3680.
I don't know why.
This is the article about the solution to the 3680 error of Navicat's new database on mac. For more information about Navicat's new database 3680 error, please search for my previous articles or continue browsing the related articles below. I hope everyone will support me in the future!