Bsrgvty

What antenna is this in an Apollo 15 LM photo?

Translate the French quote "Il n’y a pas d'amour, il n’y a que des preuves d’amour" to English?

Counting without zeroes

Transferring $ from LLC to Personal account

Balancing empathy and deferring to the syllabus in teaching responsibilities

Seen from Europe, why is there a hard separation between Republicans and Democrats in the US?

Perfect pitch on only one instrument?

What are these color strips for?

What is the contemporary meaning of primary storage?

Is there a difference between “When you are reduced to 0 hit points” and “when you would be reduced to 0 hit points”?

Is a geodesic in the 4d spacetime still a geodesic after projection onto the 3d space?

What is the difference between chemical equilibrium and dynamic equilibrium?

Physical interpretation of gamma matrices

Conditional proof demonstration

How could hearsay be better evidence than direct?

This Riley Riddle is a Mess

Hough transform algorithm - Idiomatic c++

Strange labels on our servers

CEO says not to expect pay increases unless you do something really exceptional. Is this counter-productive?

In a world where Magic steam Engines exist would would keep people from making cars

How did Gdoley Israel react to the landing on the Moon?

Two people from small group of friends want to have a "meeting" with me. The circumstances are strange and give me a bad feeling

Mistakenly agreed with a scammer’s term of use

Why does this process map every fraction to the golden ratio?

#1045 - Unknown error 1045 in mysql login

#1045 Cannot log in to the MySQL serverXAMPP MySQL and phpMyAdmin error Ubuntu 14.04Ubuntu 14 installing phpmyadmin newbie questionInstall error for Mysql-ServerResetting MySQL root password

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;

0

In terminal I executed the following:

# mysql -u root -p
Enter password: 

And got the result:

ERROR 1045 (28000): Unknown error 1045

How do I fix this?

phpmyadmin

share|improve this question

edited Jun 21 '17 at 18:18

QwertyChouskie

1,7841010 silver badges2424 bronze badges

asked Mar 23 '17 at 7:32

Recharde WilliamRecharde William

7511 gold badge22 silver badges77 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are you sure that the password is right? dev.mysql.com/doc/refman/5.5/en/… indicates that 1045 means you access have been denied. You could reset the password like described here: dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
  
  – David Georg Reichelt
  Mar 23 '17 at 9:28
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @DavidGeorgReichelt yes my password is ok, you give a link that is after login in mysql, but i cant login when i enter my password i got this error, same error i got in browser in login page when i give username/password.
  
  – Recharde William
  Mar 23 '17 at 11:07
  

  
  
  
  

add a comment
 | 

0

In terminal I executed the following:

# mysql -u root -p
Enter password: 

And got the result:

ERROR 1045 (28000): Unknown error 1045

How do I fix this?

phpmyadmin

share|improve this question

edited Jun 21 '17 at 18:18

QwertyChouskie

1,7841010 silver badges2424 bronze badges

asked Mar 23 '17 at 7:32

Recharde WilliamRecharde William

7511 gold badge22 silver badges77 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Are you sure that the password is right? dev.mysql.com/doc/refman/5.5/en/… indicates that 1045 means you access have been denied. You could reset the password like described here: dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
  
  – David Georg Reichelt
  Mar 23 '17 at 9:28
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @DavidGeorgReichelt yes my password is ok, you give a link that is after login in mysql, but i cant login when i enter my password i got this error, same error i got in browser in login page when i give username/password.
  
  – Recharde William
  Mar 23 '17 at 11:07
  

  
  
  
  

add a comment
 | 

In terminal I executed the following:

# mysql -u root -p
Enter password: 

And got the result:

ERROR 1045 (28000): Unknown error 1045

How do I fix this?

phpmyadmin

share|improve this question

edited Jun 21 '17 at 18:18

QwertyChouskie

1,7841010 silver badges2424 bronze badges

asked Mar 23 '17 at 7:32

Recharde WilliamRecharde William

7511 gold badge22 silver badges77 bronze badges

# mysql -u root -p
Enter password: 

ERROR 1045 (28000): Unknown error 1045

share|improve this question

edited Jun 21 '17 at 18:18

QwertyChouskie

1,7841010 silver badges2424 bronze badges

asked Mar 23 '17 at 7:32

Recharde WilliamRecharde William

7511 gold badge22 silver badges77 bronze badges

share|improve this question

edited Jun 21 '17 at 18:18

QwertyChouskie

1,7841010 silver badges2424 bronze badges

asked Mar 23 '17 at 7:32

Recharde WilliamRecharde William

7511 gold badge22 silver badges77 bronze badges

edited Jun 21 '17 at 18:18

QwertyChouskie

