时间戳

首页 > 解决方案 > Ansible playbook：MariaDB 用户创建失败

mysql - Ansible playbook：MariaDB 用户创建失败

问题描述

我正在尝试创建一个数据库用户，但它会引发错误。任何帮助深表感谢！

Ansible version: 2.0.0.2
MariaDB version: mysql  Ver 15.1 Distrib 10.0.38-MariaDB, 
                 for debian-linux-gnu (x86_64) using readline 5.2

我的剧本中导致以下错误的部分

- name: "Create user for callcenter db"
  mysql_user:
    name: callcenter_rw
    password: "{{mysql_myapp_rw_password}}"
    priv: callcenter.*:SELECT,INSERT,UPDATE,DELETE
    login_user: root
    login_password: "{{mysql_root_password.stdout}}"
    state: present
  when: is_root_password_set.rc == 0

TASK [Create user for callcenter db] *******************************************
fatal: [10.0.1.237]: FAILED! => {"changed": false, 
"failed": true, 
"msg": "(1********64, 
         'You have an error in your SQL syntax; 
         check the manual that corresponds to your MariaDB server 
         version for the right syntax to use near 
         \\'{\\'changed\\': \\'1\\',
         \\'end\\': \"\\'2********19-12-13 17:56:19.799********58\\'\",
         \\'stdout\\': \"\\'********\\'\"\\' at line 1')"
}

标签： mysqlsqlansiblemariadb

解决方案

推荐阅读