sudo mysql-create-db-and-user - SQL syntax ERROR 1064 (42000) at line 1

Hi @twc8ac35a8636,

The new script should look like this:

#!/bin/bash

# Functions
ok() { echo -e '\e[32m'$1'\e[m'; } # Green

EXPECTED_ARGS=3
E_BADARGS=65
MYSQL=`which mysql`

# Create Database
Q1="CREATE DATABASE IF NOT EXISTS $1;"
# Create User
Q2="CREATE USER IF NOT EXISTS '$2'@'localhost' IDENTIFIED BY '$3';"
# Add permissions
Q3="GRANT ALL ON *.* TO '$2'@'localhost';"
Q4="FLUSH PRIVILEGES;"
SQL="${Q1}${Q2}${Q3}${Q4}"

if [ $# -ne $EXPECTED_ARGS ]
then
  echo "Usage: $0 dbname dbuser dbpass"
  exit $E_BADARGS
fi
 
$MYSQL -e "$SQL"

ok "Database $1 and user $2 created with a password $3"

Let me know how it goes.

Hi @twc8ac35a8636,

Is mysql-create-db-and-user some kind of a custom script?

What I think happened is that with apt update and apt upgrade you’ve updated a Minor version or a NOT so minor version on MySQL which has a different syntax for the CREATE statement being used in the mysql-create-db-and-user script.

What I’ll recommend is to find the said script and update it with the new Syntax.