1,7841010 silver badges2424 bronze badges

edited Jun 21 '17 at 18:18

QwertyChouskie

1,7841010 silver badges2424 bronze badges

asked Mar 23 '17 at 7:32

Recharde WilliamRecharde William

7511 gold badge22 silver badges77 bronze badges

asked Mar 23 '17 at 7:32

Recharde WilliamRecharde William

7511 gold badge22 silver badges77 bronze badges

2 Answers
2

active

oldest

votes

1

Am using Ubuntu-16.04 with installed mysql - 5.7. I Had the same issue.

I tried the below steps:

1. dpkg --get-selections | grep mysql (to get the version of mysql).




2. dpkg-reconfigure mysql-server-5.7




3. mysql -u root -p

Without -p that doesn't prompt you to ask password. Once you are in, you can create a user with a password by following steps :

CREATE USER '-your_name-'@'your-hostname' IDENTIFIED BY 'your-password';

GRANT ALL PRIVILEGES ON . to '-your_name-'@'your-hostname' WITH GRANT OPTION;

Exit from the root and login from the you gave above.

mysql -u -p

For some reason still just typing mysql does not work. AT ALL. Please let me know if this works, else I have other steps.

share|improve this answer

edited Jun 21 '17 at 18:03

Danibix

1,58711 gold badge1313 silver badges2525 bronze badges

answered Jun 21 '17 at 15:34

Nikhil RushmithNikhil Rushmith

1111 bronze badge

add a comment
 | 

0

I share here my experience, hoping it might be useful.

I solved the problem on my environement (Ubuntu 18.04.3, mysql 14.14, Distribution 5.7.27 ) as such:

sudo mysql -u root -p
Enter password:

Then I created a user as suggested by @Nikhil Rushmith:

CREATE USER 'new_username'@'hostname' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON . to 'new_username'@'hostname' WITH GRANT OPTION;

Finally I created a database mydb and granted all rights to it to the new user new_username:

GRANT ALL PRIVILEGES ON mydb.* TO 'new_username'@'hostname';

After that, I quit mysql and connected with the new user, and could acess to the new database.

share|improve this answer

edited Sep 12 at 19:10

answered Sep 12 at 6:11

Catalina ChircuCatalina Chircu

10111 silver badge33 bronze badges

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/4.0/"u003ecc by-sa 4.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
);



);

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f895954%2f1045-unknown-error-1045-in-mysql-login%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

Am using Ubuntu-16.04 with installed mysql - 5.7. I Had the same issue.

I tried the below steps:

1. dpkg --get-selections | grep mysql (to get the version of mysql).




2. dpkg-reconfigure mysql-server-5.7




3. mysql -u root -p

Without -p that doesn't prompt you to ask password. Once you are in, you can create a user with a password by following steps :

CREATE USER '-your_name-'@'your-hostname' IDENTIFIED BY 'your-password';

GRANT ALL PRIVILEGES ON . to '-your_name-'@'your-hostname' WITH GRANT OPTION;

Exit from the root and login from the you gave above.

mysql -u -p

For some reason still just typing mysql does not work. AT ALL. Please let me know if this works, else I have other steps.

share|improve this answer

edited Jun 21 '17 at 18:03

Danibix

1,58711 gold badge1313 silver badges2525 bronze badges

answered Jun 21 '17 at 15:34

Nikhil RushmithNikhil Rushmith

1111 bronze badge

add a comment
 | 

1

Am using Ubuntu-16.04 with installed mysql - 5.7. I Had the same issue.

I tried the below steps:

1. dpkg --get-selections | grep mysql (to get the version of mysql).




2. dpkg-reconfigure mysql-server-5.7




3. mysql -u root -p

Without -p that doesn't prompt you to ask password. Once you are in, you can create a user with a password by following steps :

CREATE USER '-your_name-'@'your-hostname' IDENTIFIED BY 'your-password';

GRANT ALL PRIVILEGES ON . to '-your_name-'@'your-hostname' WITH GRANT OPTION;

Exit from the root and login from the you gave above.

mysql -u -p

For some reason still just typing mysql does not work. AT ALL. Please let me know if this works, else I have other steps.

share|improve this answer

edited Jun 21 '17 at 18:03

Danibix

1,58711 gold badge1313 silver badges2525 bronze badges

answered Jun 21 '17 at 15:34

Nikhil RushmithNikhil Rushmith

1111 bronze badge

add a comment
 | 

Am using Ubuntu-16.04 with installed mysql - 5.7. I Had the same issue.

I tried the below steps:

1. dpkg --get-selections | grep mysql (to get the version of mysql).




2. dpkg-reconfigure mysql-server-5.7




3. mysql -u root -p

