This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
UI is a little unclear and i am not sure what i am doing wrong I have mysql db running and have one open connection listed on localhost:3306 (i can view table contents) In the Services window the MySQL Server node says not connected. So When i try to modify properties : 1. Services window - right-click MySQL Server > Administer I get Question box that asks me to set the path. 2. I click OK and see the Server Properties dialog. 3. I do not add info to Admin Properties and I click on Basic Properties and add the admin pw and click OK. 4. I get warning dialog "Unable to connect to MySQL server. Please check.... : java.sql.SQLException: Illegal connection port value 'localhost:3306' " 5. Clicking OK returns me back to Question box from step 1.
The Administer action allows you to bring up an administration tool for MySQL - an external tool like phpmyadmin or the MySQL Administrator. You need to tell NetBeans where this is by clicking on the Admin tab, and then NetBeans will run the administration tool as a separate process (or bring it up in the browser if it's a browser-based tool). At the same time, you are currently not connected to the MySQL server through NetBeans. This is completely separate from the Administer use case, but I can see how it is confusing. You need to make sure the host and port, user and password are all set correctly in the Basic tab. It sounds like you have the port field set to "localhost:3306"? (guessing, from the error message). It's also probably confusing that when you modify the properties, we automatically try to connect to MySQL, when you were trying to run the Administer action. It's odd that it takes you back to the question box from step 1, *that* sounds like a bug. I think I just got the flow wrong in that case, clicking OK after an error should just take you back to the explorer. I'm not sure how to clarify the Administer action. I think maybe I should call it "Run Administration Tool" rather than "Administer". What do you think, would that help?
A number of things to fix here: - Change 'Administer' to 'Run Administration Tool' - Don't automatically connect to MySQL server if the properties dialog is brought up as part of 'Administer' action - On error, don't go back to initial prompt, but take the user back to the main explorer panel.
My fix does the following: - Changes the name to 'Run Administration Tool' - Only reconnects if the connection properties have changed I couldn't reproduce the bug where it went back to the initial prompt on error. Also fixed the display name to be a little more informative
http://hg.netbeans.org/main?cmd=changeset;node=28b51edf402e