mysql增添删除用户

mysql添加删除用户 #!/bin/bash read -p "input your name: " NAME read -p "input your passwd:" PASSWD mysql -uvpn -pvpn123 EOF use vpn; insert into vpnuser (name,password) values('$NAME' ,'$PASSWD'); EOF echo "vpn add is ok...." #!/bin/bash re

mysql添加删除用户
#!/bin/bash
read -p "input your name: "  NAME
read -p "input your passwd:" PASSWD
mysql -uvpn -pvpn123 use vpn;
insert into vpnuser (name,password) values('$NAME' ,'$PASSWD');
EOF
echo "vpn add  is  ok...."

#!/bin/bash
read -p "input your name: "  NAME
mysql -uvpn -pvpn123 use vpn;
delete from vpnuser where name="$NAME";
EOF
echo "vpn delete  is  ok...."