Without -p that doesn't prompt you to ask password. Once you are in, you can create a user with a password by following steps :

CREATE USER '-your_name-'@'your-hostname' IDENTIFIED BY 'your-password';

GRANT ALL PRIVILEGES ON . to '-your_name-'@'your-hostname' WITH GRANT OPTION;

Exit from the root and login from the you gave above.

mysql -u -p

For some reason still just typing mysql does not work. AT ALL. Please let me know if this works, else I have other steps.

share|improve this answer

edited Jun 21 '17 at 18:03

Danibix

1,58711 gold badge1313 silver badges2525 bronze badges

answered Jun 21 '17 at 15:34

Nikhil RushmithNikhil Rushmith

1111 bronze badge

CREATE USER '-your_name-'@'your-hostname' IDENTIFIED BY 'your-password';

GRANT ALL PRIVILEGES ON . to '-your_name-'@'your-hostname' WITH GRANT OPTION;

mysql -u -p

share|improve this answer

edited Jun 21 '17 at 18:03

Danibix

1,58711 gold badge1313 silver badges2525 bronze badges

answered Jun 21 '17 at 15:34

Nikhil RushmithNikhil Rushmith

1111 bronze badge

edited Jun 21 '17 at 18:03

Danibix

1,58711 gold badge1313 silver badges2525 bronze badges

edited Jun 21 '17 at 18:03

Danibix

1,58711 gold badge1313 silver badges2525 bronze badges

answered Jun 21 '17 at 15:34

Nikhil RushmithNikhil Rushmith

1111 bronze badge

answered Jun 21 '17 at 15:34

Nikhil RushmithNikhil Rushmith

1111 bronze badge

0

I share here my experience, hoping it might be useful.

I solved the problem on my environement (Ubuntu 18.04.3, mysql 14.14, Distribution 5.7.27 ) as such:

sudo mysql -u root -p
Enter password:

Then I created a user as suggested by @Nikhil Rushmith:

CREATE USER 'new_username'@'hostname' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON . to 'new_username'@'hostname' WITH GRANT OPTION;

Finally I created a database mydb and granted all rights to it to the new user new_username:

GRANT ALL PRIVILEGES ON mydb.* TO 'new_username'@'hostname';

After that, I quit mysql and connected with the new user, and could acess to the new database.

share|improve this answer

edited Sep 12 at 19:10

answered Sep 12 at 6:11

Catalina ChircuCatalina Chircu

10111 silver badge33 bronze badges

add a comment
 | 

0

I share here my experience, hoping it might be useful.

I solved the problem on my environement (Ubuntu 18.04.3, mysql 14.14, Distribution 5.7.27 ) as such:

sudo mysql -u root -p
Enter password:

Then I created a user as suggested by @Nikhil Rushmith:

CREATE USER 'new_username'@'hostname' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON . to 'new_username'@'hostname' WITH GRANT OPTION;

Finally I created a database mydb and granted all rights to it to the new user new_username:

GRANT ALL PRIVILEGES ON mydb.* TO 'new_username'@'hostname';

After that, I quit mysql and connected with the new user, and could acess to the new database.

share|improve this answer

edited Sep 12 at 19:10

answered Sep 12 at 6:11

Catalina ChircuCatalina Chircu

10111 silver badge33 bronze badges

add a comment
 | 

I share here my experience, hoping it might be useful.

I solved the problem on my environement (Ubuntu 18.04.3, mysql 14.14, Distribution 5.7.27 ) as such:

sudo mysql -u root -p
Enter password:

Then I created a user as suggested by @Nikhil Rushmith:

CREATE USER 'new_username'@'hostname' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON . to 'new_username'@'hostname' WITH GRANT OPTION;

Finally I created a database mydb and granted all rights to it to the new user new_username:

GRANT ALL PRIVILEGES ON mydb.* TO 'new_username'@'hostname';

After that, I quit mysql and connected with the new user, and could acess to the new database.

share|improve this answer

edited Sep 12 at 19:10

answered Sep 12 at 6:11

Catalina ChircuCatalina Chircu

10111 silver badge33 bronze badges

sudo mysql -u root -p
Enter password:

CREATE USER 'new_username'@'hostname' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON . to 'new_username'@'hostname' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON mydb.* TO 'new_username'@'hostname';

share|improve this answer

edited Sep 12 at 19:10

answered Sep 12 at 6:11

Catalina ChircuCatalina Chircu

10111 silver badge33 bronze badges

answered Sep 12 at 6:11

Catalina ChircuCatalina Chircu

10111 silver badge33 bronze badges

answered Sep 12 at 6:11

Catalina ChircuCatalina Chircu

10111 silver badge33 bronze badges