This makes creating a new MEAN app with a Mysql Relational Database much simpler.

• Tanner Campbell

mkdir -p ~/projects

And change into this directory:

cd ~/projects

Clone the forked repository:

git clone [email protected]:$USERNAME/meanProject.git

Make sure to replace $USERNAME with your own GitHub username.

In order to run the code you will need to create a credentials.js in the main directory.

The credentials file should look similar to this:

module.exports = {
  port: SOME_PORT,
  url: "YOUR_URL",
  host: "DB_HOST_URL",
  user: "DB_USER",
  password: "DB_PASSWORD",
  database: "DB"
};

After the credentials file is created you can test it works in the server.js file by adding const connect = require('./connect.js'); to the file and running a simple query to your database similar the following:

connect(function(con) {
  var q = "select * from TABLE";
  try {
    con.query(q, function (err, result, fields) {
      if (err) {
        console.log(err);
      }else {
        console.log(result);
      }
    });
  }catch (err) {
    console.log(err);
  }
});

Then run the web server.

node server.js

After successfully logging the results query you can require the connect.js in any of your ./routes/files and execute queries.

From the main directory run the following command:

ng new client

In the newly created client directory open the angular.json file and change

"outputPath": "dist/client",

To

"outputPath": "../views",

RUN the Following command:

ng build

Refresh the browser and it should be working!