I have just started using Lunar Pages. I have a java application (which uses hibernate) which I am trying to deploy.
Uses the following jdbc connection

jdbc:mysql://localhost/myedge0_myedgedb?zeroDateTimeBehavior=convertToNull

DB name = myedge0_myedgedb
DB user  = myedge0_root

 I get the following error:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command
denied to user 'myedge0_root'@'localhost' for table 't_grade_year_master'

I created root user using cPanel interface and gave ALL privileges to it.

cPanel does not allow me to grant permissions using GRANT ALL command.

I would really appreciate if someone can provide some pointer.

Diwakar