| Bug #71605 | MySQL Workbench could not open database | ||
|---|---|---|---|
| Submitted: | 6 Feb 2014 10:56 | Modified: | 23 Jun 2016 23:28 |
| Reporter: | Ericson Kanagaraj | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S2 (Serious) |
| Version: | 6.0.8 | OS: | Windows (Win7 x64) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | could not open database, workbench | ||
[6 Feb 2014 11:01]
Ericson Kanagaraj
I also checked MySQL Server logs but nothing unusual...
[8 Feb 2014 15:40]
Ericson Kanagaraj
SOLVED ! Here is the solution based on my experience, In Windows 7 x64, 1. Backup the database files in MySQL Server 5.6 2. Uninstall MySQL Server 5.6 3. Remove the MySQL folder in C:\ProgramData 4. Remove folder D:\Program Files (x86)\MySQL\MySQL Workbench 6.0 CE 5. Re-install MySQL Installer Community 5.7.3 package with MySQL Workbench 6.0.8 6. Set MySQL port to 3307 - (Installation failed with port 3306) 7. Name MySQL Service name as MySQL57 8. If installation successful - (If failed repeat from Step 2, change port, remove dependant other mysql directories, services) 9. Run cmd.exe as Administrator 10 Type 'net start MySQL57' and enter 11 If Server started successfully 12 Open MySQL Workbench and set the server connection parameter 13 Connect to Server
[10 Feb 2014 11:41]
MySQL Verification Team
So issue solved?. Thanks.
[11 Mar 2014 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[23 Jun 2016 23:28]
MySQL Verification Team
I couldn't repeat with 6.3.7.
[7 Jul 2016 18:33]
Gaurav Vasistha
Solved for windows 7 64 bit mysql workbench 6.0 CE solution is weird but it works so just give it a try 1. Go to Start. 2. Type %temp% in the search box and then click the Temp folder item that appears at the top. 3. At the top of the Explorer window, in the address bar, click the folder to the left of Temp in the folder path (Local by default). 4. In the folder list, right-click the Temp folder and then click Properties and then click the Security tab. 5. Click the Edit button and on the next screen click Add. 6. On the next screen, in the large text window type Everyone and then click 7. Check Names - Everyone should then be underlined. 8. Check the box for Full control under the Allow column, and then click OK, then OK again, and OK again to close all the windows. I discovered this while trying to uninstall workbench in order to reinstall it and while installing it gave an error message "the installer has encountered an unexpected error installing this package 2203 windows 7"
Description: Im using MySQL Workbench for a very long time to develop websites. TCP Host: localhost Port:3307 User:root Connecting to MySQL database server at localhost by TCP with root user is as usual. But, suddenly on 27 Jan 2014, it couldn't connect to the database. Error Message Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3307: Could not open database. Please: 1. Check that mysql is running on server 127.0.0.1 2. Check that mysql is running on port 3307 (note: 3306 is the default, but this can be changed) 3. Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines) 4. Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting But when I Test Connection, the parameters are correct. The MySQL Server 5.1 are running. In fact, my PHP Local Websites can access/query the database. When I connect to the database from TOAD for MySQL it is possible to view the database contents. Why I cannot use MySQL Workbench 6.0.7 ? How to repeat: Open MySQL Workbench Create new connection TCP Host: 127.0.0.1 or localhost Port: 3307 User: root with password root When test connection, Parameters are correct. But, when return to server connection page & connect the the created server, The error shown in description above pops up. Suggested fix: I tried uninstalling MySQL Workbench 6.0.7. Installed new version, 6.0.8 But still not working. Something is stopping MySQL Workbench Tried connecting again using same parameter in TOAD for MySQL and it's working. Tried connection with local website and it's working.