October 2008


Follow these steps:

1. Download MySQL Setup : mysql-5.0.67-win32.zip

2. Double click to start installation

3. After installation is complete start “MySQL Server Instance Configuration”

4. Select all default option except Charset to “Best Support Multilingualism” (for utf 8 support)

5. Once instance is created, start MYSQL Commandline Client Console using “Start > MySQL > MySQL Server 5.0 > Command Line”

6. Enter root password to continue. You will get MySQL> prompt

7. You will need to create Database first in order to start using MySQL.

8. Enxecute command “create database opencms” (note “opencms” is the name of database i have choosen)

9. I have selected other clients to continue further usage.

10. Connect to MySQL using following parameter

Database Name: opencms

JDBC Driver Class: com.mysql.jdbc.Driver

Class Location: mysql-connector-java-3.1.14-bin.jar (Note you can find this under MySQL Installation folder)

Connection URL: jdbc:mysql://localhost:3306/opencms

user ID: root

Password: ***** (this should match with the password you entered while server installation)

11. You should able to create tables and use it.

12. Create user using following command line command

create user ‘testcms’@’localhost’ IDENTIFIED BY ‘password’;

13. Grant nse user access to database using following command

GRANT ALL PRIVILEGES ON ‘opencms\_%’ . * TO ‘testcms’@’localhost’;

14.  View all available grants using following command

SHOW GRANTS FOR ‘testcms’@’localhost’;

Follow these simple steps to install and test OpenCMS.

1. Download openCMS
2. Copy/import war file into eclipse environment
3. Add opencms war project on tomcat server(you can merge steps 2 & 3 by copying war file directly uner tomcat webapp directory)
4. Configure opncms.proeprties for database connection strings
5. In case your database user doesnt have rights to create new database then follow next step
6. Use table creation script  /setup/database/mysql_41/create_tables.sql directly to create tables yourself using sql admin
7. Start tomcat server(note you will see few exceptions on console, ignore those for now, you should able to follow next steps)
7. Login to setup console using http://localhost:8080/opencms/setup/
8. Continue with steps(Note: here you need to specify the database name if its existing and uncheck the “Create Database & Table option, as we have already created tables)
9. Continue till setup imports all required files
10. Once completed, Login to application workspace using http://localhost:8080/opencms/opencms/system/login/