I have just got jserve installed on our servers. I would like the exact instructions how to set up mysql for it. Mysql has already been installed on our server.
posted 14 years ago
I suppose it'd be difficult to give exact instructions. But given that JServ and MySQL are installed, you should now install a driver so servlets you can user JDBC for MySQL access. http://www.mysql.com/downloads/api-jdbc.html Then, depending on what kind of security you want on your databases, you have to create a MySQL user someuser@"%" who has with the appropriate privileges. Do something like GRANT ALL PRIVILEGES ON my_jdbc_database.* TO someuser IDENTIFIED BY 'somepassword'; For tighter security, replace "ALL PRIVILEGES" with "SELECT" or "UPDATE". After creating the user reload MySQL with # ./mysqladmin reload �p Then you create a servlet in your repository that can read data from my_jdbc_database. You can find example code on the web for this with the mm driver documentation.