Java JDBC Tutorial – Part 12.2: Connect Java Swing GUI to a MySQL Database

In this video we will learn how to to connect a Java GUI to a MySQL database.

Please SUBSCRIBE to this channel

Download Java Source Code

By luv2admin|2014-09-14T22:46:21-04:00September 14, 2014|How-To, Java, JDBC, MySQL, Swing|2 Comments

2 Comments

Fatih November 12, 2015 at 11:36 am

Hi Chad, I have a problem with this class.
I am using your codes and database(demo) but my user and password are different. Therefore I changed demo.properties’s content as
user: root
password:********
dburl=jdbc:mysql://localhost:3306/demo
and I had this error :

java.sql.SQLException: Access denied for user ‘root ‘@’localhost’ (using password: YES)

Please help me. Thanks….
- Chad Darby November 12, 2015 at 12:59 pm
  
  Seems as though you are using the wrong password for the root account.
  
  I assume for “password:********” … that you actually have the real password there?
  
  For a MySQL installation, the root password is not set by default. So you could leave the properties file as “password=”.
  
  If that doesn’t work, then you have two options.
  
  Option 1: Reset root password
  – http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
  
  Option 2: Reinstall MySQL database
  
  Let me know how things work out for you 🙂

Comments are closed.