How to solve “Access denied for user 'phpmyadmin'@'localhost' (using password: YES)"MySQL Access denied for...
How to not starve gigantic beasts
How do I deal with a coworker that keeps asking to make small superficial changes to a report, and it is seriously triggering my anxiety?
SFDX - Create Objects with Custom Properties
Should the Product Owner dictate what info the UI needs to display?
How can I practically buy stocks?
"Whatever a Russian does, they end up making the Kalashnikov gun"? Are there any similar proverbs in English?
Was Dennis Ritchie being too modest in this quote about C and Pascal?
Is Electric Central Heating worth it if using Solar Panels?
Unknown code in script
Apply a different color ramp to subset of categorized symbols in QGIS?
Can a level 2 Warlock take one level in rogue, then continue advancing as a warlock?
All ASCII characters with a given bit count
What is this word supposed to be?
Von Neumann Extractor - Which bit is retained?
How much of a wave function must reside inside event horizon for it to be consumed by the black hole?
Co-worker works way more than he should
Check if a string is entirely made of the same substring
Why did C use the -> operator instead of reusing the . operator?
How do I produce this Greek letter koppa: Ϟ in pdfLaTeX?
What is the most expensive material in the world that could be used to create Pun-Pun's lute?
Why did Rep. Omar conclude her criticism of US troops with the phrase "NotTodaySatan"?
Combinatorics problem, right solution?
Extracting Dirichlet series coefficients
How important is it that $TERM is correct?
How to solve “Access denied for user 'phpmyadmin'@'localhost' (using password: YES)"
MySQL Access denied for user 'root'@'localhost'Mysql Error SQLSTATE[HY000] [1045] Access denied for user. While installing Drupal 7 in localhost“ Access denied for user 'phpmyadmin'@'localhost' ” while installing phpmyadminaccess phpmyadmin on localhost & reconfigure phpmyadmin: ERROR 1045 (28000): Access denied for user 'root'@'localhost'ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) no working solutioni have mysql 8.0.2 installed on my ubuntu 16.04.can not open it through terminal. so what to do now?Error setting up mySQL databaseReinstall phpMyAdmin (Access denied for user 'root'@'localhost')how to fix this error: #1698 - Access denied for user 'root'@'localhost' on phpmyadminPhpMyAdmin, Access denied for user 'root'@'localhost'
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
La connexion au controluser tel que défini dans votre configuration a échoué.
mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
La connexion au controluser tel que défini dans votre configuration a échoué.
apache2 mysql phpmyadmin sql
asked 14 hours ago
islem GUESMIislem GUESMI
13
New contributor
islem GUESMI 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 |
La connexion au controluser tel que défini dans votre configuration a échoué.
mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
La connexion au controluser tel que défini dans votre configuration a échoué.
apache2 mysql phpmyadmin sql
asked 14 hours ago
islem GUESMIislem GUESMI
13
New contributor
islem GUESMI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please kindly translate those text and copy and paste them into your question...
– George Udosen
14 hours ago
add a comment |
La connexion au controluser tel que défini dans votre configuration a échoué.
mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
La connexion au controluser tel que défini dans votre configuration a échoué.
apache2 mysql phpmyadmin sql
asked 14 hours ago
islem GUESMIislem GUESMI
13
New contributor
islem GUESMI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
La connexion au controluser tel que défini dans votre configuration a échoué.
mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
La connexion au controluser tel que défini dans votre configuration a échoué.
apache2 mysql phpmyadmin sql
apache2 mysql phpmyadmin sql
asked 14 hours ago
islem GUESMIislem GUESMI
13
New contributor
islem GUESMI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 14 hours ago
islem GUESMIislem GUESMI
13
New contributor
islem GUESMI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 13 hours ago
islem GUESMI
asked 14 hours ago
islem GUESMIislem GUESMI
13
New contributor
islem GUESMI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 14 hours ago
islem GUESMIislem GUESMI
13
asked 14 hours ago
islem GUESMIislem GUESMI
13
13
New contributor
islem GUESMI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
islem GUESMI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
islem GUESMI is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Please kindly translate those text and copy and paste them into your question...
– George Udosen
14 hours ago
add a comment |
Please kindly translate those text and copy and paste them into your question...
– George Udosen
14 hours ago
Please kindly translate those text and copy and paste them into your question...
– George Udosen
14 hours ago
Please kindly translate those text and copy and paste them into your question...
– George Udosen
14 hours ago
add a comment |
2 Answers
2
active
oldest
votes
Login to phpmyadmin as root, go to user accounts tab, click edit priveleges on line where phpmyadmin, and grant all priveleges.
Or create another user with grant all priveleges
answered 14 hours ago
LeonidMewLeonidMew
1,320624
mysql> CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON . TO 'phpmyadmin'@'localhost' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) ES) mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
10 hours ago
add a comment |
With root privileges on the command line, use the mysql database create the user identified by your password, grant all select, update, delete privileges on all the databases on all the tables to the user phpmyadmin connecting from localhost, who also has grant options to give permissions to other users.
sudo mysql
use mysql;
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'supersecretpassword';
SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword');
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit
https://stackoverflow.com/a/16747309/2955337
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
answered 12 hours ago
sleepyheadsleepyhead
362
thx , but it does not work , againn i have the same error like : mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
11 hours ago
mysqli is a php module to create a database connection over the network. you use the phpmyadmin user to connect to the database to create that user, or it does exist, but you don't have the correct password. So that's why I would use a terminal so that you can connect to the database to fix that problem. I now see that the command 'sudo mysql' dropped from my answer.
– sleepyhead
11 hours ago
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'phppassword'; ERROR 1396 (HY000): Operation CREATE USER failed for 'phpmyadmin'@'localhost'
– islem GUESMI
11 hours ago
ERROR 1396 indicates that the user exists, to reset it's password run SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword'); ... next you can do the GRANT PERMISSIONS and may be FLUSH PRIVILEGES;
– sleepyhead
9 hours ago
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
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
});
}
});
islem GUESMI 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%2faskubuntu.com%2fquestions%2f1138031%2fhow-to-solve-access-denied-for-user-phpmyadminlocalhost-using-password-y%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
Login to phpmyadmin as root, go to user accounts tab, click edit priveleges on line where phpmyadmin, and grant all priveleges.
Or create another user with grant all priveleges
answered 14 hours ago
LeonidMewLeonidMew
1,320624
mysql> CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON . TO 'phpmyadmin'@'localhost' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) ES) mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
10 hours ago
add a comment |
Login to phpmyadmin as root, go to user accounts tab, click edit priveleges on line where phpmyadmin, and grant all priveleges.
Or create another user with grant all priveleges
answered 14 hours ago
LeonidMewLeonidMew
1,320624
mysql> CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON . TO 'phpmyadmin'@'localhost' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) ES) mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
10 hours ago
add a comment |
Login to phpmyadmin as root, go to user accounts tab, click edit priveleges on line where phpmyadmin, and grant all priveleges.
Or create another user with grant all priveleges
answered 14 hours ago
LeonidMewLeonidMew
1,320624
Login to phpmyadmin as root, go to user accounts tab, click edit priveleges on line where phpmyadmin, and grant all priveleges.
Or create another user with grant all priveleges
answered 14 hours ago
LeonidMewLeonidMew
1,320624
answered 14 hours ago
LeonidMewLeonidMew
1,320624
answered 14 hours ago
LeonidMewLeonidMew
1,320624
answered 14 hours ago
LeonidMewLeonidMew
1,320624
1,320624
mysql> CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON . TO 'phpmyadmin'@'localhost' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) ES) mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
10 hours ago
add a comment |
mysql> CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON . TO 'phpmyadmin'@'localhost' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) ES) mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
10 hours ago
mysql> CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON . TO 'phpmyadmin'@'localhost' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) ES) mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
10 hours ago
mysql> CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON . TO 'phpmyadmin'@'localhost' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) ES) mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
10 hours ago
add a comment |
With root privileges on the command line, use the mysql database create the user identified by your password, grant all select, update, delete privileges on all the databases on all the tables to the user phpmyadmin connecting from localhost, who also has grant options to give permissions to other users.
sudo mysql
use mysql;
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'supersecretpassword';
SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword');
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit
https://stackoverflow.com/a/16747309/2955337
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
answered 12 hours ago
sleepyheadsleepyhead
362
thx , but it does not work , againn i have the same error like : mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
11 hours ago
mysqli is a php module to create a database connection over the network. you use the phpmyadmin user to connect to the database to create that user, or it does exist, but you don't have the correct password. So that's why I would use a terminal so that you can connect to the database to fix that problem. I now see that the command 'sudo mysql' dropped from my answer.
– sleepyhead
11 hours ago
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'phppassword'; ERROR 1396 (HY000): Operation CREATE USER failed for 'phpmyadmin'@'localhost'
– islem GUESMI
11 hours ago
ERROR 1396 indicates that the user exists, to reset it's password run SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword'); ... next you can do the GRANT PERMISSIONS and may be FLUSH PRIVILEGES;
– sleepyhead
9 hours ago
add a comment |
With root privileges on the command line, use the mysql database create the user identified by your password, grant all select, update, delete privileges on all the databases on all the tables to the user phpmyadmin connecting from localhost, who also has grant options to give permissions to other users.
sudo mysql
use mysql;
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'supersecretpassword';
SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword');
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit
https://stackoverflow.com/a/16747309/2955337
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
answered 12 hours ago
sleepyheadsleepyhead
362
thx , but it does not work , againn i have the same error like : mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
11 hours ago
mysqli is a php module to create a database connection over the network. you use the phpmyadmin user to connect to the database to create that user, or it does exist, but you don't have the correct password. So that's why I would use a terminal so that you can connect to the database to fix that problem. I now see that the command 'sudo mysql' dropped from my answer.
– sleepyhead
11 hours ago
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'phppassword'; ERROR 1396 (HY000): Operation CREATE USER failed for 'phpmyadmin'@'localhost'
– islem GUESMI
11 hours ago
ERROR 1396 indicates that the user exists, to reset it's password run SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword'); ... next you can do the GRANT PERMISSIONS and may be FLUSH PRIVILEGES;
– sleepyhead
9 hours ago
add a comment |
With root privileges on the command line, use the mysql database create the user identified by your password, grant all select, update, delete privileges on all the databases on all the tables to the user phpmyadmin connecting from localhost, who also has grant options to give permissions to other users.
sudo mysql
use mysql;
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'supersecretpassword';
SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword');
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit
https://stackoverflow.com/a/16747309/2955337
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
answered 12 hours ago
sleepyheadsleepyhead
362
With root privileges on the command line, use the mysql database create the user identified by your password, grant all select, update, delete privileges on all the databases on all the tables to the user phpmyadmin connecting from localhost, who also has grant options to give permissions to other users.
sudo mysql
use mysql;
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'supersecretpassword';
SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword');
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit
https://stackoverflow.com/a/16747309/2955337
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
answered 12 hours ago
sleepyheadsleepyhead
362
edited 9 hours ago
answered 12 hours ago
sleepyheadsleepyhead
362
answered 12 hours ago
sleepyheadsleepyhead
362
answered 12 hours ago
sleepyheadsleepyhead
362
362
thx , but it does not work , againn i have the same error like : mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
11 hours ago
mysqli is a php module to create a database connection over the network. you use the phpmyadmin user to connect to the database to create that user, or it does exist, but you don't have the correct password. So that's why I would use a terminal so that you can connect to the database to fix that problem. I now see that the command 'sudo mysql' dropped from my answer.
– sleepyhead
11 hours ago
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'phppassword'; ERROR 1396 (HY000): Operation CREATE USER failed for 'phpmyadmin'@'localhost'
– islem GUESMI
11 hours ago
ERROR 1396 indicates that the user exists, to reset it's password run SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword'); ... next you can do the GRANT PERMISSIONS and may be FLUSH PRIVILEGES;
– sleepyhead
9 hours ago
add a comment |
thx , but it does not work , againn i have the same error like : mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
11 hours ago
mysqli is a php module to create a database connection over the network. you use the phpmyadmin user to connect to the database to create that user, or it does exist, but you don't have the correct password. So that's why I would use a terminal so that you can connect to the database to fix that problem. I now see that the command 'sudo mysql' dropped from my answer.
– sleepyhead
11 hours ago
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'phppassword'; ERROR 1396 (HY000): Operation CREATE USER failed for 'phpmyadmin'@'localhost'
– islem GUESMI
11 hours ago
ERROR 1396 indicates that the user exists, to reset it's password run SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword'); ... next you can do the GRANT PERMISSIONS and may be FLUSH PRIVILEGES;
– sleepyhead
9 hours ago
thx , but it does not work , againn i have the same error like : mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
11 hours ago
thx , but it does not work , againn i have the same error like : mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.
– islem GUESMI
11 hours ago
mysqli is a php module to create a database connection over the network. you use the phpmyadmin user to connect to the database to create that user, or it does exist, but you don't have the correct password. So that's why I would use a terminal so that you can connect to the database to fix that problem. I now see that the command 'sudo mysql' dropped from my answer.
– sleepyhead
11 hours ago
mysqli is a php module to create a database connection over the network. you use the phpmyadmin user to connect to the database to create that user, or it does exist, but you don't have the correct password. So that's why I would use a terminal so that you can connect to the database to fix that problem. I now see that the command 'sudo mysql' dropped from my answer.
– sleepyhead
11 hours ago
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'phppassword'; ERROR 1396 (HY000): Operation CREATE USER failed for 'phpmyadmin'@'localhost'
– islem GUESMI
11 hours ago
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'phppassword'; ERROR 1396 (HY000): Operation CREATE USER failed for 'phpmyadmin'@'localhost'
– islem GUESMI
11 hours ago
ERROR 1396 indicates that the user exists, to reset it's password run SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword'); ... next you can do the GRANT PERMISSIONS and may be FLUSH PRIVILEGES;
– sleepyhead
9 hours ago
ERROR 1396 indicates that the user exists, to reset it's password run SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword'); ... next you can do the GRANT PERMISSIONS and may be FLUSH PRIVILEGES;
– sleepyhead
9 hours ago
add a comment |
islem GUESMI is a new contributor. Be nice, and check out our Code of Conduct.
islem GUESMI is a new contributor. Be nice, and check out our Code of Conduct.
islem GUESMI is a new contributor. Be nice, and check out our Code of Conduct.
islem GUESMI is a new contributor. Be nice, and check out our Code of Conduct.
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.
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%2f1138031%2fhow-to-solve-access-denied-for-user-phpmyadminlocalhost-using-password-y%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
Please kindly translate those text and copy and paste them into your question...
– George Udosen
14 hours ago