mysql-create-db-user:mysql_create_database_user
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 ====== | ====== MYSQL create database user ====== | ||
- | # export MYSQL_DBNAME=" | + | <code bash> |
- | # | + | export MYSQL_DBNAME=" |
- | # | + | export MYSQL_USERNAME=" |
+ | export MYSQL_USERPWD=" | ||
+ | </ | ||
===== Initialisation tables mysql ===== | ===== Initialisation tables mysql ===== | ||
- | # echo " | + | <code bash> |
- | # | + | echo " |
- | # | + | echo "GRANT ALL" >> / |
- | # | + | echo "ON $MYSQL_DBNAME.*" |
- | # | + | echo "TO $MYSQL_USERNAME@localhost" |
- | # | + | echo " |
- | # | + | echo "FLUSH PRIVILEGES;" |
- | # rm / | + | cat / |
+ | rm / | ||
- | # mysql --verbose --execute "show tables;" | + | mysql --verbose --execute "show tables;" |
+ | </ |
mysql-create-db-user/mysql_create_database_user.1536657421.txt.gz · Dernière modification : 2018/09/11 09:17 de ronan