miracle, how si that line formatted in your barnyard.conf?

It should look like this:
output log_acid_db: mysql, database your_snort_db_name, server localhost, user your_db_user, password your_password, detail full

You can also use output alert_acid_db: