i try to edit wordpress mysql database with :
mysql --version
many thanks for your help.
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.