参考我们开发调试的一个脚本,把 ### ~~~换成自己的信息就行
#!/bin/bash
login=" -uroot -D mysql -e"
createuser="insert user(Host,User,Password) values ('localhost','###', password('~~~'));"
grantuser="grant all privileges on ~~~.* to ### identified by '###'"
mysql ${login} "${createuser}"
mysql ${login} "flush privileges"
echo 'auth user'
mysql ${login} "${grantuser}"
mysql ${login} "flush privileges"
#import database
echo 'import schema'
mysql --default-character-set=utf8 -uroot -D mysql -e "source ##.sql"