MySQL hints

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 -

cd c:\xampp\mysql\bin
mysql -u root -popenauditrootuserpassword

Linux -

mysql -u root -popenauditrootuserpassword


Both the commands below are useful to see statistics about MySQL.

SHOW global status LIKE '%onn%';
SHOW processlist;
SHOW status WHERE `variable_name` = 'Threads_connected';
SELECT * FROM information_schema.processlist;


Some Linux specific commands are below for the shell (bash).

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.

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