msyql - scripting

Piotr Kirklewski — Thu, 02 Dec 2010 04:00:12 GMT

Hi there

I want to do this from a script:

mysql -u root
GRANT ALL ON *.* TO 'xxx'@'localhost'IDENTIFIED BY 'xxx';
quit;

If I just stick "mysql -u root" inside a script then it opens mysql and wait's for user interaction. I need to grant the permissions for a certain user and move to other commands.

Reagrds

Re: msyql - scripting

Mel Burslan — Thu, 02 Dec 2010 06:56:09 GMT

The construct you are looking for is something like this :

...
other commands here
...

mysql -u root <GRANT ALL ON *.* TO 'xxx'@'localhost'IDENTIFIED BY 'xxx';
quit;
EOF

...
more commands here
...

hope this helps

topic msyql - scripting in Operating System - HP-UX

msyql - scripting

Re: msyql - scripting