mysqld not starting up
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I installed mysql on ubuntu. mysqld does not startup with the following errors -
2017-04-16T00:22:35.320639Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-04-16T00:22:35.321014Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170415 19:22:35
2017-04-16T00:22:35.321036Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2017-04-16T00:22:35.321354Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-04-16T00:22:35.322301Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-04-16T00:22:35.322490Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-04-16T00:22:35.323247Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-04-16T00:22:35.323361Z 0 [Note] IPv6 is available.
2017-04-16T00:22:35.323379Z 0 [Note] - '::' resolves to '::';
2017-04-16T00:22:35.323411Z 0 [Note] Server socket created on IP: '::'.
2017-04-16T00:22:35.323450Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.
2017-04-16T00:22:35.323464Z 0 [ERROR] Unable to setup unix socket lock file.
2017-04-16T00:22:35.323476Z 0 [ERROR] Aborting
2017-04-16T00:22:35.323497Z 0 [Note] Binlog end
2017-04-16T00:22:35.323545Z 0 [Note] Shutting down plugin 'ngram'
Please help.
Thanks
mysql installation mysqld
asked Apr 16 '17 at 0:35
user122918user122918
211
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I installed mysql on ubuntu. mysqld does not startup with the following errors -
2017-04-16T00:22:35.320639Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-04-16T00:22:35.321014Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170415 19:22:35
2017-04-16T00:22:35.321036Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2017-04-16T00:22:35.321354Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-04-16T00:22:35.322301Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-04-16T00:22:35.322490Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-04-16T00:22:35.323247Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-04-16T00:22:35.323361Z 0 [Note] IPv6 is available.
2017-04-16T00:22:35.323379Z 0 [Note] - '::' resolves to '::';
2017-04-16T00:22:35.323411Z 0 [Note] Server socket created on IP: '::'.
2017-04-16T00:22:35.323450Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.
2017-04-16T00:22:35.323464Z 0 [ERROR] Unable to setup unix socket lock file.
2017-04-16T00:22:35.323476Z 0 [ERROR] Aborting
2017-04-16T00:22:35.323497Z 0 [Note] Binlog end
2017-04-16T00:22:35.323545Z 0 [Note] Shutting down plugin 'ngram'
Please help.
Thanks
mysql installation mysqld
asked Apr 16 '17 at 0:35
user122918user122918
211
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
Did you upgrade recently? If so, did you runmysql_upgrade?
– Rick James
Apr 16 '17 at 4:24
What does yourmy.cnffile look like?
– hot2use
May 3 '18 at 9:22
add a comment |
I installed mysql on ubuntu. mysqld does not startup with the following errors -
2017-04-16T00:22:35.320639Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-04-16T00:22:35.321014Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170415 19:22:35
2017-04-16T00:22:35.321036Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2017-04-16T00:22:35.321354Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-04-16T00:22:35.322301Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-04-16T00:22:35.322490Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-04-16T00:22:35.323247Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-04-16T00:22:35.323361Z 0 [Note] IPv6 is available.
2017-04-16T00:22:35.323379Z 0 [Note] - '::' resolves to '::';
2017-04-16T00:22:35.323411Z 0 [Note] Server socket created on IP: '::'.
2017-04-16T00:22:35.323450Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.
2017-04-16T00:22:35.323464Z 0 [ERROR] Unable to setup unix socket lock file.
2017-04-16T00:22:35.323476Z 0 [ERROR] Aborting
2017-04-16T00:22:35.323497Z 0 [Note] Binlog end
2017-04-16T00:22:35.323545Z 0 [Note] Shutting down plugin 'ngram'
Please help.
Thanks
mysql installation mysqld
asked Apr 16 '17 at 0:35
user122918user122918
211
I installed mysql on ubuntu. mysqld does not startup with the following errors -
2017-04-16T00:22:35.320639Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-04-16T00:22:35.321014Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170415 19:22:35
2017-04-16T00:22:35.321036Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2017-04-16T00:22:35.321354Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2017-04-16T00:22:35.322301Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-04-16T00:22:35.322490Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-04-16T00:22:35.323247Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-04-16T00:22:35.323361Z 0 [Note] IPv6 is available.
2017-04-16T00:22:35.323379Z 0 [Note] - '::' resolves to '::';
2017-04-16T00:22:35.323411Z 0 [Note] Server socket created on IP: '::'.
2017-04-16T00:22:35.323450Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.
2017-04-16T00:22:35.323464Z 0 [ERROR] Unable to setup unix socket lock file.
2017-04-16T00:22:35.323476Z 0 [ERROR] Aborting
2017-04-16T00:22:35.323497Z 0 [Note] Binlog end
2017-04-16T00:22:35.323545Z 0 [Note] Shutting down plugin 'ngram'
Please help.
Thanks
mysql installation mysqld
mysql installation mysqld
asked Apr 16 '17 at 0:35
user122918user122918
211
asked Apr 16 '17 at 0:35
user122918user122918
211
asked Apr 16 '17 at 0:35
user122918user122918
211
asked Apr 16 '17 at 0:35
user122918user122918
211
asked Apr 16 '17 at 0:35
user122918user122918
211
211
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 12 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
Did you upgrade recently? If so, did you runmysql_upgrade?
– Rick James
Apr 16 '17 at 4:24
What does yourmy.cnffile look like?
– hot2use
May 3 '18 at 9:22
add a comment |
1
Did you upgrade recently? If so, did you runmysql_upgrade?
– Rick James
Apr 16 '17 at 4:24
What does yourmy.cnffile look like?
– hot2use
May 3 '18 at 9:22
1
1
Did you upgrade recently? If so, did you run
mysql_upgrade?– Rick James
Apr 16 '17 at 4:24
Did you upgrade recently? If so, did you run
mysql_upgrade?– Rick James
Apr 16 '17 at 4:24
What does your
my.cnf file look like?– hot2use
May 3 '18 at 9:22
What does your
my.cnf file look like?– hot2use
May 3 '18 at 9:22
add a comment |
1 Answer
1
active
oldest
votes
It does not solve the problem as such but you should be able to bypass it by adding the skip-external-locking to my.cnf under [mysqld]
Should at least get the server starting while you find out the root of the problem.
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
answered Apr 16 '17 at 1:04
Tony HTony H
485
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2fdba.stackexchange.com%2fquestions%2f171103%2fmysqld-not-starting-up%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It does not solve the problem as such but you should be able to bypass it by adding the skip-external-locking to my.cnf under [mysqld]
Should at least get the server starting while you find out the root of the problem.
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
answered Apr 16 '17 at 1:04
Tony HTony H
485
add a comment |
It does not solve the problem as such but you should be able to bypass it by adding the skip-external-locking to my.cnf under [mysqld]
Should at least get the server starting while you find out the root of the problem.
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
answered Apr 16 '17 at 1:04
Tony HTony H
485
add a comment |
It does not solve the problem as such but you should be able to bypass it by adding the skip-external-locking to my.cnf under [mysqld]
Should at least get the server starting while you find out the root of the problem.
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
answered Apr 16 '17 at 1:04
Tony HTony H
485
It does not solve the problem as such but you should be able to bypass it by adding the skip-external-locking to my.cnf under [mysqld]
Should at least get the server starting while you find out the root of the problem.
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
answered Apr 16 '17 at 1:04
Tony HTony H
485
answered Apr 16 '17 at 1:04
Tony HTony H
485
answered Apr 16 '17 at 1:04
Tony HTony H
485
answered Apr 16 '17 at 1:04
Tony HTony H
485
485
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f171103%2fmysqld-not-starting-up%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
1
Did you upgrade recently? If so, did you run
mysql_upgrade?– Rick James
Apr 16 '17 at 4:24
What does your
my.cnffile look like?– hot2use
May 3 '18 at 9:22