travis mysql数据库创建用户错误

发布时间：2021-01-12 13:20:25 所属栏目：MySql 来源：互联网

导读：我想为我的spring-boot项目设置travis,我使用用户makler / makler来访问数据库.运行travis时出现错误说：$mysql -u root -e CREATE DATABASE stockmarket; $mysql -u root -e CREATE USER makler@localhost IDENTIFIE

我想为我的spring-boot项目设置travis,我使用用户makler / makler来访问数据库.运行travis时出现错误说：

$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.

我的travis.yml文件看起来像：

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';'

最佳答案它是查询周围的引号.使用双引号(“)而不是单引号(‘)更新您的before_script以包围查询

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';"

在我更改它并在travis上运行构建之后,构建工作正常.希望这可以帮助.

（编辑：百色站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!