Once all of them are installed, you can proceed to install MySQL server.
Install and Configure MySQL
LiteCart store it's data in MySQL. So you will need to install MySQL on your server. You can install it by running the following command:
sudo apt-get install mysql-server mysql-client -y
Once MySQL is installed, start mysql service and enable it to start on boot time with the following command:
sudo systemctl start mysqlsudo systemctl enable mysql
By default, MySQL installation is not secured, so you will need to secure it first. Next, you will also need to secure your MySQL installation. You can do this by running mysql_secure_installation script:
Answer all the questions as shown below:
Set root password? [Y/n] n
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] y
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y
Once MySQL is secured, log in to the MySQL shell and create a database for LiteCart:
mysql -u root -p
Enter your root password when prompt, then create a database for LiteCart. It is recommended to set secure password:
Here, provide all the information like, database name, database username, password, store name, admin username and password, then click on the Next button, you should see the following installation completed message:
Truth be told, it’s difficult for a web application that doesn’t have some kind of identification, even if you don’t see it as a security measure in and of itself. The Internet is a kind of lawless land, and even on free services like Google’s, authentication ensures that abuses will...
Although data persistence is almost always a fundamental element of applications, Node.js has no native integration with databases. Everything is delegated to third-party libraries to be included manually, in addition to the standard APIs. Although MongoDB and other non-relational databases are the most common choice with Node because if you...