我已经安装了以下版本的 MySQL:
kurt@kurt-ThinkPad:~$ mysql -V
mysql Ver 14.14 Distrib 5.7.15, for Linux (x86_64) using EditLine wrapper
我记得我在安装过程中没有为 root 用户设置密码。但是,如果我尝试简单地使用mysql
命令,我收到以下错误:
kurt@kurt-ThinkPad:~$ mysql
ERROR 1045 (28000): Access denied for user 'kurt'@'localhost' (using password: NO)
同样,作为 root 用户,
kurt@kurt-ThinkPad:~$ mysql -u root
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
我尝试按照以下说明进行操作重置 Root 密码:Unix 和类 Unix 系统 https://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html;我在我的主目录中创建了文本文件,然后尝试使用以下命令启动 MySQL 服务器--init-file
选项。但是,我再次收到权限错误:
kurt@kurt-ThinkPad:~$ mysqld_safe --init-file=mysql-init &
[1] 18340
kurt@kurt-ThinkPad:~$ /usr/bin/mysqld_safe: 548: /usr/bin/mysqld_safe: cannot create /var/lib/mysql/mysqld_safe.pid: Permission denied
2016-09-20T14:57:04.753720Z mysqld_safe Logging to '/var/log/mysql/error.log'.
cat: /var/run/mysqld/mysqld.pid: Permission denied
rm: cannot remove '/var/run/mysqld/mysqld.pid': Permission denied
2016-09-20T14:57:04.780206Z mysqld_safe Fatal error: Can't remove the pid file:
/var/run/mysqld/mysqld.pid
Please remove it manually and start /usr/bin/mysqld_safe again;
mysqld daemon not started
/usr/bin/mysqld_safe: 135: /usr/bin/mysqld_safe: cannot create /var/log/mysql/error.log: Permission denied
rm: cannot remove '/var/lib/mysql/mysqld_safe.pid': Permission denied
我读过类似的错误无法连接Mysql服务器;无法创建/写入 pid 文件 https://stackoverflow.com/questions/15408643/cant-connect-to-mysql-server-cant-create-write-the-pid-file,其中建议的解决方案是将 MySQL 用户分配给/var/run/mysqld
目录。但是,如果我尝试这样做,我会收到“不允许操作”:
kurt@kurt-ThinkPad:~$ chown mysql:mysql /var/run/mysqld
chown: changing ownership of '/var/run/mysqld': Operation not permitted
关于如何让 MySQL 工作有什么想法吗?