Bug #81153 | MySQL Workbench - MySQL Connections: "Cannot connect to Database server" warning | ||
---|---|---|---|
Submitted: | 20 Apr 2016 9:18 | Modified: | 20 Apr 2016 12:40 |
Reporter: | Hyrundo Webarch | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 6.3.6 | OS: | MacOS (OS X 10.11.x El Capitan) |
Assigned to: | CPU Architecture: | Any | |
Tags: | WBBugReporter |
[20 Apr 2016 9:18]
Hyrundo Webarch
[20 Apr 2016 9:33]
Hyrundo Webarch
When I try to make a Test Connection, the system prompts me back: "Failed to Connect to MySQL at localhost:3306 with user root" both if I use or don't use the password: Access denied for user 'root'@'localhost' (using password: YES)" Access denied for user 'root'@'localhost' (using password: NO)
[20 Apr 2016 11:30]
Hyrundo Webarch
And if I store a password into the keychain [I attach here a screenshot of the "connection settings with password stored"], then, when I try to launch the connection, I get the prompt for the password as an infinite loop [check the other screenshot called "prompt for password in infinite loop"] I TRIED EVERYTHING I COULD THINK OF… now ?
[20 Apr 2016 12:38]
Hyrundo Webarch
NOW: SORRY TO HAVE SPOILED YOUR PRECIOUS TIME GUYS ! I DESERVE YOUR MERCIFUL COMPASSION FOR THIS ! I forgot that when installing MySQL Server vs. 5.7.12 the system gave me a DEFAULT alphanumeric password, that I wrote on a paper; then, after the installation of MySQL Workbench, I was trying to launch the server connection - with the feature <password not stored> when launching it, but - of course ! - being the localhost MySQL server password set to THAT initial alphanumeric code then Workbench would ignore ANY attempt to use a blank space or any other root saved to the keychain on the fly. SOLUTION: that meant only to digit the initial alphanumeric MySQL server password and then the Workbench prompted me: "This is the initial password, choose another one to continue" [something like that] so I just digited that original alphanumeric string, then I choosed another password, repeated it and boom ! here we go: I'm into the workbench and everything seems to be working fine. Once again: SORRY TO HAVE SPOILED YOUR PRECIOUS TIME, please consider this ticket to be CLOSED. Thank You, Best Regards Hyrundo