More than 5 years have passed since last update.

MySQL User 作成（簡易）

MySQL

Last updated at 2014-12-11Posted at 2013-11-07

メモ

dbun=user
dbup=userpassword
dbnm=databasename

dbmn=root
dbmp=rootpassword

dbch=UTF8

mysqladmin -u $dbmn -p$dbmp --default-character-set=$dbch  create $dbnm
mysql      -u $dbmn -p$dbmp mysql --default-character-set=$dbch -e "GRANT ALL ON $dbnm.* TO $dbun@localhost IDENTIFIED BY '$dbup'"
mysql      -u $dbmn -p$dbmp mysql --default-character-set=$dbch -e "SELECT User, Host from mysql.user where User = '$dbun'"
mysqladmin -u $dbmn -p$dbmp flush-privileges
mysql      -u $dbun -p$dbup $dbnm -e "select 1"

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up