I am creating a docker mariadb image and wanted to create a database and user name before bootstrapping mysqld daemon. So as per the documentation I tried below queries.
mysql_embedded -e "CREATE DATABASE IF NOT EXISTS test ;" mysql_embedded -e "CREATE USER admin@localhost IDENTIFIED BY 'password';" mysql_embedded -e "select user, host, password, plugin from mysql.user;"
The above query successfully create a database and display user information. But it didn't create the user i.e the middle query didn't get executed. Even it didn't show any error. Can't I create an user using
What is the alternative to mysql_embedded. Is it mysqld --bootstrap ?
Here is a blogpost on mysql_embedded https://mariadb.com/resources/blog/using-mysql_embedded-and-mysqld-bootstrap-to-tinker-with-privilege-tables/