How to execute mysql statement from command line

Question

I need to run the below command from the command line. How do I do that on ubuntu? It works in the shell but need to execute for a chef recepie.

grant all privileges on *.* to 'root'@'%' identified by 'password';

Nehal Dattani · Accepted Answer · 2013-02-07 11:20:56Z

2

try following

echo "grant all privileges on . to 'root'@'%' identified by 'password';" | mysql -u root -p

HTH

answered Feb 7, 2013 at 11:20

Nehal Dattani

9836 silver badges15 bronze badges

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

1 Answer 1