Jump to content

Please help me understand when sql says: access denied


helloise

Recommended Posts

jenkins runs cibuild:

 

./createmysqldb test_traffic test_user password
mysql -u test_user --password=password test_traffic < ./phoenix/data/sql/lib.model.schema.sql

 

then createmysqldb:

 

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

Q1="CREATE DATABASE IF NOT EXISTS $1;"
Q2="GRANT ALL ON *.* TO '$2'@'localhost' IDENTIFIED BY '$3';"
Q3="FLUSH PRIVILEGES;"
SQL="${Q1}${Q2}${Q3}"
if [ $# -ne $EXPECTED_ARGS ]
then
  echo "Usage: $0 dbname dbuser dbpass"
  exit $E_BADARGS
fi

 

the console output in jenkins gives this:

mysql -u test_user --password=password test_traffic < ./phoenix/data/sql/lib.model.schema.sql

ERROR 1045 (28000): Access denied for user 'test_user'@'localhost' (using password: YES)

 

why is this? i dont understand

thanks

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.