Let MySQL users create databases, but allow access to only their own databases

by

You can use 

GRANT ALL PRIVILEGES ON `testuser\_%` .  * TO 'testuser'@'%';

to grant the user testuser privileges on all databases with names beginning with testuser_.

This allows the testuser to create databases limited to names starting with testuser_

More Related Contents:

  1. How do I set the time zone of MySQL?
  2. SQL statement is ignoring where parameter
  3. How to set initial value and auto increment in MySQL?
  4. Types in MySQL: BigInt(20) vs Int(20)
  5. Column calculated from another column?
  6. Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?
  7. How does MySQL process ORDER BY and LIMIT in a query?
  8. When should I use a composite index?
  9. MySQL Update Inner Join tables query
  10. Generating a random & unique 8 character string using MySQL
  11. How can I restore the MySQL root user’s full privileges?
  12. Can I restore a single table from a full mysql mysqldump file?
  13. Mysql adding user for remote access
  14. Timestamp with a millisecond precision: How to save them in MySQL
  15. Combine Multiple child rows into one row MYSQL
  16. sql join two table
  17. How to schedule a MySQL query?
  18. Compare dates in MySQL
  19. Is there a Profiler equivalent for MySql? [closed]
  20. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  21. MySQL root password change
  22. MySQL SELECT last few days?
  23. Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
  24. Greatest value of multiple columns with column name?
  25. I keep getting this mysql error code #1089
  26. How to close sqlalchemy connection in MySQL
  27. How do I lock on an InnoDB row that doesn’t exist yet?
  28. How to do unique constraint works with NULL value in MySQL
  29. How do I make a MySQL database run completely in memory?
  30. Using OR in LIKE Query in MySQL to compare multiple fields

Leave a Comment