Add database created by phpMyAdmin into NetBeans

[petanorech]

Hello,
I've created database by phpMyAdmin (part of the WampServer) and I'd like to add this database into NB, under Services. I've never done this before so I'd appreciate "for dummies" help
I'm using mysql connector 5.1.10.

Thanks a lot in advance.

[Filip Zamboj]

Hi,

so ... if I understand, you created database and it's accessible. I see
it's wamp, so it's probably localhost connection.

Let's have a database called DB, user: user, password: secret. Server is
accessible on default port 3306
Go to Services (ctr+5)
right click on databases
create new connection
Driver Name: mysql
port: 3306
database: DB
user name: user
password: secret
check remember password if you want to.
OK

now the connection should be established if your credentials are OK. You
will see a new connection with all databases user has access to and the
one you entered into new connection dialog will be selected (the same as
mysql use database command)

That's it.

-------------
Filip Zamboj
Sun Microsystems

[1] http://www.netbeans.org/community/issues.html
[2] http://qa.netbeans.org
[3] http://wiki.netbeans.org/HowToConfigureXDebug



petanorech wrote:

[petanorech]

Works great, thanks a lot