GRANT with database name wildcard in MySQL?

by

If I use back-tics instead of single quotes in the syntax, it appears to work just fine:

grant all on `projectA\_%`.* to `projectA`@`%`;

More Related Contents:

  1. How can I fix MySQL error #1064?
  2. grant remote access of MySQL database from any IP address
  3. How to grant remote access permissions to mysql server for user?
  4. 1064 error in CREATE TABLE … TYPE=MYISAM
  5. MySQL error 1449: The user specified as a definer does not exist
  6. Using an Alias in SQL Calculations
  7. What is the question mark’s significance in MySQL at “WHERE column = ?”?
  8. How do I modify a MySQL column to allow NULL?
  9. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  10. MySQL grant all privileges to database except one table
  11. MySQL delimiter syntax error
  12. Get Insert Statement for existing row in MySQL
  13. How to grant remote access to MySQL for a whole subnet?
  14. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  15. left join query keep a column empty
  16. How to do a regular expression replace in MySQL?
  17. Count the number of occurrences of a string in a VARCHAR field?
  18. What is the ideal data type to use when storing latitude / longitude in a MySQL database?
  19. Can’t connect to MySQL server error 111 [closed]
  20. How to import a CSV file into a MySQL table
  21. How to store arrays in MySQL?
  22. How do I select between the 1st day of the current month and current day in MySQL?
  23. Subqueries with EXISTS vs IN – MySQL
  24. How do I generate nested json objects using mysql native json functions?
  25. MySQL: LAST_INSERT_ID() returns 0
  26. ERROR 1044 (42000): Access denied for ‘root’ With All Privileges
  27. Mysql performance on 6 million row table
  28. How can I “select *” from a table in MySQL but omit certain columns?
  29. MySQL Select Multiple VALUES
  30. Convert SQL Server query to MySQL [duplicate]

Leave a Comment