0

After clicking on MySQL Connection I'm getting the message: Cannot Connect to Database Server "User interaction failed"

I tried to reset root password via ALTER USER but same message "User interaction failed". See image below: MySQL WorkBench message I also tried to open Manage Server Connections and put the password on Parameters session, but got the same message "Could not store password: user interaction failed" (see image): MySQL WorkBench message Did anyone pass by a situation like mine and could solve it? Does anyone have a clue about solving this issue? Thank you guys!

Improve this question
5
  • Can you verify the connection settings by connecting dirctly to the console for the MySQL server, without Workbench just to make sure the connection settings are correct? But you can't reset a password on a server you can't connect to so that is the reason you have the same error results. Commented Dec 26, 2023 at 21:03
  • Thanks for your insight! Following your help, I did it via systemctl command and the status is active (running). It was also running when I tried what I've described above. Commented Dec 26, 2023 at 21:56
  • Ok sounds like you confirmed the server is up, but that doesn't mean the connection information is correct. Now keep in mind the following link includes php information as well, but you can try to connect to your MySQL server from the command line using the credentials you believe to be correct. If you can get it to connect in the command line, it should also work in Workbench. LINK --> stackoverflow.com/questions/5131931/… Commented Dec 26, 2023 at 22:02
  • I appreciate your help! After your last advice I went to my notebook to try doing what you've told me. For my surprise when I tried to click on the local connection, it worked. I left the connection unprotected by password. So I went to the command line and made the secure Installation. I came back to the workbench and this time it correctly asked the password so I could connect properly. It sounds like I had an spurious bug in my Lenovo computer. Thank you once more for this help! Commented Dec 26, 2023 at 23:44
  • Glad to hear you got it going, good luck with your project! Commented Dec 27, 2023 at 14:02
Related questions
134
Cannot connect to Database server (mysql workbench)
5
Cannot Connect to Database Server mysql workbench
2
MySQL Workbench failed to connect
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.