I added the new user and a password in MySQL but I can connect to the rptdata database. What is wrong?
Make sure you assign the correct privileges on the database named “rptdata” (for the report writing program) and the database named “caddata” (for the dispatch program). You must assign the following privileges for these tables for the user “free01” (report writing program) and the user “freecad” using MySQL. • Select • Insert • Update • Delete After assigning the above listed privileges to the databases using MySQL, you must restart the MySQL Server or the changes will go unnoticed. For more information on how to add users to the MySQL Server, see here. If you read further down this FAQ, you will see additional information on how to add users to the MySQL Server here.
