helloise Posted February 17, 2012 Share Posted February 17, 2012 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 Link to comment https://forums.phpfreaks.com/topic/257178-please-help-me-understand-when-sql-says-access-denied/ Share on other sites More sharing options...
trq Posted February 17, 2012 Share Posted February 17, 2012 Because test_user does not have permission to access the server from localhost. Link to comment https://forums.phpfreaks.com/topic/257178-please-help-me-understand-when-sql-says-access-denied/#findComment-1318495 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.