本文介绍了python fabric mysql 权限的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
尝试使用fabric设置mysql用户权限.
Trying to set mysql user privileges with fabric.
run("mysql -u %s -p%s -e 'grant all on %s.* to '%s'@'localhost' identified by 'PASSWORD'" % (user, dbpasswd, account))
错误
TypeError: not enough arguments for format string
有什么想法吗?非常感谢!
Any idea ? Thanks a lot !
run('mysql -u %s -p%s -e "grant all on %s.* to '%s\'@\'localhost' identified by 'PASSWORD'"' % (user, dbpasswd, account, account))
SyntaxError: unexpected character after line continuation character
推荐答案
将您的元组更改为 (user, dbpasswd, account, user)
并且您应该很好.发生此错误是因为您有 4 个替换标记 (%s),但元组中只有 3 个项目.
Change your tuple to (user, dbpasswd, account, user)
and you should be good. This error happens because you have 4 replacements tokens (%s) but only have 3 items in your tuple.
这篇关于python fabric mysql 权限的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!