MySQL not starting because “mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)”
up vote
3
down vote
favorite
I am setting up a new LAMP server with Ubuntu Server 13.10 and MySQL 5.5 and was in the middle of migrating mysql databases to new server when I realized mysql server is not running. All was fine last time I checked a couple of days ago. I get this when I try to launch server from command line:
@Ubuntu:~$ sudo mysqld start
[sudo] password for XXX:
140402 10:32:07 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
140402 10:32:07 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140402 10:32:07 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140402 10:32:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140402 10:32:07 InnoDB: The InnoDB memory heap is disabled
140402 10:32:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140402 10:32:07 InnoDB: Compressed tables use zlib 1.2.8
140402 10:32:07 InnoDB: Using Linux native AIO
140402 10:32:07 InnoDB: Initializing buffer pool, size = 128.0M
140402 10:32:07 InnoDB: Completed initialization of buffer pool
140402 10:32:07 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.
Also when I try this:
XXX@Ubuntu-SHS:~$ sudo /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [fail]
Nothing at all in error logs.
Update: Noticed that all Directories & files under /var/lib/mysql have been changed to messagebus for owner/group. is this right? My other setup shows everything as mysql mysql.
mysql
edited Apr 3 '14 at 1:51
Lucio
12.3k2183157
asked Apr 2 '14 at 14:50
AlanK
61127
add a comment |
up vote
3
down vote
favorite
I am setting up a new LAMP server with Ubuntu Server 13.10 and MySQL 5.5 and was in the middle of migrating mysql databases to new server when I realized mysql server is not running. All was fine last time I checked a couple of days ago. I get this when I try to launch server from command line:
@Ubuntu:~$ sudo mysqld start
[sudo] password for XXX:
140402 10:32:07 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
140402 10:32:07 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140402 10:32:07 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140402 10:32:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140402 10:32:07 InnoDB: The InnoDB memory heap is disabled
140402 10:32:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140402 10:32:07 InnoDB: Compressed tables use zlib 1.2.8
140402 10:32:07 InnoDB: Using Linux native AIO
140402 10:32:07 InnoDB: Initializing buffer pool, size = 128.0M
140402 10:32:07 InnoDB: Completed initialization of buffer pool
140402 10:32:07 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.
Also when I try this:
XXX@Ubuntu-SHS:~$ sudo /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [fail]
Nothing at all in error logs.
Update: Noticed that all Directories & files under /var/lib/mysql have been changed to messagebus for owner/group. is this right? My other setup shows everything as mysql mysql.
mysql
edited Apr 3 '14 at 1:51
Lucio
12.3k2183157
asked Apr 2 '14 at 14:50
AlanK
61127
Your question has been asked previously on DBA.SE and you may find useful its asnwer. Let us know if that is a working solution. Just to mention,140402is not the error number but your system date.
– Lucio
Apr 3 '14 at 1:51
add a comment |
up vote
3
down vote
favorite
up vote
3
down vote
favorite
I am setting up a new LAMP server with Ubuntu Server 13.10 and MySQL 5.5 and was in the middle of migrating mysql databases to new server when I realized mysql server is not running. All was fine last time I checked a couple of days ago. I get this when I try to launch server from command line:
@Ubuntu:~$ sudo mysqld start
[sudo] password for XXX:
140402 10:32:07 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
140402 10:32:07 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140402 10:32:07 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140402 10:32:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140402 10:32:07 InnoDB: The InnoDB memory heap is disabled
140402 10:32:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140402 10:32:07 InnoDB: Compressed tables use zlib 1.2.8
140402 10:32:07 InnoDB: Using Linux native AIO
140402 10:32:07 InnoDB: Initializing buffer pool, size = 128.0M
140402 10:32:07 InnoDB: Completed initialization of buffer pool
140402 10:32:07 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.
Also when I try this:
XXX@Ubuntu-SHS:~$ sudo /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [fail]
Nothing at all in error logs.
Update: Noticed that all Directories & files under /var/lib/mysql have been changed to messagebus for owner/group. is this right? My other setup shows everything as mysql mysql.
mysql
edited Apr 3 '14 at 1:51
Lucio
12.3k2183157
asked Apr 2 '14 at 14:50
AlanK
61127
I am setting up a new LAMP server with Ubuntu Server 13.10 and MySQL 5.5 and was in the middle of migrating mysql databases to new server when I realized mysql server is not running. All was fine last time I checked a couple of days ago. I get this when I try to launch server from command line:
@Ubuntu:~$ sudo mysqld start
[sudo] password for XXX:
140402 10:32:07 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
140402 10:32:07 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
140402 10:32:07 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140402 10:32:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140402 10:32:07 InnoDB: The InnoDB memory heap is disabled
140402 10:32:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140402 10:32:07 InnoDB: Compressed tables use zlib 1.2.8
140402 10:32:07 InnoDB: Using Linux native AIO
140402 10:32:07 InnoDB: Initializing buffer pool, size = 128.0M
140402 10:32:07 InnoDB: Completed initialization of buffer pool
140402 10:32:07 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.
Also when I try this:
XXX@Ubuntu-SHS:~$ sudo /etc/init.d/mysql restart
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [fail]
Nothing at all in error logs.
Update: Noticed that all Directories & files under /var/lib/mysql have been changed to messagebus for owner/group. is this right? My other setup shows everything as mysql mysql.
mysql
mysql
edited Apr 3 '14 at 1:51
Lucio
12.3k2183157
asked Apr 2 '14 at 14:50
AlanK
61127
edited Apr 3 '14 at 1:51
Lucio
12.3k2183157
asked Apr 2 '14 at 14:50
AlanK
61127
edited Apr 3 '14 at 1:51
Lucio
12.3k2183157
edited Apr 3 '14 at 1:51
Lucio
12.3k2183157
edited Apr 3 '14 at 1:51
Lucio
12.3k2183157
12.3k2183157
asked Apr 2 '14 at 14:50
AlanK
61127
asked Apr 2 '14 at 14:50
AlanK
61127
asked Apr 2 '14 at 14:50
AlanK
61127
61127
Your question has been asked previously on DBA.SE and you may find useful its asnwer. Let us know if that is a working solution. Just to mention,140402is not the error number but your system date.
– Lucio
Apr 3 '14 at 1:51
add a comment |
Your question has been asked previously on DBA.SE and you may find useful its asnwer. Let us know if that is a working solution. Just to mention,140402is not the error number but your system date.
– Lucio
Apr 3 '14 at 1:51
Your question has been asked previously on DBA.SE and you may find useful its asnwer. Let us know if that is a working solution. Just to mention,
140402 is not the error number but your system date.– Lucio
Apr 3 '14 at 1:51
Your question has been asked previously on DBA.SE and you may find useful its asnwer. Let us know if that is a working solution. Just to mention,
140402 is not the error number but your system date.– Lucio
Apr 3 '14 at 1:51
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
close selinux
setenforce 0
or
vi /etc/selinux/config
SELINUX=disabled
restart
edited Jun 27 '17 at 8:44
Sumeet Deshmukh
4,31552971
answered Jun 27 '17 at 7:52
user704879
1
Ubuntu doesn't use SELinux. This is not a valid answer.
– Thomas Ward♦
Jan 27 at 16:35
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
close selinux
setenforce 0
or
vi /etc/selinux/config
SELINUX=disabled
restart
edited Jun 27 '17 at 8:44
Sumeet Deshmukh
4,31552971
answered Jun 27 '17 at 7:52
user704879
1
Ubuntu doesn't use SELinux. This is not a valid answer.
– Thomas Ward♦
Jan 27 at 16:35
add a comment |
up vote
0
down vote
close selinux
setenforce 0
or
vi /etc/selinux/config
SELINUX=disabled
restart
edited Jun 27 '17 at 8:44
Sumeet Deshmukh
4,31552971
answered Jun 27 '17 at 7:52
user704879
1
Ubuntu doesn't use SELinux. This is not a valid answer.
– Thomas Ward♦
Jan 27 at 16:35
add a comment |
up vote
0
down vote
up vote
0
down vote
close selinux
setenforce 0
or
vi /etc/selinux/config
SELINUX=disabled
restart
edited Jun 27 '17 at 8:44
Sumeet Deshmukh
4,31552971
answered Jun 27 '17 at 7:52
user704879
1
close selinux
setenforce 0
or
vi /etc/selinux/config
SELINUX=disabled
restart
edited Jun 27 '17 at 8:44
Sumeet Deshmukh
4,31552971
answered Jun 27 '17 at 7:52
user704879
1
edited Jun 27 '17 at 8:44
Sumeet Deshmukh
4,31552971
edited Jun 27 '17 at 8:44
Sumeet Deshmukh
4,31552971
edited Jun 27 '17 at 8:44
Sumeet Deshmukh
4,31552971
4,31552971
answered Jun 27 '17 at 7:52
user704879
1
answered Jun 27 '17 at 7:52
user704879
1
answered Jun 27 '17 at 7:52
user704879
1
1
Ubuntu doesn't use SELinux. This is not a valid answer.
– Thomas Ward♦
Jan 27 at 16:35
add a comment |
Ubuntu doesn't use SELinux. This is not a valid answer.
– Thomas Ward♦
Jan 27 at 16:35
Ubuntu doesn't use SELinux. This is not a valid answer.
– Thomas Ward♦
Jan 27 at 16:35
Ubuntu doesn't use SELinux. This is not a valid answer.
– Thomas Ward♦
Jan 27 at 16:35
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f442428%2fmysql-not-starting-because-mysqld-cant-find-file-mysql-plugin-frm-errno%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Your question has been asked previously on DBA.SE and you may find useful its asnwer. Let us know if that is a working solution. Just to mention,
140402is not the error number but your system date.– Lucio
Apr 3 '14 at 1:51