createdb.sql.example 1021 B

12345678910111213141516171819202122232425262728
  1. ###
  2. ### Copy createdb.sql.example to createdb.sql
  3. ### then uncomment then set database name and username to create you need databases
  4. #
  5. # example: .env MYSQL_USER=appuser and need db name is myshop_db
  6. #
  7. # CREATE DATABASE IF NOT EXISTS `myshop_db` ;
  8. # GRANT ALL ON `myshop_db`.* TO 'appuser'@'%' ;
  9. #
  10. ###
  11. ### this sql script is auto run when percona container start and $DATA_PATH_HOST/percona not exists.
  12. ###
  13. ### if your $DATA_PATH_HOST/percona is exists and you do not want to delete it, you can run by manual execution:
  14. ###
  15. ### docker-compose exec percona bash
  16. ### mysql -u root -p < /docker-entrypoint-initdb.d/createdb.sql
  17. ###
  18. #CREATE DATABASE IF NOT EXISTS `dev_db_1` COLLATE 'utf8_general_ci' ;
  19. #GRANT ALL ON `dev_db_1`.* TO 'homestead'@'%' ;
  20. #CREATE DATABASE IF NOT EXISTS `dev_db_2` COLLATE 'utf8_general_ci' ;
  21. #GRANT ALL ON `dev_db_2`.* TO 'homestead'@'%' ;
  22. #CREATE DATABASE IF NOT EXISTS `dev_db_3` COLLATE 'utf8_general_ci' ;
  23. #GRANT ALL ON `dev_db_3`.* TO 'homestead'@'%' ;
  24. FLUSH PRIVILEGES ;