Geek Answers Handbook

Mysql travis database creates user error

I wanted to configure travis for my spring-boot project, where I use user makler / makler to access the database. When I start travis, I get an error message:

$ mysql -u root -e 'CREATE DATABASE stockmarket;' $ mysql -u root -e 'CREATE USER 'makler'@'localhost' IDENTIFIED BY 'makler';' ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'makler' at line 1 The command "mysql -u root -e 'CREATE USER 'makler'@'localhost' IDENTIFIED BY 'makler';'" failed and exited with 1 during . Your build has been stopped.

My travis.yml file looks like this:

 language: java jdk: - oraclejdk8 services: - mysql dist: trusty sudo: required addons: apt: packages: - mysql-server-5.6 - mysql-client-core-5.6 - mysql-client-5.6 before_script: - mysql -u root -e 'CREATE DATABASE stockmarket;' - mysql -u root -e 'CREATE USER 'makler'@'localhost' IDENTIFIED BY 'makler';' - mysql -u root -e 'GRANT ALL ON stockmarket.* TO 'makler'@'localhost';'
+5
source share
1 answer

His quotes are related to the request. Update the before_script file to surround requests using double quotes (") instead of single quotes (')

 before_script: - mysql -u root -e 'CREATE DATABASE stockmarket;' - mysql -u root -e "CREATE USER 'makler'@'localhost' IDENTIFIED BY 'makler';" - mysql -u root -e "GRANT ALL ON stockmarket.* TO 'makler'@'localhost';"

The build worked fine after I changed it and started the build on travis. Hope this helps.

+8
source

More articles:


All Articles