权限
2017-11-30 本文已影响14人
沈九壹
#!/bin/sh
mysql -uroot -p#e!eT5@22aJEwRaz <<EOF
use mysql;
select Host, User, Password from user;
CREATE DATABASE db_payment DEFAULT CHARACTER SET utf8;
GRANT SELECT, SHOW VIEW ON db_payment.* TO 'doraemonkart'@'%';
GRANT ALL ON db_payment.* TO 'dkart'@'localhost';
FLUSH PRIVILEGES;
select Host, User, Password from user;
EOF
