How to correctly query the mysql database from bash script?

Question

I've been trying to correctly create a user and database for an hour using the bash script, but I'm still getting error messages. I paste the code below. I will be grateful for your help!

#!/bin/bash

username="useursur"
passworduser="dnfndfvjdngdg"

sudo mysql -u $username -p$passworduser <<EOF
    CREATE USER 'wpdb'@'localhost' IDENTIFIED BY 'fsafdasdfsadfasdf';
    CREATE DATABASE wpdb;
    GRANT ALL PRIVILEGES ON wpdb.* TO 'wpdb';
    FLUSH PRIVILEGES;
EOF

I changed the command to

sudo mysql -u $username -p$passworduser -e "CREATE USER 'wpdb'@'localhost' IDENTIFIED BY 'fsafdasdfsadfasdf';CREATE DATABASE wpdb;GRANT ALL PRIVILEGES ON wpdb.* TO 'wpdb';FLUSH PRIVILEGES;"

As a result I get this error:

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table

mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'wpdb'@'localhost' — nsog8sm43x
– nsog8sm43x, Commented Feb 18, 2020 at 22:09
mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1133 (42000) at line 3: Can't find any matching row in the user table — nsog8sm43x
– nsog8sm43x, Commented Feb 18, 2020 at 22:12

Bill Karwin · Accepted Answer · 2020-02-18 22:27:20Z

0

You need to specify the user and host when you GRANT.

GRANT ALL PRIVILEGES ON wpdb.* TO 'wpdb';

Should be:

GRANT ALL PRIVILEGES ON wpdb.* TO 'wpdb'@'localhost';

answered Feb 18, 2020 at 22:27

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

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

Collectives™ on Stack Overflow

How to correctly query the mysql database from bash script?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related