[SOLVED] Problem whit special characters in shell script

px87 · 04-15-2012, 01:15 PM

Hi all!!

I'm trying to run a mysql sentence by a shell script, but I'm having troubles with the special characters:

This is my sentence:

mysql -u root -p123456 -e "GRANT ALL PRIVILEGES ON `$varx\_%` . * TO '$varx'@'localhost' IDENTIFIED BY '54321';"

and the problems are with "_" and "%" I've tried in differents ways, but I can't do it.

I hope you can help me.

Thanks!

Greetings.

sys64738 · 04-15-2012, 02:51 PM

Hi
how about:

Code:

mysql -u root -p123456 -e "GRANT ALL PRIVILEGES ON `$varx\_\%` . * TO '$varx'@'localhost' IDENTIFIED BY '54321';"

You've to quote the "%" by "\" too. The "'" maybe also.
Are you sure you want to use "`" or should it be "'"?

px87 · 04-15-2012, 03:04 PM

Quote:

Originally Posted by sys64738

Hi
how about:

Code:

mysql -u root -p123456 -e "GRANT ALL PRIVILEGES ON `$varx\_\%` . * TO '$varx'@'localhost' IDENTIFIED BY '54321';"

You've to quote the "%" by "\" too. The "'" maybe also.
Are you sure you want to use "`" or should it be "'"?

Hi! thanks for your answer.

I solved my problem 30 seg. before your answer jeje...

What I did to solve my problem is escape the "`" that is necessary to the mysql sentence:

mysql -u root -p123456 -e "GRANT ALL PRIVILEGES ON \`$varx\_%\` . * TO '$varx'@'localhost' IDENTIFIED BY '54321';"

Thanks a lot for your answer!