在Debian服务器Jessie上，我的工作解决方案是简单地做

service mysql restart
service mysql reload

作为root用户

我尝试了以下步骤:

以超级用户登录或使用sudo 使用gedit打开/etc/mysql/my.cnf 找到bind-address，并将其值更改为数据库服务器主机的IP地址。对我来说，是localhost或127.0.0.1 保存并关闭文件。 回到终端，执行sudo service mysql start

这对我很有效。

This error can also occur if you try to change the directory where the database is stored, but imput the wrong directory in the configuration file (like a typo in the second drive as D instead of the accurate D_). Instead of telling you the typo directory does not exist, it will tell you that you lack permission to access it (leading you to try to change the permissions for the typo directory, which it will let you do). So if you get this error while changing directories, double check the configuration file and make sure you don't have a typo.

您的mysql服务器可能没有运行。输入mysql确保它运行。服务器启动进入终端。

将/opt/lampp/etc/my.cnf文件复制到/etc/mysql/my.cnf

在终端类型中:

mysql -u root

你会得到mysql>提示:

mysql> Update mysql.user set Password=PASSWORD('your_password') where user='root';

mysql> FLUSH PRIVILEGES;

在我的例子中，问题是我所有数据库的页面损坏(检查mysql错误日志)。

我用强制恢复InnoDB解决了这个问题。诀窍是编辑/etc/mysql/my.cnf并添加

innodb_force_recovery = 4

略低于

[mysqld]

然后重新启动mysql。 在检查一切工作正常后，再把线移回来。