Access mysql using shell script

Question

I want to login to mysql console and set the max packet variable and then exit from the mysql console. I have written the following:

mysql -u root -proot
SET GLOBAL max_allowed_packet=509715201
exit

it only login to mysql and doesn't do anything else.

This might help: How to change max_allowed_packet size

Cyrus
– Cyrus

2017-01-29 09:00:58 +00:00
Commented Jan 29, 2017 at 9:00 — Cyrus
– Cyrus, Commented Jan 29, 2017 at 9:00

jacob · Accepted Answer · 2017-01-29 09:28:32Z

1

#!/bin/bash

mysql << EOF
SET GLOBAL max_allowed_packet=509715201;
quit
EOF

You should use shell's here documents to execute sql statement.

Quote from Advanced Bash-Scripting Guide:

A here document is a special-purpose code block. It uses a form of I/O redirection to feed a command list to an interactive program or a command, such as ftp, cat, or the ex text editor.

edited Jan 29, 2017 at 9:28

answered Jan 29, 2017 at 9:22

jacob

7116 silver badges15 bronze badges

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

9 Comments

Vivek Sadh Over a year ago

Still it doesn't work. Can you please elaborate EOF.

jacob Over a year ago

EOF is just a tag for shell's here documents. Execute the above shell script, what's your output?@Vivek Sadh

Vivek Sadh Over a year ago

I think I should also specify username and password to log in. Right ? I do mysql -u root -proot << EOF and get nothing as output.

Cyrus Over a year ago

If everything was okay with your SET command there‘s no output.

Vivek Sadh Over a year ago

Thanks. Multiple of 1024 works. See my answer. I tried using a different command.

|

Vivek Sadh · Accepted Answer · 2017-01-29 12:53:44Z

0

Thanks. I figured it out:

mysql -u root -proot -Bse "SET GLOBAL max_allowed_packet=509715456"

answered Jan 29, 2017 at 12:53

Vivek Sadh

4,2683 gold badges35 silver badges55 bronze badges

Collectives™ on Stack Overflow

Access mysql using shell script

2 Answers 2

9 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related