Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

My SQL WorkBench Root password is not working  RSS feed

 
Pam Bajaj
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
Can you please help me? I am 100% sure about my password that i am using the right password but somehow it is refusing to accept it and i can't do my work without it. Please tell me what i can do to resolve it? I tried some of the options i saw on some Forms but somehow no luck. Thank You!
MySQL_Workbench_rootpassword.png
[Thumbnail for MySQL_Workbench_rootpassword.png]
 
Swastik Dey
Rancher
Posts: 1812
15
Android Eclipse IDE Java Java ME
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You may try resetting the password.

https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
 
Davide Prampolini
Greenhorn
Posts: 7
2
Chrome Ubuntu
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, is WorkBench located in the same machine where is located the SQL server?
 
Pam Bajaj
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Davide! Yes it is of course on the same machine. This is my personal mac. Thanks
 
Davide Prampolini
Greenhorn
Posts: 7
2
Chrome Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Did you already tried the solution suggested by Swastik Dey?

Are you still able to login using mysql shell instead of MySQL Workbench?

If Workbench and the mysql server are both in the same machine you could try to login using "127.0.0.1" instead of "localhost" as SQL host address.





 
Pam Bajaj
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Davide! I tried whatever solutions i found on all the forums. Not remember by name which one's i tried. When i run my application on Eclipse i get the following error and this is happening because i can't connect to my SQL Workbench.

java.sql.SQLException: Access denied for user 'springboot'@'localhost' (using password: YES)

You wrote:
If Workbench and the mysql server are both in the same machine you could try to login using "127.0.0.1" instead of "localhost" as SQL host address.

And to be very honest i dont' how to do that. I am not doing anything on mysql server. I installed it one time and after that i am just using MySQl Workbench. Thanks
 
Pam Bajaj
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I tried with 127.0.0.1 also and that also does not work. GIves me the same error. thanks
 
Pam Bajaj
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes i tried what Swastik Dey said. So far no luck. Thanks
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!