11-23-2025, 06:42 PM
(This post was last modified: Yesterday, 05:17 PM by bob.alexander.)
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;
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;
