Différences

Ci-dessous, les différences entre deux révisions de la page.

--- mysql-create-db-user:mysql_create_database_user [2018/09/11 09:17] – créée ronan
+++ mysql-create-db-user:mysql_create_database_user [2019/01/11 16:00] (Version actuelle) – rguyader
@@ Ligne 1: / Ligne 1: @@
 ====== MYSQL create database user ======
-  # export MYSQL_DBNAME="db_horde2"
+<code bash>
-  # export MYSQL_USERNAME="u_horde2"
+export MYSQL_DBNAME="db_horde2"
-  # export MYSQL_USERPWD="mypass"
+export MYSQL_USERNAME="u_horde2"
+export MYSQL_USERPWD="mypass"
+</code>
 ===== Initialisation tables mysql =====
-  # echo "CREATE DATABASE $MYSQL_DBNAME;" > /root/tmp_mysql_create_user_and_table.sql
+<code bash>
-  # echo "GRANT ALL" >> /root/tmp_mysql_create_user_and_table.sql
+echo "CREATE DATABASE $MYSQL_DBNAME;" > /root/tmp_mysql_create_user_and_table.sql
-  # echo "ON $MYSQL_DBNAME.*" >> /root/tmp_mysql_create_user_and_table.sql
+echo "GRANT ALL" >> /root/tmp_mysql_create_user_and_table.sql
-  # echo "TO $MYSQL_USERNAME@localhost" >> /root/tmp_mysql_create_user_and_table.sql
+echo "ON $MYSQL_DBNAME.*" >> /root/tmp_mysql_create_user_and_table.sql
-  # echo "IDENTIFIED BY '$MYSQL_USERPWD';" >> /root/tmp_mysql_create_user_and_table.sql
+echo "TO $MYSQL_USERNAME@localhost" >> /root/tmp_mysql_create_user_and_table.sql
-  # echo "FLUSH PRIVILEGES;" >> /root/tmp_mysql_create_user_and_table.sql
+echo "IDENTIFIED BY '$MYSQL_USERPWD';" >> /root/tmp_mysql_create_user_and_table.sql
-  # cat /root/tmp_mysql_create_user_and_table.sql | mysql --defaults-extra-file=/etc/mysql/debian.cnf
+echo "FLUSH PRIVILEGES;" >> /root/tmp_mysql_create_user_and_table.sql
-  # rm /root/tmp_mysql_create_user_and_table.sql
+cat /root/tmp_mysql_create_user_and_table.sql | mysql --defaults-extra-file=/etc/mysql/debian.cnf
+rm /root/tmp_mysql_create_user_and_table.sql
-  # mysql --verbose --execute "show tables;" --user=$MYSQL_USERNAME --password=$MYSQL_USERPWD $MYSQL_DBNAME
+mysql --verbose --execute "show tables;" --user=$MYSQL_USERNAME --password=$MYSQL_USERPWD $MYSQL_DBNAME
+</code>