ERROR 1064 (42000) MariaDB server version for the right syntax to use near '. SET = hello world WHERE . =3' at line 1

admin

Administrator
Staff member
i try to edit wordpress mysql database with :

Code:
[email protected]:~# echo "UPDATE `wp_options` SET  `option_value` =  'hello world' WHERE `option_id` =3" | mysql -u root -D dbname;
-bash: wp_options: command not found
-bash: option_value: command not found
-bash: option_id: command not found
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET   =  'hello world' WHERE  =3' at line 1

mysql --version

Code:
[email protected]:~# mysql --version
mysql  Ver 15.1 Distrib 10.1.28-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

many thanks for your help.