how to connect a mysql database to a project in netbeans

Question

I want to connect mysql database to a project in netbeans. I tried few ways but while running the application i am getting error as

u Access denied for user 'User'@'localhost' (using password: YES)

I think my way of connecting may be wrong. Give me information regarding that. My localhost is running in 8080 and mysql which i connected is running in 3306 port. Can anyone give exact steps for connecting database to my applicaiton

Please post your Code.. I think you should check your password what you r passing as a Parameter. — Vikrant Kashyap
– Vikrant Kashyap, Commented Mar 8, 2016 at 8:47
@TomN my question is regarding connection in netbeans not in normal java program using jdbc drivers. — krocks
– krocks, Commented Mar 8, 2016 at 8:50

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

If you want to connect Mysql database with NetBeans then please follow below steps.

1. In the Services window you can right click on the Databases tab and select New Connection.

2. Select MySQL(Connector/J Driver) from the drop-down list. The driver file should be listed in the window. If not, you can download the file, then click add and select it from your hard drive.

3. Finally enter your database details such as servername, username and password and click finish.

for more detail check HERE

For PHP check this link connect it with your PHP application

Let me know in which language you are trying to connect mysql database?

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Mar 8, 2016 at 8:47

Ranish Karim

3661 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

krocks Over a year ago

I followed the same process but getting same error as before

Ranish Karim Over a year ago

have you verified the password of that user from mysql database? and also do that user has permission of localhost?

krocks Over a year ago

after creating database who to linkup with application (without using code)

Ranish Karim Over a year ago

by default root user has permission of all databases. Please try to connect your application with root user and use same password which you use to open phpmyadmin. If you have created new database user then give permission to that user. You can find detail in this link digitalocean.com/community/tutorials/…

Collectives™ on Stack Overflow

how to connect a mysql database to a project in netbeans

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related