I’ve just spent the whole day trying to install OpenCMS on my SuSE 9.1 box. I got stuck trying to get access to MySQL. In the end I had to delete MySQL and delete the old databases. When I reinstalled I noticed that it advised my to
mysqladmin -u root password ‘password‘
mysqladmin -u root -h hostname passwd ‘password‘
I didn’t do the latter first time around! When I fixed the error and changed the DB url to
jdbc:mysql:<em>hostname</em>:3306/ it finally all worked. Permissions on MySQL is a black art at the best of times, but I wish there was a note to this affect somewhere in the documentation. Oh, for a decent user manual!