我试图移动我的datadir在一个工作的MySql安装,显然我搞砸了。
我试图卸载/重新安装无数次,只有在重新安装时得到相同的错误。
mysql / error.log给我这个:
150118 11:54:44 [Note] Plugin 'FEDERATED' is disabled. 150118 11:54:44 InnoDB: The InnoDB memory heap is disabled 150118 11:54:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins 150118 11:54:44 InnoDB: Compressed tables use zlib 1.2.8 150118 11:54:44 InnoDB: Using Linux native AIO 150118 11:54:44 InnoDB: Initializing buffer pool, size = 128.0M 150118 11:54:44 InnoDB: Completed initialization of buffer pool 150118 11:54:44 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation.
我已经变成了chmod和chmodded,直到我在脸上蓝色,无论如何我得到同样的错误。 我也跟着如何卸载MySQL的许multithreading,只有重新安装有相同的结果。
安装尝试后,我得到这个错误:
Setting up mysql-server-5.5 (5.5.40-0ubuntu0.14.04.1) ... 150118 11:58:01 [Warning] Can't create test file /var/lib/mysql/yosemite.lower-test 150118 11:58:01 [Warning] Can't create test file /var/lib/mysql/yosemite.lower-test start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing package mysql-server-5.5 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-server-5.5; however: Package mysql-server-5.5 is not configured yet. dpkg: error processing package mysql-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mysql-server-5.5 mysql-server E: Sub-process /usr/bin/dpkg returned an error code (1)
MySQL是/ var / lib / mysql /的所有者,文件权限应该允许写入。
我不需要保存任何数据库,我只需要杀死这个东西,并重新安装和工作!
任何帮助将非常感激,提前感谢!
RW
我已经卸载了MySQL,并重新安装了,我仍然捏着自己。
解决scheme很简单。 我确信我在模拟这个问题的某个地方执行了这些操作,但是对于寻求解决scheme的任何人来说,这就是我所做的:
清除mysql-server-5.1和mysql-common。
之后,删除/ var / lib / mysql / etc / mysql和/ var / log / mysql。
然后我重新启动机器。
src: http : //ubuntuforums.org/showthread.php?t=1407998&p=9332936#post9332936
再次,不知道为什么现在这个工作,当我做了所有其他尝试的各个步骤,但我不会马上看到礼物马。 希望别人认为这有用。