主页 / ubuntu / 问题 / 1110668
Accepted
IgorAlves
Asked: 2019-01-18 13:29:38 +0800 CST

如何在bash脚本中的双引号字符串中转义单引号？

  • 772

我正在尝试运行以下 bash 代码：

#!/bin/bash
export DEBIAN_FRONTEND=noninteractive

DB_USER='abc'
DB_USER_PASSWORD='123'
DB_MAGENTO='db_magento'

sudo apt-get update  
echo debconf mysql-server/root_password password $DB_USER_PASSWORD | sudo debconf-set-selections
echo debconf mysql-server/root_password_again password $DB_USER_PASSWORD | sudo debconf-set-selections        
sudo apt-get -qq install mysql-server > /dev/null # Install MySQL quietly
sudo mysql -uroot -p123  -e "CREATE SCHEMA ${DB_MAGENTO} DEFAULT CHARACTER SET utf8;SHOW DATABASES;CREATE USER \'${DB_USER}\'@'localhost' IDENTIFIED BY ${DB_USER_PASSWORD};GRANT ALL PRIVILEGES ON * . * TO \'${DB_USER}\'@'localhost'; FLUSH PRIVILEGES;SELECT Host,User,Password FROM mysql.user;"

我得到的错误ERROR at line 1: Unknown command '\''. 似乎与\'${DB_USER}\'.

如何正确转义这些单引号？

更新

Afetr @Sergiy 建议我收到另一个错误：

#!/bin/bash
export DEBIAN_FRONTEND=noninteractive

DB_USER='ila'
DB_USER_PASSWORD='123'
DB_MAGENTO='db_magento'

    mysql -uroot -p123  -e "SHOW DATABASES;CREATE USER '${DB_USER}'@'localhost' IDENTIFIED BY ${DB_USER_PASSWORD};GRANT ALL PRIVILEGES ON * . * TO '${DB_USER}'@'localhost'; FLUSH PRIVILEGES;SELECT Host,User,Password FROM mysql.user;"

错误：

$ sudo ./installMagento.sh 
mysql: [Warning] Using a password on the command line interface can be insecure.
+--------------------+
| Database           |
+--------------------+
| information_schema |
| db_magento         |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '123' at line 1
scripts bash mysql

1 个回答

  1. Best Answer

    您不需要使用\双引号：

    $ DB_USER='abc'; echo "test '${DB_USER}'"
test 'abc'

    或者，您可以打破双引号，并转义单引号 - 这就是必要的地方：

    $ DB_USER='abc';  echo "test"\'"${DB_USER}"\'
test'abc'

    另一种方法是使用printf命令替换并为引号 ( \x27) 使用十六进制值：

    sudo mysql -uroot -p123  -e "$(printf 'CREATE SCHEMA \x27%s\x27 DEFAULT CHARACTER SET utf8;SHOW DATABASES;CREATE USER \x27%s\x27@\x27localhost\x27 IDENTIFIED BY %s ; GRANT ALL PRIVILEGES ON * . * TO \x27%s\x27@'localhost'; FLUSH PRIVILEGES;SELECT Host,User,Password FROM mysql.user;' ${DB_MAGENTO} ${DB_USER} ${DB_USER_PASSWORD}  ${DB_USER})"

    旁注：脚本调用中有 3 个命令sudo。这是多余的。只需运行整个脚本sudo myscript.sh并删除添加sudo到每一行的需要。

    • 3

相关问题