Statistics, Processes and Performance
Sometimes you may wish to see more of what's happening at the MySQL level. It may be because of performance or some other issue. Below are some options that can be taken. Log on to MySQL as root.
Windows -
Code Block |
---|
cd c:\xampplitexampp\mysql\bin mysql -u root -popenauditrootuserpassword |
...
Code Block |
---|
sudo mysqladmin processlist mysqladmin status netstat -nat | grep 3306 |
...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
Changing the Open-AudIT users MySQL password.
The default passwords can be found on theĀ Information about default users and passwords page.
At your command prompt.
Code Block |
---|
mysql -u root -p mysql
<enter the root password>
UPDATE mysql.user SET Password=PASSWORD('new-password-here') WHERE USER = 'openaudit';
FLUSH PRIVILEGES;
exit; |
After that you should edit the file
Versions prior to v5 = /usr/local/open-audit/code_igniter/application/config/database.php and set $db['default']['password'] to the password (in plain text).
Versions 5 and up = /usr/local/open-audit/app/Config/Database.json