+- NodeActa Forum (https://nodeacta.com/forum)
+-- Forum: NodeActa (https://nodeacta.com/forum/forumdisplay.php?fid=8)
+--- Forum: Installation & Configuration (https://nodeacta.com/forum/forumdisplay.php?fid=3)
+--- Thread: Install and Configure MySQL Database Server (/showthread.php?tid=1)
Install and Configure MySQL Database Server - boban - 11-23-2025
To install MySQL Server on Linux call:
sudo apt install mysql-server-8.0
sudo mysql_secure_installation
If mysql_secure_installation does not offer to set root password, you can call:
sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password' PASSWORD EXPIRE NEVER;
To create a new user dedicated to NodeActa server call:
sudo mysql
CREATE USER 'NODEACTA'@'localhost' IDENTIFIED BY 'new password' PASSWORD EXPIRE NEVER;
GRANT ALL PRIVILEGES ON *.* TO 'NODEACTA'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;