Context: I know nothing about databases

Last login: Mon Jun 19 18:29:55 on ttys001
Tests-MacBook:~ me_irl$ cd pxls
Tests-MacBook:pxls me_irl$ java -jar target/pxls-1.0-SNAPSHOT.jar
Warning: Cannot find board.dat in working directory, using blank board
Warning: Cannot find heatmap.dat in working directory, using blank heatmap
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Exception in thread "main" com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: url parsing error : '//' is not present in the url jdbc:mysql:3306
	at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:544)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:536)
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
	at space.pxls.data.Database.<init>(Database.java:42)
	at space.pxls.App.main(App.java:73)
Caused by: java.sql.SQLException: url parsing error : '//' is not present in the url jdbc:mysql:3306
	at org.mariadb.jdbc.UrlParser.parseInternal(UrlParser.java:204)
	at org.mariadb.jdbc.UrlParser.parse(UrlParser.java:152)
	at org.mariadb.jdbc.Driver.connect(Driver.java:95)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:356)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:199)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:444)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:515)
	... 4 more
Tests-MacBook:pxls me_irl$ java -jar target/pxls-1.0-SNAPSHOT.jar
Warning: Cannot find board.dat in working directory, using blank board
Warning: Cannot find heatmap.dat in working directory, using blank heatmap
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Exception in thread "main" com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Could not connect: Access denied for user 'admin'@'localhost' to database 'pxls'
	at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:544)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:536)
	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)
	at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:72)
	at space.pxls.data.Database.<init>(Database.java:42)
	at space.pxls.App.main(App.java:73)
Caused by: java.sql.SQLSyntaxErrorException: Could not connect: Access denied for user 'admin'@'localhost' to database 'pxls'
	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:139)
	at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)
	at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:91)
	at org.mariadb.jdbc.Driver.connect(Driver.java:109)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:356)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:199)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:444)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:515)
	... 4 more
Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Could not connect: Access denied for user 'admin'@'localhost' to database 'pxls'
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:571)
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:503)
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:382)
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:839)
	at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:479)
	at org.mariadb.jdbc.Driver.connect(Driver.java:104)
	... 10 more
Tests-MacBook:pxls me_irl$ java -jar target/pxls-1.0-SNAPSHOT.jar
Warning: Cannot find board.dat in working directory, using blank board
Warning: Cannot find heatmap.dat in working directory, using blank heatmap
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Creating new mariadb connection...
space.pxls.data.Database$DatabaseHandle@44a7bfbc
Exception in thread "main" org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: java.sql.SQLSyntaxErrorException: (conn:5) Invalid default value for 'time'
Query is: CREATE TABLE IF NOT EXISTS pixels (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,x INT UNSIGNED NOT NULL,y INT UNSIGNED NOT NULL,color TINYINT UNSIGNED NOT NULL,who INT UNSIGNED,secondary_id INT UNSIGNED,time TIMESTAMP NOT NULL DEFAULT now(6),mod_action BOOLEAN NOT NULL DEFAULT false,rollback_action BOOLEAN NOT NULL DEFAULT false,undo_action BOOLEAN NOT NULL DEFAULT false,most_recent BOOLEAN NOT NULL DEFAULT true);CREATE INDEX IF NOT EXISTS pos ON pixels (x,y) COMMENT 'pos';CREATE INDEX IF NOT EXISTS most_recent ON pixels (most_recent) COMMENT 'most_recent'; [statement:"CREATE TABLE IF NOT EXISTS pixels (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,x INT UNSIGNED NOT NULL,y INT UNSIGNED NOT NULL,color TINYINT UNSIGNED NOT NULL,who INT UNSIGNED,secondary_id INT UNSIGNED,time TIMESTAMP NOT NULL DEFAULT now(6),mod_action BOOLEAN NOT NULL DEFAULT false,rollback_action BOOLEAN NOT NULL DEFAULT false,undo_action BOOLEAN NOT NULL DEFAULT false,most_recent BOOLEAN NOT NULL DEFAULT true);CREATE INDEX IF NOT EXISTS pos ON pixels (x,y) COMMENT 'pos';CREATE INDEX IF NOT EXISTS most_recent ON pixels (most_recent) COMMENT 'most_recent';", located:"CREATE TABLE IF NOT EXISTS pixels (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,x INT UNSIGNED NOT NULL,y INT UNSIGNED NOT NULL,color TINYINT UNSIGNED NOT NULL,who INT UNSIGNED,secondary_id INT UNSIGNED,time TIMESTAMP NOT NULL DEFAULT now(6),mod_action BOOLEAN NOT NULL DEFAULT false,rollback_action BOOLEAN NOT NULL DEFAULT false,undo_action BOOLEAN NOT NULL DEFAULT false,most_recent BOOLEAN NOT NULL DEFAULT true);CREATE INDEX IF NOT EXISTS pos ON pixels (x,y) COMMENT 'pos';CREATE INDEX IF NOT EXISTS most_recent ON pixels (most_recent) COMMENT 'most_recent';", rewritten:"CREATE TABLE IF NOT EXISTS pixels (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,x INT UNSIGNED NOT NULL,y INT UNSIGNED NOT NULL,color TINYINT UNSIGNED NOT NULL,who INT UNSIGNED,secondary_id INT UNSIGNED,time TIMESTAMP NOT NULL DEFAULT now(6),mod_action BOOLEAN NOT NULL DEFAULT false,rollback_action BOOLEAN NOT NULL DEFAULT false,undo_action BOOLEAN NOT NULL DEFAULT false,most_recent BOOLEAN NOT NULL DEFAULT true);CREATE INDEX IF NOT EXISTS pos ON pixels (x,y) COMMENT 'pos';CREATE INDEX IF NOT EXISTS most_recent ON pixels (most_recent) COMMENT 'most_recent';", arguments:{ positional:{}, named:{}, finder:[]}]
	at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1338)
	at org.skife.jdbi.v2.Update.execute(Update.java:56)
	at org.skife.jdbi.v2.sqlobject.UpdateHandler$2.value(UpdateHandler.java:67)
	at org.skife.jdbi.v2.sqlobject.UpdateHandler.invoke(UpdateHandler.java:79)
	at org.skife.jdbi.v2.sqlobject.SqlObject.invoke(SqlObject.java:224)
	at org.skife.jdbi.v2.sqlobject.SqlObject$3.intercept(SqlObject.java:133)
	at org.skife.jdbi.v2.sqlobject.CloseInternalDoNotUseThisClass$$EnhancerByCGLIB$$e05fe74.createPixelsTable(<generated>)
	at space.pxls.data.Database.<init>(Database.java:45)
	at space.pxls.App.main(App.java:73)
