I'm lead to understand that the following grants all proveleges to all databases that name begin with 'xian_', but mysql complains about a syntax error
GRANT ALL PRIVILEGES ON 'xian_%.*' TO xian@'192.168.1.%';
What is the correct syntax? Am I right in thinking that the
_ needs escaping to
\_ too as it is also a wildcard?