Run MySQL command with accent mark (`) using PowerShell

Question

I would like to run a mysql command using a Powershell but getting an syntax error because of the accent mark (`).

mysql -u root -p -e "GRANT ALL PRIVILEGES ON `testuser\_%` . * TO 'testuser'@'localhost';"

mysql : ERROR at line 1: Unknown command '\_'. At line:1 char:1 + mysql -u root -e "GRANT ALL PRIVILEGES ON `testuser\_%`.* TO ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (ERROR at line 1: Unknown command '\_'.:String) [], RemoteException + FullyQualifiedErrorId : NativeCommandError

Looks like a Powershell confuses this part `testuser\_%` or \_% Any suggestions?

Let MySQL users create databases, but allow access to only their own databases

Kellen Stuart · Accepted Answer · 2017-10-25 21:36:18Z

0

Yes, because the backtick

`

is the literal escape character in PowerShell.

You can get around this by using single quotes to define your string

'

How about doing this?

$query = 'GRANT ALL PRIVILEGES ON `testuser\_%` .  * TO testuser@localhost'
mysql -uroot -p -e "$query"

answered Oct 25, 2017 at 21:36

Kellen Stuart

9,0719 gold badges72 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Run MySQL command with accent mark (`) using PowerShell

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related