Can I use MySQL for my database?
A. Yes. The procedure for Windows users is: • Download and install MySQL from www.mysql.com. It will set up Windows services for the databases, etc. etc. • Copy the mysql.sql file from C:\Program Files\ASM\data\sql to C:\ • Open a MySQL console. If there’s no start menu item for it, go to C:\Program Files\MySQL\bin and double click mysql • Enter the following SQL commands at the mysql> prompt: CREATE DATABASE asm; USE asm; SOURCE c:\mysql.sql (lots of output will be displayed) GRANT ALL PRIVILEGES ON *.* TO root@’%’; QUIT; • Edit the file: C:\Documents and Settings/YOURUSER/.asm/jdbc.properties • Replace any existing contents of the file with this line: JDBCURL=jdbc:mysql://localhost/asm?user=root&zeroDateTimeBehaviour=convertToNull • For each machine on your network, substitute localhost in the above line of that file for the IP address of the machine running MySQL. For Linux/other platform users the procedure is the same, except you should install MySQL from your distribution and “c
