Plesk using outdated password for MYSQL5.7
I'm unable to login to my Plesk control panel, or even pull up the page.
Plesk's repair utilities fail to work, so web/GUI methods seem to be entirely unavailable.
The only way I can login is via command:
mysql -u admin -p [entering correct password]
But Plesk itself cannot connect to MYSQL 5.7, because it's using whatever the old password was.
How do I update the password that Plesk uses to connect to MySQL?
windows mysql plesk mysql5
edited 2 days ago
Pimp Juice IT
23.5k113970
asked 2 days ago
user10902472user10902472
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I'm unable to login to my Plesk control panel, or even pull up the page.
Plesk's repair utilities fail to work, so web/GUI methods seem to be entirely unavailable.
The only way I can login is via command:
mysql -u admin -p [entering correct password]
But Plesk itself cannot connect to MYSQL 5.7, because it's using whatever the old password was.
How do I update the password that Plesk uses to connect to MySQL?
windows mysql plesk mysql5
edited 2 days ago
Pimp Juice IT
23.5k113970
asked 2 days ago
user10902472user10902472
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I'm unable to login to my Plesk control panel, or even pull up the page.
Plesk's repair utilities fail to work, so web/GUI methods seem to be entirely unavailable.
The only way I can login is via command:
mysql -u admin -p [entering correct password]
But Plesk itself cannot connect to MYSQL 5.7, because it's using whatever the old password was.
How do I update the password that Plesk uses to connect to MySQL?
windows mysql plesk mysql5
edited 2 days ago
Pimp Juice IT
23.5k113970
asked 2 days ago
user10902472user10902472
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I'm unable to login to my Plesk control panel, or even pull up the page.
Plesk's repair utilities fail to work, so web/GUI methods seem to be entirely unavailable.
The only way I can login is via command:
mysql -u admin -p [entering correct password]
But Plesk itself cannot connect to MYSQL 5.7, because it's using whatever the old password was.
How do I update the password that Plesk uses to connect to MySQL?
windows mysql plesk mysql5
windows mysql plesk mysql5
edited 2 days ago
Pimp Juice IT
23.5k113970
asked 2 days ago
user10902472user10902472
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
Pimp Juice IT
23.5k113970
asked 2 days ago
user10902472user10902472
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 2 days ago
Pimp Juice IT
23.5k113970
edited 2 days ago
Pimp Juice IT
23.5k113970
edited 2 days ago
Pimp Juice IT
23.5k113970
23.5k113970
asked 2 days ago
user10902472user10902472
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 days ago
user10902472user10902472
585
asked 2 days ago
user10902472user10902472
585
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Pointers for updating the Plesk MySQL password
According to the "The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication" post, you can go to
Plesk>Domains>example.com>Databases>User Management>database_nameand in the the new window submit the new password.Additionally, according to the "Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)" post, you can run
plesk sbin psadb -u --password="password"with the new password from command line.
Additional Resources & References
- Updating MySQL Pre-4.1 Password Hashes to be MySQL 5.6 Compatible
- The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication
- Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)
answered 2 days ago
Pimp Juice ITPimp Juice IT
23.5k113970
I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.
– user10902472
2 days ago
@user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.
– Pimp Juice IT
2 days ago
add a comment |
Following the instructions on a link shared by Pimp Juice's answer, Typing plesk db gave me the error: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
The solution was to combine the two, as I can't find a documented way that plesk db allows username and password options
- Run mysql:
mysql -u admin -p MyMySQLAdminPassword, which is whatplesk dbwas trying to do with the credentials it knows. - Paste the command
UPDATE mysql.user SET authentication_string=PASSWORD("MyMySQLAdminPassword") WHERE user='admin';
quitMYSQL- Run the command:
plesk sbin psadb -u --password="MyMySQLAdminPassword", quotes included.
answered 2 days ago
user10902472user10902472
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
});
}
});
user10902472 is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1393326%2fplesk-using-outdated-password-for-mysql5-7%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Pointers for updating the Plesk MySQL password
According to the "The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication" post, you can go to
Plesk>Domains>example.com>Databases>User Management>database_nameand in the the new window submit the new password.Additionally, according to the "Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)" post, you can run
plesk sbin psadb -u --password="password"with the new password from command line.
Additional Resources & References
- Updating MySQL Pre-4.1 Password Hashes to be MySQL 5.6 Compatible
- The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication
- Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)
answered 2 days ago
Pimp Juice ITPimp Juice IT
23.5k113970
I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.
– user10902472
2 days ago
@user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.
– Pimp Juice IT
2 days ago
add a comment |
Pointers for updating the Plesk MySQL password
According to the "The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication" post, you can go to
Plesk>Domains>example.com>Databases>User Management>database_nameand in the the new window submit the new password.Additionally, according to the "Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)" post, you can run
plesk sbin psadb -u --password="password"with the new password from command line.
Additional Resources & References
- Updating MySQL Pre-4.1 Password Hashes to be MySQL 5.6 Compatible
- The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication
- Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)
answered 2 days ago
Pimp Juice ITPimp Juice IT
23.5k113970
I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.
– user10902472
2 days ago
@user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.
– Pimp Juice IT
2 days ago
add a comment |
Pointers for updating the Plesk MySQL password
According to the "The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication" post, you can go to
Plesk>Domains>example.com>Databases>User Management>database_nameand in the the new window submit the new password.Additionally, according to the "Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)" post, you can run
plesk sbin psadb -u --password="password"with the new password from command line.
Additional Resources & References
- Updating MySQL Pre-4.1 Password Hashes to be MySQL 5.6 Compatible
- The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication
- Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)
answered 2 days ago
Pimp Juice ITPimp Juice IT
23.5k113970
Pointers for updating the Plesk MySQL password
According to the "The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication" post, you can go to
Plesk>Domains>example.com>Databases>User Management>database_nameand in the the new window submit the new password.Additionally, according to the "Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)" post, you can run
plesk sbin psadb -u --password="password"with the new password from command line.
Additional Resources & References
- Updating MySQL Pre-4.1 Password Hashes to be MySQL 5.6 Compatible
- The Plesk shows the error: Cannot connect to MySQL 4.1+ using the old insecure authentication
- Plesk is not accessible: Access denied for user 'username' @'localhost' (using password YES)
answered 2 days ago
Pimp Juice ITPimp Juice IT
23.5k113970
edited 2 days ago
answered 2 days ago
Pimp Juice ITPimp Juice IT
23.5k113970
answered 2 days ago
Pimp Juice ITPimp Juice IT
23.5k113970
answered 2 days ago
Pimp Juice ITPimp Juice IT
23.5k113970
23.5k113970
I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.
– user10902472
2 days ago
@user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.
– Pimp Juice IT
2 days ago
add a comment |
I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.
– user10902472
2 days ago
@user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.
– Pimp Juice IT
2 days ago
I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.
– user10902472
2 days ago
I have some feedback in my own answer, but thanks for giving me the route to the right track. Your first option though was unavailable to me because I couldn't access the plesk website to begin with.
– user10902472
2 days ago
@user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.
– Pimp Juice IT
2 days ago
@user10902472 I'm glad I could help and that you were able to get it resolved. Thanks for sharing the updated and explicit detail from your answer too. This may save others a headache or two in the future which we helped contribute to.
– Pimp Juice IT
2 days ago
add a comment |
Following the instructions on a link shared by Pimp Juice's answer, Typing plesk db gave me the error: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
The solution was to combine the two, as I can't find a documented way that plesk db allows username and password options
- Run mysql:
mysql -u admin -p MyMySQLAdminPassword, which is whatplesk dbwas trying to do with the credentials it knows. - Paste the command
UPDATE mysql.user SET authentication_string=PASSWORD("MyMySQLAdminPassword") WHERE user='admin';
quitMYSQL- Run the command:
plesk sbin psadb -u --password="MyMySQLAdminPassword", quotes included.
answered 2 days ago
user10902472user10902472
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Following the instructions on a link shared by Pimp Juice's answer, Typing plesk db gave me the error: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
The solution was to combine the two, as I can't find a documented way that plesk db allows username and password options
- Run mysql:
mysql -u admin -p MyMySQLAdminPassword, which is whatplesk dbwas trying to do with the credentials it knows. - Paste the command
UPDATE mysql.user SET authentication_string=PASSWORD("MyMySQLAdminPassword") WHERE user='admin';
quitMYSQL- Run the command:
plesk sbin psadb -u --password="MyMySQLAdminPassword", quotes included.
answered 2 days ago
user10902472user10902472
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Following the instructions on a link shared by Pimp Juice's answer, Typing plesk db gave me the error: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
The solution was to combine the two, as I can't find a documented way that plesk db allows username and password options
- Run mysql:
mysql -u admin -p MyMySQLAdminPassword, which is whatplesk dbwas trying to do with the credentials it knows. - Paste the command
UPDATE mysql.user SET authentication_string=PASSWORD("MyMySQLAdminPassword") WHERE user='admin';
quitMYSQL- Run the command:
plesk sbin psadb -u --password="MyMySQLAdminPassword", quotes included.
answered 2 days ago
user10902472user10902472
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Following the instructions on a link shared by Pimp Juice's answer, Typing plesk db gave me the error: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
The solution was to combine the two, as I can't find a documented way that plesk db allows username and password options
- Run mysql:
mysql -u admin -p MyMySQLAdminPassword, which is whatplesk dbwas trying to do with the credentials it knows. - Paste the command
UPDATE mysql.user SET authentication_string=PASSWORD("MyMySQLAdminPassword") WHERE user='admin';
quitMYSQL- Run the command:
plesk sbin psadb -u --password="MyMySQLAdminPassword", quotes included.
answered 2 days ago
user10902472user10902472
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 2 days ago
user10902472user10902472
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 2 days ago
user10902472user10902472
585
answered 2 days ago
user10902472user10902472
585
585
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
user10902472 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
user10902472 is a new contributor. Be nice, and check out our Code of Conduct.
user10902472 is a new contributor. Be nice, and check out our Code of Conduct.
user10902472 is a new contributor. Be nice, and check out our Code of Conduct.
user10902472 is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1393326%2fplesk-using-outdated-password-for-mysql5-7%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
