Just learned something interesting.

That the default directory for MySQL installed in FreeBSD is /var/db/mysql and for Linux it’s in /var/lib/mysql.

I left this hanging for a bit cause I was running out of options. I’ve added mysql connector/jdbc in classpath and still arriving at the same spot. Guess what, the solution is as simple as downloading a newer version of mysql connector/jdbc.

Hehehe…

it was high time for my awaited migration of data from excel to database. it was hassle free until i restored the migrated data to our server. it turned out that mysql reflects MS Windows’ case insensitivity (unlike linux which is case sensitive). my hibernate created tables should be like ‘This’ as i declared in mapping files. but instead, they became like ‘this’.

in order to get through this, add the line:
lower_case_table_names=0

in mysql’s my.ini

next, after redeploying the webapp, database user privileges were reset to ‘NO’. dunno where it came from. i did the same procedures, and then…

here’s a shortcut if you want to give your user all the privileges on your database. in mysql query browser key in:
grant all privileges on DBname.* to ‘DBuser’@'localhost’ identified by ‘DBpassword’;

and execute.

yay! it’ working.