Change mysql root user password using shell script

Question

I am trying to change user password using a shell script as below

#!/bin/bash
mysql.server start
mysql -u root << EOF
  SET PASSWORD FOR root@'localhost' = PASSWORD(‘admin’);
EOF

But I am getting below error:-

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘admin’)' at line 1

Instead of SET PASSSWORD command if use something else will work like if I use 'create database databasename' will works.

.

Update1:

If I use "admin" or 'admin' instead of ‘admin’, I got below error.

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '“admin2”)' at line 1

.

Update2:

When using -e flag I got below error

./mysql.sh: line 3: syntax error near unexpected token (' ./mysql.sh: line 3:mysql -u root -padmin -e “SET PASSWORD FOR root@'localhost' = PASSWORD(‘admin2’);”'

‘admin’ can you wrap in these quotes? Try "admin" or 'admin' instead — Gravy
– Gravy, Commented Feb 14, 2017 at 10:30

David Moles · Accepted Answer · 2020-11-13 20:13:23Z

15

use mysql -e instead:

#!/bin/bash
mysql.server start
mysql -u root -e "SET PASSWORD FOR root@'localhost' = PASSWORD('admin');"

edited Nov 13, 2020 at 20:13

David Moles

51.7k30 gold badges152 silver badges249 bronze badges

answered Feb 14, 2017 at 10:35

Bernd Buffen

15.1k2 gold badges27 silver badges41 bronze badges

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

1 Comment

Anand Suthar Over a year ago

I think issue was due to some editor, I wrote same script using another editor and vola your and mine script both will work. Thanks for replying.

mikko-lauhakari · Accepted Answer · 2019-01-18 14:12:23Z

1

For anyone trying above and not getting it to work. I ran the below in my terminal and it worked! (Remember to set the password you want ;) )

mysql -u root -e "SET PASSWORD FOR root@localhost = PASSWORD('mypassword')";

answered Jan 18, 2019 at 14:12

mikko-lauhakari

512 bronze badges

Collectives™ on Stack Overflow

Change mysql root user password using shell script

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related