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.
Summary: | Problems to connect to MySQL with Netbeans 6.1 in Mandriva 2009 Linux | ||
---|---|---|---|
Product: | db | Reporter: | iawbjava <iawbjava> |
Component: | Code | Assignee: | Jiri Rechtacek <jrechtacek> |
Status: | RESOLVED WORKSFORME | ||
Severity: | blocker | CC: | anebuzelsky |
Priority: | P1 | ||
Version: | 6.x | ||
Hardware: | PC | ||
OS: | Linux | ||
Issue Type: | DEFECT | Exception Reporter: |
Description
iawbjava
2009-03-31 07:14:20 UTC
What vaules did you enter as Server Port Number, Administrator User Name and Administrator Password in the Basic Properties? Hello, here the information you ask for Server Port: 3306 Admin User: root Password: The one I used with the installation of MySQL Let me point out this again: With the "MySQL Administrator" I can reach the MySQL server. This tool uses the same values to connect to th server like I described above. Looking forward to any solution ;-)) Try adding: ALL: ALL@127.0.0.1 : ALLOW ...to your hosts.allow file (I'm on Ubuntu 9.04). This cleared up my problem (though, I welcome any thoughts on undesired security ramifications). One other item, I read a post somewhere that having your machine name identified with 127.0.0.1 confuses some programs (not validated), Ex: If the hostname is 'Nomad', don't have this in your 'hosts' file: 127.0.0.1 localhost.localdomain localhost Nomad I spent a some more time with this issue (from a Linux angle). It seems that If you compile MySQL with the option --with-libwrap, for tcp wrappers, you will (also) be required to grant access to users inside your 'hosts.allow' file (yes, for EACH/ALL computers accessing your MySql Server). Examples of 'host.allow' directives include: mysqld: ALL@127.0.0.1 : ALLOW # <or...> ALL: ALL@127.0.0.1 : ALLOW # <or...> mysqld: ALL@<your IP address here> : ALLOW ... an aside, #1: if you experience long delays in your initial handshaking, when logging in from a remote computer, check that your remote computer's firewall(and/or router) allows IDENT (port 113) from the server. Failure can result in wait times of several minutes [security issues not addressed here]. Second... Ubuntu now (8.04+) ships with AppArmor and an AppArmor profile for Mysql. Several other Linux distributions do the same. If you continue to experience issues with your MySql connection, take a look in that direction. Please, try new version of IDE (http://www.netbeans.org/downloads/index.html). I am not able to test it on Mandriva, but I have no issues on Ubuntu 9.04 with the latest version of IDE. Closing without more info as worksforme. |