Install NodeJS, mySQL on VPS
Connect to VPS via SSH
NodeJS
sudo apt update
sudo apt install nodejs
node -v
sudo apt install npm
Configure MySQL
Configure MySQL
sudo apt install mysql-server
sudo service mysql status
sudo service mysql restart
Configure MySQL
You can edit the files in /etc/mysql/ to configure the basic settings – log file, port number, etc. For example, to configure MySQL to listen for connections from network hosts, in the file /etc/mysql/mysql.conf.d/mysqld.cnf, change the bind-address directive to the server’s IP address:
bind-address = 192.168.0.5
Replace 192.168.0.5 with the appropriate address, which can be determined via the ip address show command.
After making a configuration change, the MySQL daemon will need to be restarted with the following command:
sudo systemctl restart mysql.service
