Documentation Home

Data Center Audit Troubleshooting FAQ:


Visit http://www.azazia.com/support.php for the latest support and troubleshooting tips.


Q: When I type "mysql" at a cd prompt the command is not found even though I know I installed it correctly?

A: You most likely do not have the path to MySQL in your system PATH environment variable. Right click on my computer, go to properties, then click on Advanced --- environment variables. Scroll down on the bottom section and select the PATH variable and click EDIT. Add the correct path to the mysql "bin" directory then save all the way out. For example "c:\program files\mysql\mysql server 5.0\bin" would be what you would append to the end of the existing PATH statement.


Q: I have uninstalled MySQL and am attempting to re-install mysql however I am receiving an Error Number 1045 at the very last step of Configuration

A: If you have uninstalled MySQL, and are attempting to re-install and you see a message similar to the following:

The security settings could not be applied.
Error Number 1045.
Access denied for user 'root'@'localhost' (using password:NO)

You need to uninstall MySQL AND delete the directory where you previously installed MySQL


Q: Reinstalling Data Center Audit at the dca_setup.php page gives "Error: Config files exist"

A:

If you attempt to re-run the setup.php page, or you are attempting to re-install the product, you will see the following screen.


Q: I keep getting permissions denied messages when attempting to connect to Data Center Audit lab in my browser?

A: It is possible you do not have the correct permissions if you installed Data Center Audit on IIS, or UNIX, or you installed it manually. Be sure that you used "grant" to establish create,update,insert, and delete privileges onto your user. Also, be sure you ran "flush privileges" to make them active.

If you installed Data Center Audit taking all the defaults, then go to START-RUN and type CMD

At the prompt type "mysql -u root -p" and when it says enter password. Enter either "password" or simply press ENTER. If neither works then you must have changed the root password. If ENTER works, then you need to set the password for root!

To set the root password you type:

mysql -u root -p

mysql> use mysql;

mysql> update user set password=password('yourpassword') where User='root';

mysql>flush privileges;

Now point your browser to dca_setup.php and re-try the installation.