Testing and Configuring MySQL

1. Download and Install MySql from http://mysql.org/.
2. Once MySQL is installed, start the server from the command prompt by typing mysqld --console.If the system complains, either the [MySQL-dir]/bin is not in your path or MySQL is not configured properly.Switch to [MySQL-dir]/bin directory and try again. If the server starts up correctly, you should see InnoDB messages.
   
   
3. Open another command prompt and type mysql -u root -p mysql. This creates a user root. Press [ENTER] when prompted for a password. This will create a blank password.
4. Create a database named testdb using the following command CREATE DATABASE testdb;
5. To grant root user full privileges on testdb type, GRANT ALL ON testdb.* TO root@localhost;.
   
   
6. To test this database, type USE testdb; followed by SHOW DATABASES; to set testdb as the working database and show all databases. You should see testdb over there.
   
   
7. We now have to ensure Sesame works well with MySQL. For this sesame needs the MySQL JDBC driver file called mysql-driver.jar.Make sure that the mysql-driver.jar file is present in the [Tomcat-dir]/webapps/sesame/lib directory. If the file is present proceed to step 11.
8. Incase you don't find them, you can find the mysql-driver.jar file in prdfdb.zip which can be downloaded from http://protege.stanford.edu/plugins/rdfs-db/prdfdb.zip .
9. After downloading, extract the contents of prdfdb.zip file.
10. Copy mysql-driver.jar from [prdfdb-dir]\edu.stanford.smi.protegex.storage.rdfdb dir and paste it into the
    [Tomcat-dir]/webapps/sesame/lib directory.Stop the Tomcat server and restart it again.
11. Now quit the MySql monitor and stop the MySql server. Restart the MySql server once again.
12. Open a browser to http://localhost:8080/sesame/ .Log in as testuser with password opensesame.
13. Select MySQL RDF Test DB and click Go > >.
    
    
14. If you do not see HTTP Status 500, your installation was successful.
    
    


15. To proceed next click hereSetting up the Plugin