Reputation: 93
I can perform the connection in worbanch, but with the same username and password can not connect through the application in the mysql database. I checked the syntax apparently seems to be correct. I would like to help to solve this problem as the .jar is already in the library folder of Java SE project.
print screen:
ERROR CONSOLE: No suitable driver found for jdbc:mysql://127.0.0.1/sakila
Upvotes: 5
Views: 16366
Reputation: 2362
Just simply add the library to your project library. Right click in Library on the Project you use
Then choose MySQL JDBC Driver
Then Click Add Library.So now we can connect to MySQL database
Resource :Java MySQL JDBC Tutorial using NetBeans (Part 1)
Upvotes: 8