How to create database with Liquibase
18,940
Looks like you're not passing a username or password as part of your config:
(from the liquibase maven documentation)
<configuration>
<changeLogFile>src/main/resources/changelog.xml</changeLogFile>
<driver>com.mysql.jdbc.Driver</driver>
<url>jdbc:mysql://localhost:3306/myApp?createDatabaseIfNotExist=true</url>
<username>liquibaseTest</username>
<password>pass</password>
</configuration>
Author by
daydreamer
Hello Viewer, Some of the places to see my work are BonsaiiLabs My Website
Updated on June 06, 2022Comments
-
daydreamer over 1 year
- I am trying to use
Liquibase
to create database that does not exists. I have downloaded
MySQL
and not made any change in itMy maven plugin code looks like
<plugins> <plugin> <groupId>org.liquibase</groupId> <artifactId>liquibase-maven-plugin</artifactId> <version>3.1.1</version> <configuration> <changeLogFile>src/main/resources/changelog.xml</changeLogFile> <driver>com.mysql.jdbc.Driver</driver> <url>jdbc:mysql://localhost:3306/myApp?createDatabaseIfNotExist=true</url> </configuration> <executions> <execution> <phase>process-resources</phase> <goals> <goal>update</goal> </goals> </execution> </executions> </plugin> </plugins>
When I run
mvn clean install
, I see error asFailed to execute goal org.liquibase:liquibase-maven-plugin:3.1.1:update (default) on project database_seed: Error setting up or running Liquibase: liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ''@'localhost' to database 'myApp' -> [Help 1]
How do I fix it?
- I am trying to use