mysql增添删除用户
时间:2021-07-01 10:21:17
帮助过:4人阅读
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...."