Hi,
I need your help.
I’m trying to restore database from sql with mysql_db module (python-mysqldb: 1.2.3-1ubuntu0.1)
Previously I removed all files in /var/lib/mysql/*
and recreate database with mysql_install_db
so now I can “mysql -u root” w/o password
TASK: [mysql_user name=root host=localhost password=123123 priv=.:ALL state=present] ***
fatal: [192.168.10.221] => failed to parse: Traceback (most recent call last):
File “/home/iliya/.ansible/tmp/ansible-1375259963.04-183140106975975/mysql_user”, line 1281, in
main()
File “/home/iliya/.ansible/tmp/ansible-1375259963.04-183140106975975/mysql_user”, line 374, in main
changed = user_mod(cursor, user, host, password, priv)
File “/home/iliya/.ansible/tmp/ansible-1375259963.04-183140106975975/mysql_user”, line 156, in user_mod
privileges_revoke(cursor, user,host,db_table)
File “/home/iliya/.ansible/tmp/ansible-1375259963.04-183140106975975/mysql_user”, line 237, in privileges_revoke
cursor.execute(query)
File “/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py”, line 174, in execute
self.errorhandler(self, exc, value)
File “/usr/lib/python2.7/dist-packages/MySQLdb/connections.py”, line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, “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 ‘’‘@’’ FROM ‘root’@‘localhost’’ at line 1”)
Thanks a lot.