我正在尝试检查MYSQL用户是否存在。目前为止,我已经做到了这一点。但是我无法从输出中捕获该答案。
#!/bin/bash
echo -e "What is the MYSQL username called"
read DBUSER
if [ -z "$DBUSER" ]
then
exit
mysql -uUSER -pPASS -e "SELECT EXISTS(SELECT 1 FROM mysql.user WHERE user = '$DBUSER')";
if
yes
do this
else
do this
我得到的输出如下:
+-----------------------------------------------------+
| EXISTS(SELECT 1 FROM mysql.user WHERE user = 'bob') |
+-----------------------------------------------------+
| 1 |
+-----------------------------------------------------+
可以有人帮忙吗?
shell_exec
的时候可以使用。-->$is_mysql_user = shell_exec('mysql --defaults-extra-file=MYPATHTOSTOREDCREDENTIALS -sse "SELECT EXISTS(SELECT 1 FROM mysql.user WHERE user = \'' . $user_name . '\')"');
- aequalsb