Forum Problems Installing LAMS: Re: Re: installation on debian sarge fails

By: David Prüm

[ Reply | Forward ]

I tried several variations but it did not work.
I think the problem is a syntax error somewhere but can't find it. 'root'@'%' ist definitely no valid database user. Login for DB-user root ist allowed from localhost, hostname and %
I get the following error message:

Buildfile: build.xml

db-prep-only:

prep_db:
[echo] This creates the database and sets username/password
[sql] Executing commands
[sql] Failed to execute: GRANT ALL PRIVILEGES ON lams01.* TO lams@localhost IDENTIFIED BY 'my password'

BUILD FAILED
/home/pruem/lams/lams-server1.0.1/lams-package/ant/build.xml:258: The following error occurred while executing this line:
/home/pruem/lams/lams-server1.0.1/lams-package/ant/build.xml:459: java.sql.SQLException: Syntax error or access violation, message from server: "Access denied for user 'root'@'%' to database 'lams01'"

Total time: 0 seconds
Buildfile: build.xml

db-prep-only:

prep_db:
[echo] This creates the database and sets username/password
[sql] Executing commands
[sql] Failed to execute: GRANT ALL PRIVILEGES ON lams01.* TO lams@localhost IDENTIFIED BY 'Foh7nooj'

BUILD FAILED
/home/pruem/lams/lams-server1.0.1/lams-package/ant/build.xml:258: The following error occurred while executing this line:
/home/pruem/lams/lams-server1.0.1/lams-package/ant/build.xml:459: java.sql.SQLException: Syntax error or access violation, message from server: "Access denied for user 'root'@'%' to database 'lams01'"

Posted by David Prüm