Resetting the database

Create a backup!

Before resetting the database make sure that you have a backup of your existing database.

Helpful commands:

# backup command:
mysqldump -u [username] -p[password] --verbose [name of database] > [filename.backup.sql]

# restore command:
mysql -u [username] -p[password] [name of database] < [filename.backup.sql]

The username is "nmsprime" in a standard installation. The password was generated at the time of installation and is located in: /etc/nmsprime/env/global.env at the line "DB_PASSWORD="

You can use this command to display the password:

# Look for the database password:
cat /etc/nmsprime/env/global.env | grep "DB_PASSWORD"

Between the -p and the password is no space-character! If your passwort is "hello1234", then this part of the command will be: -phello1234

Steps for dropping and creating the database

# drop your existing databases and create the databases again
mysql -u root -p[your mysql root password] -e "DROP DATABASE nmsprime; DROP DATABASE nmsprime_ccc; CREATE DATABASE nmsprime CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci'; CREATE DATABASE nmsprime_ccc CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci';"

# change directory to the nmsprime folder
cd /var/www/nmsprime/

# use php artisan to start the migration-process
php artisan migrate
php artisan module:migrate

Troubleshooting

If you dont know your MySQL root password

If you don't know or loose your root password follow the following steps to reset your MySQL root password: (Source, Source)

# Stop the mysql service:
sudo systemctl stop mariadb.service
# Start a new safe Instance of mysql
sudo mysqld_safe --skip-grant-tables &
# Connect to MySQL
mysql -u root
# Execute the following commands and replace teh password with a secure one:
use mysql;
update user set password=PASSWORD("YOUR-NEW-ROOT-PASSWORD") where User='root';
flush privileges;
exit;
# Start the mariadb service again
sudo systemctl start mariadb

Related: Database Setup