Caused by: java.sql.SQLSyntaxErrorException: (conn:5) Invalid default value for 'time'
Query is: CREATE TABLE IF NOT EXISTS pixels (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,x INT UNSIGNED NOT NULL,y INT UNSIGNED NOT NULL,color TINYINT UNSIGNED NOT NULL,who INT UNSIGNED,secondary_id INT UNSIGNED,time TIMESTAMP NOT NULL DEFAULT now(6),mod_action BOOLEAN NOT NULL DEFAULT false,rollback_action BOOLEAN NOT NULL DEFAULT false,undo_action BOOLEAN NOT NULL DEFAULT false,most_recent BOOLEAN NOT NULL DEFAULT true);CREATE INDEX IF NOT EXISTS pos ON pixels (x,y) COMMENT 'pos';CREATE INDEX IF NOT EXISTS most_recent ON pixels (most_recent) COMMENT 'most_recent';
	at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:139)
	at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)
	at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)
	at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:226)
	at org.mariadb.jdbc.MariaDbClientPreparedStatement.executeInternal(MariaDbClientPreparedStatement.java:233)
	at org.mariadb.jdbc.MariaDbClientPreparedStatement.execute(MariaDbClientPreparedStatement.java:163)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1327)
	... 8 more
Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Invalid default value for 'time'
Query is: CREATE TABLE IF NOT EXISTS pixels (id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,x INT UNSIGNED NOT NULL,y INT UNSIGNED NOT NULL,color TINYINT UNSIGNED NOT NULL,who INT UNSIGNED,secondary_id INT UNSIGNED,time TIMESTAMP NOT NULL DEFAULT now(6),mod_action BOOLEAN NOT NULL DEFAULT false,rollback_action BOOLEAN NOT NULL DEFAULT false,undo_action BOOLEAN NOT NULL DEFAULT false,most_recent BOOLEAN NOT NULL DEFAULT true);CREATE INDEX IF NOT EXISTS pos ON pixels (x,y) COMMENT 'pos';CREATE INDEX IF NOT EXISTS most_recent ON pixels (most_recent) COMMENT 'most_recent';
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1144)
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1076)
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1031)
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:203)
	at org.mariadb.jdbc.MariaDbClientPreparedStatement.executeInternal(MariaDbClientPreparedStatement.java:224)
	... 12 more
Tests-MacBook:pxls me_irl$