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

read -p “input your name: ”  NAME

mysql -uvpn -pvpn123 <<EOF

use vpn;

delete from vpnuser where name=”$NAME”;

EOF

echo “vpn delete  is  ok….”