Thursday, 15 May 2014

Grails 2.2.0 mysql access rights and permissions -



Grails 2.2.0 mysql access rights and permissions -

i've started getting weird access denied errors running grails 2.2.0 , mysql (mysql ver 14.14 distrib 5.6.10, osx10.7 (x86_64) using editline wrapper) on mac os x.

caused by: java.sql.sqlexception: access denied user 'nfuser'@'localhost' (using password: yes)

sample code

datasource { pooled = true driverclassname = "com.mysql.jdbc.driver" username = "nfuser" password = "nfuser" dialect = org.hibernate.dialect.mysql5innodbdialect } .. development { datasource { dbcreate = "create-drop" // 1 of 'create', 'create-drop', 'update', 'validate', '' url = "jdbc:mysql://localhost:3306/nf_dev" } }

the usual grants , db create before running grails.

grant on nf_dev.* 'nfuser'@'%' identified 'nfuser';

tested brand new project , of course of study works.. ideas?

/s

duuh, external property file override on datasource.password..

mysql grails

No comments:

Post a Comment