![]() Securing Ubuntu SimpleRisk User/Root Passwords:ġ) Log in to the VM via the console (or enable SSH access and log in that way) using user "simplerisk" and password "simplerisk".Ģ) Once logged in type “passwd”, this will ask you for the old password which is “simplerisk” then ask you to repeat your new password twice to confirm the change. That will complete the encryption process for VMware based virtual machines. You will need this password each time the VM is started. ![]() Follow the prompts and define your password. (must be a paid for product such as Workstation Player Pro)ġ) With the VM shut down Right Click the the name of the VM and click Settings.Ģ) Now go from the Hardware tab to the Options tab and find the Access Control option in the list.ģ) Next click "Encrypt". This completes the process for VirtualBox encryption. Your password will be used every time the VM is started.Ĥ) Click "Ok" and a progress bar will be shown as your disk is encrypted. Once downloaded just double-click it and it should bring up the prompts to install it in VirtualBox.Ģ) With the VM currently shutdown and VirtualBox open Right-Click the VM's name on the left hand side and go to the Settings menu.ģ) Next as seen in the picture below from the General menu click the Disk Encryption tab and fill out the fields as seen in the screenshot. To update the password for the simplerisk user.ġ0) Run the command "cd /var/Find the line that reads "DB_PASSWORD" and update the password to the value used for "newPass" above.ġ) You will first need to obtain the VM VirtualBox Extension pack to support encryption if you do not have this already it can be obtained from their website here: When prompted the original password was located in your passwords.txt.Ĥ) Log into mysql as root with the command "mysql -u root -p" and enter the new root password.Ħ) Run the command "ALTER USER IDENTIFIED BY 'newPass' " Now use "ls" to see the files there and finally "vi root_mysql_password.txt" or the current name used for the root password file.ģ)Run the command "mysqladmin -u root -p password MyNewRootPass" to change the password for root. You will want to have strong passwords to replace these with and store them securely.ġ) Log in to the VM via the console (or enable SSH access and log in that way) using user "simplerisk" and the password "simplerisk".Ģ) Use "sudo bash" enter the password "simplerisk"Ģ) Grab the current root password created when the VM booted for the first time by doing "cd /root". We strongly recommend anyone using the VM to update these passwords before extensive use of the VM image. This short guide will go over the steps required to remove and replace the original “simplerisk” passwords for the SimpleRisk VM. ![]() replace matomo by your chosen MySQL username (or simply use matomo).Solution home SimpleRisk Core Frequently Asked Questions (FAQ) How to Secure Your SimpleRisk VM.replace my-strong-password-here by a strong secure password.replace matomo_db_name_here with the name of your MySQL database (if possible, this database should only have the Matomo tables installed).(OPTIONAL) Grant this user matomo the FILE global privilege: (if enabled, reports will be archived faster thanks to the LOAD DATA INFILE feature) $ mysql> GRANT FILE ON *.* TO these instructions: Grant this user matomo the permission to access your matomo_db_name_here database $ mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON matomo_db_name_here.* TO is important to grant the user the following privileges: SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES Or if you are using an older version such as MySQL 5.1, MySQL 5.5, MySQL 5.6: $ mysql> CREATE USER IDENTIFIED BY 'my-strong-password-here' If you are installing Matomo (Piwik) on your own server and/or don’t have a tool available to manage your database, you can manually create the MySQL database user by following these steps:Ĭreate a database for Matomo: $ mysql> CREATE DATABASE matomo_db_name_here Ĭreate a user called matomo, if you are using MySQL 5.7 or MySQL 8 or newer: $ mysql> CREATE USER IDENTIFIED WITH mysql_native_password BY 'my-strong-password-here' To create your database and database user, you would typically use your web hosting provider interface which would let you add a new MySQL database and create a new user with permission to access this database, in just a few clicks. When installing Matomo you need to specify a MySQL (or MariaDB) database hostname, user and password.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |