Cannot log onto MySQL CMS Database after network installation

Post Author: matthewh

CA Forum: Authentication

I've just installed Crystal Server XI R2 on a brand new server running MySQL 5.0.45 but when the installation completes it says it can't log on to the CMS database. It's created the empty database and I have the db.opt file in there but nothing else - no tables or anything. I've re-run the installation and done a repair and Modify but with no change. The CMS user has full rights to the MySQL instance for now, so it shouldn't have been an issue. Is there a SQL script available I can run to build the initial db manually? Do I need to uninstall and go through it all again? took over 2 hours across the network and the server is in another part of the country.