[opencms-dev] Database could not be created! Error connecting to database using:

[Matthew Edwards]

Hi Jurvis,
You will need tomake sure that your MySQL user permissions are correct i.e.
You will need a privileged user to create the database.. i.e 
root at localhost (if the database is on the local machine)... This account is used to create the databases to be used by the users you have created for opencms to use (generally opencms at localhost & opencms@%).
Try the following (assuming your mysql is in the class path/ your root at localhost has no password/ and you want to use opencms as your user with password as the password)

C:\>mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.1.8-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on opencms.* to opencms at localhost identified by "password";
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on opencms.* to opencms@"%" identified by "password";
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

C:\>

Hope this helps
Kind Regards 
Matt Edwards
Software Developer
Computing is Social Pty Ltd.