Automating wp-config.php creation

Question

I use Ubuntu 16.04 with Bash and I tried to run the following command set to automatically create a WordPress wp-config.php file with the WordPress Bash extension WP-CLI. Yet I'm having some problem I miss (Bash related?).

loh="127.0.0.1"
drt="/var/www/html"
domain="example-xyz.com"
dbuserp_1="example-xyz.password"

rm -rf "$drt/$domain"/ 2>/dev/null
wp core download --path="$drt/$domain" --allow-root

wpConfig() {
    rm -rf "$drt/$domain"/ 2>/dev/null
    wp core download --path="$drt/$domain" --allow-root
    wp config create \
    --path=${drt}/${domain} \
    --dbname=${domain} \
    --dbuser=${domain} \
    --dbpass=${dbuserp_1} \
    --dbhost=${loh} \
    --allow-root
}
wpConfig

I double checked that the DB user password I use is correct.

And yet, I get this error:

ERROR 1045 (28000): Access denied for user 'example-xyz.com'@'localhost' (using password: YES)

Changing all ${x} to "$x" changed nothing.

I fail to understand why I get the above error (what does it have to do with MySQL itself, as this error seem MySQL related).

Answer 1

If your MySQL database and/or user aren’t created before you run wp config create, you need to tell it to skip the database check:

wp config create --skip-check ...

This will create wp-config.php with the parameters you specify, and it won’t fail if it can’t connect to the database.

Answer 2

Seems like MySQL error. You are either entering wrong password or MySQL is setup with no password for example-xyz.com . Are you sure you have configure the user in MySQL? Normally you will have to replace the example username and password with the ones you configured while configuring MySQL during installation, or with any other user added later on.