How to configure Execute SQL Script in install4j for MySQL?

Question

I am trying to configure an Execute SQL Script from install4j in order to crate a database schema, but that Script/Item fails.

Here are the current settings:

JDBC Driver class name: DriverManager
JDBC URL: jdbc:mysql://localhost/
User: root
Password: password
SQL SCRIPT:

CREATE DATABASE IF NOT EXISTS videos;

GRANT USAGE ON . to videos_user@localhost IDENTIFIED BY '123password';

GRANT ALL PRIVILEGES ON videos.* TO videos_user@localhost;

FLUSH PRIVILEGES;

This at the moment is failing. I think the issue is that I need to add the JDBC driver JAR file. But I don't know where to get it and what class to add in the Driver class name.

I know this migh be a "noob" questions, but I am really stuck at this point.

Thank you!

I've added the driver. But I'm still having errors.

Andrea
– Andrea

2015-05-06 23:17:15 +00:00
Commented May 6, 2015 at 23:17 — Andrea
– Andrea, Commented May 6, 2015 at 23:17

Andrea · Accepted Answer · 2015-05-06 23:28:41Z

1

Fixed it.

I downloaded the connector from http://dev.mysql.com/downloads/connector/j/
JDBC Driver class name should be com.mysql.jdbc.Driver
URL should be jdbc:mysql://localhost

answered May 6, 2015 at 23:28

Andrea

1551 gold badge1 silver badge9 bronze badges

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

Comments

Ingo Kegel · Accepted Answer · 2015-05-06 20:44:36Z

0

Add the JDBC driver JAR on the "Installer->Custom Code & Resources" step.

answered May 6, 2015 at 20:44

Ingo Kegel

48.4k10 gold badges74 silver badges103 bronze badges

1 Comment

Andrea Over a year ago

Where do i find it? what's the class name?

Collectives™ on Stack Overflow

How to configure Execute SQL Script in install4j for MySQL?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related