在设置mysql-8 zip版本时，我得到了同样的错误。最后，切换到无缝工作的安装版本。在安装过程中，会提示设置root密码。一旦设置好，它就一定能工作。

修复macOS

Install MySQL from https://downloads.mysql.com/archives/community/ (8.x is the latest as on date, but ensure that the version is compatible with the macOS version) Give password for root (let <root-password> be the password) during installation (don't forget to remember the password!) Select Use Legacy Password Encryption option (that is what I had used and did not try for Use Strong Password Encryption option) Search and open MySQL.prefPane (use search tool) Select Configuration tab Click Select option of Configuration File Select /private/etc/my.cnf From terminal open a new or existing file with name /etc/my.cnf (vi /etc/my.cnf) add the following content: [mysqld] skip-grant-tables Restart mysqld as follows: ps aux | grep mysql kill -9 <pid1> <pid2> ... (grab pids of all MySQL related processes) mysqld gets restarted automatically Verify that the option is set by running the following from terminal: ps aux | grep mysql > mysql/bin/mysqld ... --defaults-file=/private/etc/my.cnf ... (output) Run the following command to connect (let mysql-<version>-macos<version>-x86_64 be the folder where MySQL is installed. To grab the actual folder, run ls /usr/local/ and copy the folder name): /usr/local/mysql-<version>-macos<version>-x86_64/bin/mysql -uroot -p<root-password>

在设置mysql-8 zip版本时，我得到了同样的错误。最后，切换到无缝工作的安装版本。在安装过程中，会提示设置root密码。一旦设置好，它就一定能工作。

对于Ubuntu/Debian用户

(它可能适用于其他发行版，尤其是基于debian的发行版。)

运行以下命令以root身份连接(不需要任何密码)

sudo /usr/bin/mysql --defaults-file=/etc/mysql/debian.cnf

如果你不想每次以根用户连接时都添加——defaults-file，你可以将/etc/mysql/debian.cnf复制到你的主目录:

sudo cp /etc/mysql/debian.cnf ~/.my.cnf

然后:

sudo mysql

对于新Linux用户来说，这可能是一项艰巨的任务。让我用MySQL 8更新这个(目前可用的最新版本是8.0.12，截至2018-09-12)

Open "mysqld.cnf" configuration file at "/etc/mysql/mysql.conf.d/". Add skip-grant-tables to the next line of [mysql] text and save. Restart the MySQL service as "sudo service mysql restart". Now your MySQL is free of any authentication. Connect to the MySQL client (also known as mysql-shell) as mysql -u root -p. There is no password to be keyed in as of now. Run SQL command flush privileges; Reset the password now as ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPassword'; Now let's get back to the normal state; remove that line "skip-grant-tables" from "mysqld.cnf" and restart the service.

就是这样。

解决方法:放弃!

听我说完。我花了整整两天的时间试图让MySQL工作，但没有任何效果，总是被权限错误卡住，没有一个是通过这个问题的答案解决的。我想，如果我继续下去，我会疯掉的。

由于没有耐心，我发送了安装SQLite的命令，只使用了450 KB，它从一开始就工作得很好。

如果你没有圣人的耐心，那就使用SQLite吧，这样可以为你节省大量的时间、精力、痛苦和存储空间。