当前位置:Gxlcms > mysql > mysql增添删除用户

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...."

人气教程排行