Connecting to your SQL Server
Hi guys! This is a quick tutorial on how to setup the project to work with your SQL Server.
When you install the MySQL workbench together with the Server, it will prompt you for a username and password. This would be the username and password that you will use to create a connection. And these authentication elements are the ones needed in auth.txt
When you already have the Netbeans Project, open the project's directory on your computer (not with Netbeans). You will see something like this:
The highlighted one is auth.txt. The format is as follows:
Put your username in the first line; and your password in the next time.
That should work now. Run the software to check if it works.
You should have one to run the software. Maybe you just forgot or placed it in the vault. I am not so sure about what to do when you don't have one. You can create a new connection with a username and password to solve this.
Does it say "Broken reference blah blah blah?" If yes, then you just forgot to add the connector file (Connector J). To add that, just right click on the projects folder in Netbeans -> Properties -> Libraries -> Add JAR/Folder -> browse for your connector. (I'll attach the link where you can get it but I'm a bit lazy now, so I'll attach it some other time)
Just put your username and password in the auth.txt file you will see.
That's all :)
For inquiries contact me or any of the devs.